Hi
I have a working file to upload Purchase Invoices onto Sage 200 via a CSV file but I need to post multiple lined invoices as some of our AP invoices have 2 or 3 different GL codings.
I tried to have the same Transaction Reference thinking that it might pick up that it's the same invoice number and enter into one Purchase Invoice but it imported it as 2 or 3 different AP Invoices. Is this where the SYSTraderTranType selection comes in where maybe I should enter number 6 as Opening Balance Invoice and the remainder lines as 4 for Purchase Invoice?
Also I see that it doesn't pick up on duplicates if the invoice is already in the system, is there a way around this or is the only option to do a manual check before importing the data?
Sage's help files on this are absolutely useless please could someone please assist me asap?
Kind Regards,
Anelle
Replies (2)
Please login or register to join the discussion.
Sage 200 CSV
I presume you buy your Sage 200 licence from a developer as we do? Can't they deal with this for you? Our developers are generally pretty helpful with queries like this and can usually provide a quick fix over the phone at little or no cost.