Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Data Import Query Relating To Cheque Payments

Sage 50 general help forum - Free help and support for all general issues
Post Reply
JayDee

Data Import Query Relating To Cheque Payments

Post by JayDee » 18 May 2007, 10:23

We use SAGE Line 50 Version 13.

I want to prepare batches of cheques using the “Paymentâ€

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 22 May 2007, 18:15

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
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest