Data Import Query Relating To Cheque Payments
Posted: 18 May 2007, 10:23
We use SAGE Line 50 Version 13.
I want to prepare batches of cheques using the “Paymentâ€
I want to prepare batches of cheques using the “Paymentâ€
I think you can import Bank Payments in standard Sage.
You can not import the payment details, you probably could print cheques from your other application.
The transaction you would import is a audit trail transaction of type "BP"
more details here
http://sage.support.makingithappen.co.u ... ttrans.htm
Doesn't seem to be documented, so, I would just try it and see first.
----------------------------------
The custom importer (£225) would do it for sure, you could get the remittances/cheques to work by putting them through a single dummy account on the purchase ledger and matching everything off as you go.
It would be a chain of imports, an import to update the purchase ledger account details so they have the right name address etc, and import of the transactions an invoice and a payment, then matching off that payment, then repeat the process for the next payment.
How much control do you have on the output?
The process would not be super quick, if you have very large volumes thousands you could set it running when you go home at night and it will be done in the morning.
You might want a customised import script to make it easy to do £130
Contact me if you want more info on it.
http://www.makingithappen.co.uk/feedback.htm