by pricerc » Sun May 28, 2023 1:21 am
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.
- Attachments
-
- Plugin BNZ Direct Debit Cashbook Integration.xml
- BNZ Direct Debit Plugin
- (167.97 KiB) Downloaded 79 times