SageForum for UK versions of Sage 50- Help and support.

Sorry to resurrect an old thread.
How do you access the ODBC? I know about "Send to excel" but how did you get all that into monthly columns?

I found this page http://support.makingithappen.co.uk/sag ... el2000.htm but the links to ODBC don't work

Thanks

Because foreign addresses do not match UK address format, I always added the foreign country name to the POSTCODE field which is address field 5.
For most of our foreign customers, they rarely use all 5 fields.

Or
create a dummy Euro account in the bank module. (note this account must always be back to zero when you are finished your transactions)

Then Receive the customer payment into that account.

Finally transfer that amount into your GBP account via the Bank Transfer option.

When sending remittance advices to suppliers to advise them of payment, I like to include their account reference for us on the document. (I also wish our customers would do the same for us - it makes looking up accounts so much easier!)

I am currently using the BACS_REF field on the Bank details ...

Can anyone please advise me how to create barcodes for each of our hundreds of products?
Do I just enter the same product code into the barcode field, and then print it using the barcode font?
(I suspect there is more too it, and I know barcodes have check digits and stuff, but I cannot find what my ...

I would also suggest you check your COA.
Click on Company > COA > Edit
Then Check option
If an error has been made in your COA then it could result in double counting if the nominal codes appear in the wrong sections or are duplicated.

-M

I would suggest a workaround by printing a second template just after printing the actual purchase order, although you may already do this.
If not, I would open your purchase order print template.
Then Click Save As "Purchase Order Cover Page"
Now the layout will be exactly the same as in the PO ...