One of our clients who was in the process of implementing Sage 200, wanted to integrate their current industry specific system with Sage 200 using our Data Exchange module. The client wanted to retain some of the functionality of Sage 50 and required us to amend the system so that was possible.
Their industry specific system exports a Sage Nominal transaction import file. This file would therefore be automatically imported via the Sage import nominal transaction routine using the Data Exchange. This imported file will affect the debtors for invoices and also any receipts.
In order to meet the above requirements we amended the Data Exchange module to carry out the following processes at the point of a Nominal Transaction Import.
- Check that the posting Nominal account was used as a Cashbook nominal control account
- If the Nominal Account was not a Cashbook Nominal Control Account then the import would continue as normal.
- If the Nominal Account was a Cashbook Nominal Control Account then the import continues as normal importing the transaction. It also creates a Nominal non-taxable receipt/payment depending on the value being positive/negative.
The non-taxable receipt/payment uses the Cashbook account as the receipt/payment account and debit or credit the Cashbook Nominal Control Account for the value of the receipt/ payment
This routine clears the original nominal posting, adding it again via the cashbook and allowing the client to use the reconciliation tool via Sage 200.
For this to work a control account was created for every possible Cashbook account. Duplicated cashbook accounts to a single Nominal control results in the file being rejected.
For more details about our bespoke solutions please contact the office on 01355 581 960 or email firstname.lastname@example.org