示例#1
0
    def test_add_batch_no_start_entry_counter(self):
        settings = {
            'company_id': '999999999',
            'company_name': 'CAULIFLOWER LTD',
            'immediate_dest': '123456789',
            'immediate_dest_name': 'DESTRO INC',
            'immediate_org': 'ORANG LLC',
            'immediate_org_name': 'ORANG LLC',
            'file_gen_datetime': datetime(2020, 1, 1)
        }

        entries = [{
            'type': '22',
            'routing_number': '234567890',
            'account_number': '3456789012',
            'amount': 45.67,
            'name': 'Nonce Cornelius',
            'id_number': '5555555555',
        }]

        f = AchFile('A', settings)
        f.add_batch(std_ent_cls_code='PPD', batch_entries=entries)

        lines = f.render_to_string().split('\n')
        entry_line = lines[2].split()
        assert entry_line[len(entry_line) - 1] == '0123456780000001'
示例#2
0
    def generate_ach_file(self):
        self.ensure_one()

        inbound_payment = self.payment_type == "inbound"

        file_mod = self.get_file_id_mod()
        ach_file = AchFile(file_id_mod=file_mod, settings=self.ach_settings())
        filename = "{today}_{bank}_{file_mod}.txt".format(
            today=fields.Date.today(),
            bank=self.company_partner_bank_id.id,
            file_mod=file_mod,
        )
        entries = []
        for line in self.bank_line_ids:
            if inbound_payment:
                self.validate_mandates(line)
            self.validate_banking(line)
            amount = line.amount_currency

            entries.append(
                {
                    "type": self.get_transaction_type(amount=amount),
                    "routing_number": line.partner_bank_id.bank_id.routing_number,
                    "account_number": line.partner_bank_id.acc_number,
                    "amount": str(amount),
                    "name": line.partner_id.name,
                    "addenda": [{"payment_related_info": line.communication}],
                }
            )
        outbound_payment = self.payment_type == "outbound"
        ach_file.add_batch(
            "PPD", entries, credits=outbound_payment, debits=inbound_payment
        )
        return ach_file.render_to_string().encode("utf-8"), filename
class TestLineEndings(object):
    def setup(self):

        self.settings = {
            'immediate_dest' : '123456780',
            'immediate_org' : '123456780',
            'immediate_dest_name' : 'YOUR BANK',
            'immediate_org_name' : 'YOUR COMPANY',
            'company_id' : '1234567890', #tax number
        }

        self.ach_file = AchFile('A', self.settings) #file Id mod

        self.entries = [
            {
                'type'           : '22', # type of
                'routing_number' : '12345678',
                'account_number' : '11232132',
                'amount'         : '10.00',
                'name'           : 'Alice Wanderdust',
                'addenda' : [
                    {
                        'payment_related_info': 'Here is some additional information',
                    },
                ],
            },
            {
                'type'           : '27',
                'routing_number' : '12345678',
                'account_number' : '234234234',
                'amount'         : '150.00',
                'name'           : 'Billy Holiday',
            },
            {
                'type'           : '22',
                'routing_number' : '123232318',
                'account_number' : '123123123',
                'amount'         : '12.13',
                'name'           : 'Rachel Welch',
                'id_number'      : '3333',
            },
        ]

        self.ach_file.add_batch('PPD', self.entries, credits=True, debits=True)

    def test_normal(self):
        ach_output = self.ach_file.render_to_string()

        rows = ach_output.split('\n')
        nt.assert_equals(len(rows), 10)
        for row in rows:
            nt.assert_equals(len(row), 94)

    def test_force_crlf(self):
        ach_output = self.ach_file.render_to_string(force_crlf=True)

        rows = ach_output.split('\r\n')
        nt.assert_equals(len(rows), 10)
        for row in rows:
            nt.assert_equals(len(row), 94)
