Tradesimple CSV Specification: Invoices

Overview

It is possible to load various types of information and data to Fourth's Purchase to Pay product (Tradesimple). Both customers and suppliers can use this functionality to import documents that largely correspond with paper based equivalents, for example - Product Catalogues, Purchase Orders, Delivery Notes or Invoices. These documents are in CSV format.

This guide defines the contents and rules governing the sending of Invoices via Purchase to Pay where the basic Fourth flat file format has been selected.

This article is aimed at the UK-based technical reader, and a working familiarity with CSV files is essential.

Please follow this link to see a full list of articles covering the creation of other CSV files that can be loaded to Purchase to Pay/Tradesimple - Tradesimple CSV Specification: Contents Page.

General Notes on all CSV Documents

File structure

Each record is one line. A record separator should consist of a line feed (ASCII/LF=0x0A), or a carriage return and line feed pair (ASCII/CRLF=0x0D 0x0A).

Fields are separated with commas.

Restrictions on the Fields Data
 

• Fields with embedded commas must be delimited with double-quote characters. Ex: Field,Data should be sent across within double quotes as “Field,Data”
• Fields containing double-quote characters must be surrounded by double-quotes, and the embedded double-quotes must each be represented by a pair of consecutive double quotes. Ex: Field”Data should be sent across as “Field””Data”
• Fields with leading or trailing spaces must be delimited with double-quote characters Ex: FieldData should be sent across within double quotes as “ FieldData ”
• Fields containing any special characters (characters other than alphabets (a-z or A-Z) and numerals (0-9)) should be embedded within double quotes
• Fields may always be delimited with double quotes and the delimiters will always be discarded. Please note: The system will not use the quotes to impart type information to fields imported
• The first record in a CSV file should be data and not a header record containing column (field) names
• Optional elements at the end of any line and their delimiters can be omitted but delimiters are necessary when optional elements are omitted “within” a line.

Mandatory/Optional Fields

Tables in this article use the following fields to indicate whether a field is mandatory, optional, or otherwise.
 

• M – Mandatory, must be provided
• O – Optional, should be provided if appropriate
• C – Conditional, should be provided under certain circumstances. The notes next to the field will describe exactly when the field should be provided
• D – The system requires this field, but will derive it if not provided

Numeric Data Elements

All numeric data elements must have any decimal point explicitly stated. A negative value may be sent by placing a minus sign before the number, e.g. –1250.02. A decimal point is not needed where the decimal part is equal to zero, e.g. 15.00 may be formatted as 15.

Text Data Elements

The appropriate separator should terminate all variable-length text data elements without trailing spaces or any other “padding” character. Double-quotes may be used to define and enclose single text data elements. Please refer “Restrictions on the fields data” section above for more details.

Date Elements

The date field format in these documents must always be YYYYMMDD unless otherwise stated.

Invoices (sent to Purchase to Pay)

Purchase to Pay allows the sending of a batch of invoices – a file containing many invoices for many different delivery locations. Each invoice must relate to a single delivery locations. Please note that Credit Notes must not be included in this file. Lines in the file must conform to the following pattern.

Each file must contain:

• Exactly one Batch Header Line – even if there is only a single invoice in the file
• One or more Invoice Documents

Each Invoice document must contain:

• Exactly one Invoice Header Line
• 1 or more Invoice Detail Lines
• 1 or more Invoice VAT sub-total Lines – one for each VAT Rate/code used in the Invoice (these can be derived by Purchase to Pay if not provided)

Batch Header Line
Each file must contain only a single batch header line as the first row in the file.



Invoice Header Line
Each file must contain a single invoice header line – for each invoice – as the first row in the invoice.

Invoice Detail Line
Each invoice must contain one or more invoice detail lines – one for each invoice line.



Invoice VAT Sub-total Line
Each invoice may contain one or more invoice VAT Sub-total lines for each VAT rate/code used in the invoice. The system can derive these on the supplier's behalf.



Example Invoice Batch

I,ELIBEER,Y,20041004,1,1
H,UNIT1,The Beer Company,3 Des Roches Square,,,,OX28 4LQ,GB123456789,The Dog and Duck,86 Ock Street,,,,OX14 5DH,INV0001,20041004,,GBP,,,,,,,1,3,7,100,,10,1.75,101.75,101.75
D,,,DEL0001,20041001,ABC1,,,1,10,10,S,17.5,EA
D,,,DEL0001,20041001,ABC2,,,2,15,30,Z,0,KGM
D,,,DEL0002,20041002,ABC2,,,4,15,60,Z,0,CS
V,S,17.5,1,1,10,,10,1.75,11.75,11.75
V,Z,0,2,6,90,,90,0,0,0
H,UNIT2,The Beer Company,3 Des Roches Square,,,,OX28 4LQ,GB123456789,The Eagle and Child,Beaumont Road,,,,OX16 1RB,INV0002,20041004,,GBP,,,,,,,1,1,4,60,,60,0,60,60
D,,,DEL0003,20041002,ABC2,,,4,15,60,Z,0,EA
V,Z,0,1,4,60,,60,0,0,0