Jiwa

Hi,

I have a client who is looking to generate an ABA file for Customer Direct Debits
Has anyone already developed a plugin or other solution for this one.

Thanks

Isn't that basically the same as the creditor ABA but with a different transaction code?

pricerc wrote:Isn't that basically the same as the creditor ABA but with a different transaction code?

Probably, but instead of being a button on the creditor EFT batch form, you'd want it on the cash book receipts form.

It should be a pretty simple plugin.

You know you're getting old when you forget work that you've done within the past couple of months...

I actually did this for a customer a few months back. For NZ's BNZ bank, but the process is the same, and you'd just need to change the output file format.

If you still need it, I can make sure there's nothing customer-specific in it (I don't think there is) and upload the plugin.

The plugin actually does a couple of things.

There is a stored procedure that generates XML for a Cashbook receipt batch.

A button on the CB receipt screen calls this stored procedure, and uses the XML to create a new batch, complete with allocations.

A second button creates the actual file to upload to the bank.

So attached is my plugin, 'cleaned' of site-specific information.

The stored procedure will need to be tweaked as required. Ledger accounts and payment type are hard-coded into the stored procedure - I figured it unlikely that more than one bank account would be used for direct debits...

One convenient way of identifying what accounts you need is to manually create a batch with all the right details and export the XML, then look at the resulting XML file to get the IDs for Payment Type, Bank Account, GL Account.

Identifying debtors to charge is also up to the implementor. My customer used comment text from S/O lines, but that doesn't seem a good way of doing things to me.

If you don't need the batch generated, you could also just use the 'export file' part of the plugin (obiously adapted it for the relevant bank's requirements).

Abstract permissions are for generating and exporting the Direct Debit, and will need to be assigned to the right people.