示例#4
0
def create_ach_files(content):
    lines = content.splitlines()
    for i in range(0, len(banks)):  # For each bank
        ach_file = AchFile('A',
                           create_setting_entry(lines))  # Initiate ACH file
        entries = []
        for j in range(2, len(lines)):  # Read lines
            if lines[j][3:11] == banks[i][
                    0]:  # If match for destination (RDFI)
                # Add an entry
                routing_number = lines[j][3:11]  # RDFI bank (customer's bank)
                account_number = lines[j][12:29]  # Customer account number
                amount = str(float(lines[j][29:39]) / 100)  # Amount
                name = lines[j][54:76]  # Customer name
                entries.append({
                    'type': '27',  #  We're creatign debits only
                    'routing_number': routing_number,
                    'account_number': account_number,
                    'amount': amount,
                    'name': name
                })
        if len(entries) != 0:  #We have transactions
            ach_file.add_batch('POS', entries, credits=True, debits=True)
            # Save generated file to merchant-upload bucket
            bucket_name = 'ach-rdfi-' + banks[i][
                0]  # Based on RDFI rounting number
            file_name = str(uuid.uuid4()) + '.ach'  # Generate unique name
            ach_content = ach_file.render_to_string()
            save_file(bucket_name, file_name, ach_content)
class TestLineEndings(object):
    def setup(self):

        self.settings = {
            'immediate_dest' : '123456780',
            'immediate_org' : '123456780',
            'immediate_dest_name' : 'YOUR BANK',
            'immediate_org_name' : 'YOUR COMPANY',
            'company_id' : '1234567890', #tax number
        }

        self.ach_file = AchFile('A', self.settings) #file Id mod

        self.entries = [
            {
                'type'           : '22', # type of
                'routing_number' : '12345678',
                'account_number' : '11232132',
                'amount'         : '10.00',
                'name'           : 'Alice Wanderdust',
                'addenda' : [
                    {
                        'payment_related_info': 'Here is some additional information',
                    },
                ],
            },
            {
                'type'           : '27',
                'routing_number' : '12345678',
                'account_number' : '234234234',
                'amount'         : '150.00',
                'name'           : 'Billy Holiday',
            },
            {
                'type'           : '22',
                'routing_number' : '123232318',
                'account_number' : '123123123',
                'amount'         : '12.13',
                'name'           : 'Rachel Welch',
            },
        ]

        self.ach_file.add_batch('PPD', self.entries, credits=True, debits=True)

    def test_normal(self):
        ach_output = self.ach_file.render_to_string()

        rows = ach_output.split('\n')
        nt.assert_equals(len(rows), 10)
        for row in rows:
            nt.assert_equals(len(row), 94)

    def test_force_crlf(self):
        ach_output = self.ach_file.render_to_string(force_crlf=True)

        rows = ach_output.split('\r\n')
        nt.assert_equals(len(rows), 10)
        for row in rows:
            nt.assert_equals(len(row), 94)
    def setup(self):

        self.settings = {
            'immediate_dest': '123456780',
            'immediate_org': '123456780',
            'immediate_dest_name': 'YOUR BANK',
            'immediate_org_name': 'YOUR COMPANY',
            'company_id': '1234567890',  #tax number
        }

        self.ach_file = AchFile('A', self.settings)  #file Id mod

        self.entries = [
            {
                'type':
                '22',  # type of
                'routing_number':
                '12345678',
                'account_number':
                '11232132',
                'amount':
                '10.00',
                'name':
                'Alice Wanderdust',
                'addenda': [
                    {
                        'payment_related_info':
                        'Here is some additional information',
                    },
                ],
            },
            {
                'type': '27',
                'routing_number': '12345678',
                'account_number': '234234234',
                'amount': '150.00',
                'name': 'Billy Holiday',
            },
            {
                'type': '22',
                'routing_number': '123232318',
                'account_number': '123123123',
                'amount': '12.13',
                'name': 'Rachel Welch',
                'id_number': '3333',
            },
        ]

        self.ach_file.add_batch('PPD', self.entries, credits=True, debits=True)
