Customer

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.

Accounting, Pay as you go Sage 50 Support, Excel Reports, Sage Reports, Sage 50 3rd Party integration and more!