Monday, November 15, 2010

Importing Invoices into Sage

I find myself having to generate CSV files to import into Sage every now and then, problem is that whilst I can readily frin the CSV file structure in the Sage Help File, the Transaction Type often remains elusive. Now that I have tracked them down again, here they are:

BPBank Payment (not supplier)
BRBank Receipt (not customer)
CPCash Payment (not supplier)
CRCash Receipt (not customer)
JCJournal Credit
JDJournal Debit
PAPurchase Payment on Account
PCPurchase Credit Note
PIPurchase Invoice
PPPurchase Payment
PDDiscount on Purchase Payment
SASales Receipt on Account (Cash from Customer not allocated)
SCSales Credit
SISales Invoices
SDDiscount on Sales Receipt
VPCredit Payment
VRCredit Receipt

The CSV file structure is:



Field
Description
Length
Type
1
Transaction type
2
Text
2
Sales / Purchase / Bank Account reference
8
Text
3
Nominal code
8
Integer
4
Department number
3
Integer
5
Transaction date
10 (**/**/****)
Date
6
Transaction reference
8
Text
7
Transaction details
60
Text
8
Net amount
11 (up to 2 decimal places)
Decimal number
9
Tax code
3
Text
10
Tax amount
11 (up to 2 decimal places)
Decimal number
11
Extra reference
8
Text
12
User name
32
Text