03333 445950
Home
Up

                                

 

Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Customer Records V12 and Above

The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.

Field   Description Notes
1 A Account Reference This must be just the letters A to Z and the Numbers 0 to 9 You can not have any spaces
2 B Account Name  
3 C Address 1  
4 D Address 2  
5 E Address 3  
6 F Address 4  
7 G Address 5  
8 H Contact Name  
9 I Telephone  
10 J Fax  
11 K Analysis 1  
12 L Analysis 2  
13 M Analysis 3  
14 N Department Number  
15 O Vat Registration Number  
16 P MTD Turnover  
17 Q YTD Turnover  
18 R Prior Year Turnover  
19 S Credit Limit  
20 T Terms Text description for adding to invoices.
21 U Settlement Days Number of days before settlement discount is no longer applied.
22 V Settlement Discount 5 = 5% enter the discount for early settlement.
23 W Nominal Code The default nominal code for transactions on this account.
24 X Tax Code The default Tax code for the account (normally T1 but you will want to change this if and import/export)
25 Y Trade Contact  
26 Z Telephone 2  
27 AA e-mail  
28 AB Web address  
29 AC Discount Rate  
30 AD Payment Due Days  
31 AE Terms Agreed Flag  
 

Refer to our field information table for the actual limitations of data values for these fields

Our Custom integration and import solution will allow you to have fields in any order and extract them from formats other than CSV eg: mailing labels printed to disk you can also import all the other fields associated with customers such as price lists.


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017