Transaction CSV Tool – 12/09/22
An update to improve SR & PP processing when VAT Cash accounting
Importing SR and PP Transactions when Cash VAT Accounting is in use:
When Cash VAT Accounting is enabled in Sage 50 transaction types SA, SR, SP, PA, PP and PR should normally include the same Tax Code and Tax Amount as the Invoice(s) or Credit Note(s) that the payment will be allocated to.
In order to make it easier to import a payment for an invoice that has more than one tax code the importer will automatically change the Tax Code and Amounts on SR and PP transactions to match the invoice(s) that the payment is being allocated to.
For example, If you import an SR transaction that matches a multi line invoice that includes both T0 and T1 transactions, the importer will automatically create two SR transactions in Sage. One with the T0 portion of the payment and the other with the T1 portion. The Tax Code specified on the SR row in the CSV file is only used if the importer has to create an unallocated SA transaction as mentioned above.
The full amount of the payment can be entered in the Net Amount column of the CSV file in which case the Tax Amount column should be zero. If you do enter a Tax Amount it will be added to the Net Amount to get the full amount of the payment.
This Improvement is available in Transaction CSV v28.0.82 and upwards, here’s a link for how you can update your Adept Tool.
The Adept Team