Sage line 100

Sage line 100

Didn't find your answer?

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.

avatar
By chrisdxuk
07th Sep 2010 07:50

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.

Thanks (0)
avatar
By sassezekiel01
15th Sep 2010 21:46

Sage line 100

Hey thanks, apologies, have been away hence the dealy in replying.

Sage line 50 does give the layouts as you say but Line 100 is a meager on this topic!!

 

SE

 

Thanks (0)
avatar
By Jonathan Kempson
16th Sep 2010 18:47

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

Thanks (0)