Content Comparison

...

Sample InTime Sage 50 export file - sage50_InTimeSample.csv.

Sage 50 Specification:-

InTime Field Mapped		Column	Field	Type	Size	Validation	Precision	Import Type
	→	A	Transaction Type	text	2	BP, BR, CP, CR, JC, JD, PA, PC, PI, SA, SC, SI, VP, VR		Standard/Extended
	→	B	Sales/Purchase/Bank Account Ref	text	8	Look up		Standard/Extended
	→	C	Nominal Code	text	8	Look up		Standard/Extended
	→	D	Department Number	Int	3	1-999		Standard/Extended
	→	E	Transaction date	Date	10	Date	Xx/xx/xxxx	Standard/Extended
	→	F	Transaction (invoice) ref	Text	30			Standard/Extended
	→	G	Transaction detail	Text	60			Standard/Extended
	→	H	Net Amount	Decimal	11		8 digits + 2d.p	Standard/Extended
	→	I	Tax code	Int	3	T0-T99		Standard/Extended
	→	J	Tax amount	Decimal	11		8 digits + 2d.p	Standard/Extended
	→	K	Exchange rate	Decimal	11			Extended
	→	L	Extra Ref	Text	30			Extended
	→	M	Username	text	32			Extended

...

Default values

	Field	Value	Example
→	SYSTraderTranType	4 = Invoice, 5 = Credit, 2 = Payment
→	Source	1 = sales, 2 = Purchase
→	TransactionReference	Invoice Number	CI-00001
→
→	SALES TRANSACTIONS
→	AccountNumber	Client Accounts Ref	TC0001
→	NominalAnalysisNominalAccountNumber/1	Client Time/Expenses Nominal Code	4001
→	nominalAnalysisNominalAnalysisNarrative1	SI / SC <client name>	SI Test Client
→	nominalAnalysisNominalCostCentre1	placement Sales CostCentre
→	nominalAnalysisNominalDepartment1	placement Sales Department
→
→	PURCHASE TRANSACTIONS
→	accountNumber	worker Accounts Ref / Provider Accounts Ref	AW1234
→	nominalAnalysisNominalAccountNumber1	worker / provider nominal Code	5001
→	nominalAnalysisNominalAnalysisNarrative1	PI / PC <supplier name> <date> <item>	PI A.Worker 02/01/2016 TS-54321
→	nominalAnalysisNominalCostCentre1	placement Purchase CostCentre
→	nominalAnalysisNominalDepartment1	placement Purchase Department

...

Versions Compared