Hi there, all you sage experts
Can anyone help
I need to import purchase/sales ledger invoices and create supplier and customer accounts records in sage line 100 Can any tell me the data fields, order, number of characters for each field, import/validation procedure
Thanks
SE
Replies (3)
Please login or register to join the discussion.
Don't know SAGE 100 but in SAGE 50...
Don't know SAGE 100 but in SAGE 50 if, you use the HELP function you get a full and detailed information of how to do so. I would imagine its the same for SAGE 100.
The option I use is the AUDIT TRIAL one but there are dedicated options for Customer and Supplier ledgers.
Sage Line 100 import
I can provide the defaults for sales accounts for v7.6 of Line 100, but these can be amended on a per installation basis (though this isn't especially common)
Account number - 8 character
Account name - 30 characters
Address lines 1 to 4 - 30 characters
Post code - 10 characters
Analysis 1 to 3 - 4 characters
Contact - 20 characters
Country code - 2 characters
Credit limit - number 15.2
Fax number - 20 characters
Phone number - 20 characters
VAT number - 13 characters
As I said it's possible to amend the import, so if you have other fields that you need to import it may be possible.
Purchase ledger is similar as far as I can recall without checking.
Also just to check that you're aware that Line 100 is pretty old, and has been replaced (in effect) by Sage 200?
Regards
Jonathan