示例#7
0
    def setup(self):

        self.settings = {
            'immediate_dest' : '123456780',
            'immediate_org' : '123456780',
            'immediate_dest_name' : 'YOUR BANK',
            'immediate_org_name' : 'YOUR COMPANY',
            'company_id' : '1234567890', #tax number
        }

        self.ach_file = AchFile('A', self.settings) #file Id mod

        self.entries = [
            {
                'type'           : '22', # type of
                'routing_number' : '12345678',
                'account_number' : '11232132',
                'id_number'      : '123456789ABCDEFGH',
                'amount'         : '10.00',
                'name'           : 'Alice Wanderdust',
                'addenda' : [
                    {
                        'payment_related_info': 'Here is some additional information',
                    },
                ],
            },
            {
                'type'           : '27',
                'routing_number' : '12345678',
                'account_number' : '234234234',
                'id_number'      : '123456',
                'amount'         : '150.00',
                'name'           : 'Billy Holiday',
            },
            {
                'type'           : '22',
                'routing_number' : '123232318',
                'account_number' : '123123123',
                'amount'         : '12.13',
                'name'           : 'Rachel Welch',
            },
        ]

        self.ach_file.add_batch('PPD', self.entries, credits=True, debits=True)
示例#8
0
from ach.builder import AchFile

settings = {
    'immediate_dest': '123456780',
    'immediate_org': '123456780',
    'immediate_dest_name': 'YOUR BANK',
    'immediate_org_name': 'YOUR COMPANY',
    'company_id': '1234567890',  #tax number
}

ach_file = AchFile('A', settings)  #file Id mod

entries = [
    {
        'type':
        '22',  # type of
        'routing_number':
        '12345678',
        'account_number':
        '11232132',
        'amount':
        '10.00',
        'name':
        'Alice Wanderdust',
        'addenda': [
            {
                'payment_related_info': 'Here is some additional information',
            },
        ],
    },
    {
from ach.builder import AchFile

settings = {
    'immediate_dest' : '123456789',
    'immediate_org' : '123456789',
    'immediate_dest_name' : 'YOUR BANK',
    'immediate_org_name' : 'YOUR COMPANY',
    'company_id' : '1234567890', #tax number
}

ach_file = AchFile('A', settings) #file Id mod

entries = [
    {
        'type'           : '22', # type of
        'routing_number' : '12345678',
        'account_number' : '11232132',
        'amount'         : '10.00',
        'name'           : 'Alice Wanderdust',
    },
    {
        'type'           : '22',
        'routing_number' : '12345678',
        'account_number' : '234234234',
        'amount'         : '150.00',
        'name'           : 'Billy Holiday',
    },
    {
        'type'           : '22',
        'routing_number' : '12323231',
        'account_number' : '123123123',
示例#10
0
                                      password=db_password,
                                      host=db_host,
                                      database=db_db)
        cursor = cnx.cursor()
        query = 'INSERT INTO merchant_upload(time,entry) SELECT CURRENT_TIMESTAMP(), 1;'
        cursor.execute(query)
        cnx.commit()
        cursor.close()
        cnx.close()

    except Exception as e:
        logging.error(f"Unexpected error: {e}")
        raise


# Initialize a new ACH file
ach_file = AchFile('A', create_setting_entry())

# Create entries
entries = create_transactions_entries()

# Populate ACH file with generated entries
ach_file.add_batch('POS', entries, credits=True, debits=True)

# Save generated file to merchant-upload bucket
bucket_name = 'ach-merchant-upload'
file_name = str(uuid.uuid4()) + '.ach'
content = ach_file.render_to_string()
save_file(bucket_name, file_name, content)
update_merchant_upload()
示例#11
0
from ach.builder import AchFile

settings = {
    "immediate_dest": "123456780",
    "immediate_org": "123456780",
    "immediate_dest_name": "YOUR BANK",
    "immediate_org_name": "YOUR COMPANY",
    "company_id": "1234567890",  # tax number
}

ach_file = AchFile("A", settings)  # file Id mod

entries = [
    {
        "type": "22",  # type of
        "routing_number": "12345678",
        "account_number": "11232132",
        "amount": "10.00",
        "name": "Alice Wanderdust",
        "addenda": [{"payment_related_info": "Here is some additional information"}],
    },
    {
        "type": "27",
        "routing_number": "12345678",
        "account_number": "234234234",
        "amount": "150.00",
        "name": "Billy Holiday",
    },
    {
        "type": "22",
        "routing_number": "123232318",