New Purchase Invoice / Credit NoteUpdated a month ago

This message is responsible for submitting new invoices and credits notes.

Folder Location

This file should be generated in real-time as orders are ready to be invoiced and should be saved to “inbox”. Once successfully processed, we will move the file to “inbox_archive” folder.

Version

This version is “1_2”. Released on 30^th January 2020.

Filename Format

new_invoice-{version}-{yyyymmddhhmmssnnnnn}.csv

File Sections

Header Record (1 per invoice/credit note)
Detail Record (1 per invoice/credit note line, unlimited number per invoice/credit note)
Checksum Record (1 per file)

File Contents

	Column Header	Section	Required	Type	Max Length	Notes
1	section	Header	Y	Text	255	Will always be “header”
2	type	Header	Y	Text	3	Should be ‘INV’ to indicate this is an invoice or ‘CRN’ to indicate this is a credit note
3	supplier_code	Header	Y	Text	8	Our unique identifier for your supplier account
4	supplier_gln_number	Header	N	Text	13	Your GS1 Global Location Number
5	invoice_credit_number	Header	Y	Text	100	Your invoice or credit note number
6	invoice_credit_date	Header	Y	Date	N/A	Format: yyyy-MM-dd
7	order_number	Header	Y	Text	100	Our unique identifier for the order
8	order_date	Header	Y	Date	N/A	Format: yyyy-MM-dd
9	supplier_order_ref	Header	Y	Text	100	Your unique reference for the order
10	supplier_delivery_note_number	Header	Y	Text	100	Your unique delivery note number
11	supplier_order_date	Header	Y	Date	N/A	Format: yyyy-MM-dd
12	due_date	Header	Y	Date	N/A	Format: yyyy-MM-dd
13	currency_iso_code	Header	Y	Text	3	Three-letter ISO currency code
14	invoice_contact	Header	Y	Text	100
15	invoice_company	Header	N	Text	100
16	invoice_address_1	Header	Y	Text	100
17	invoice_address_2	Header	N	Text	100
18	invoice_address_3	Header	N	Text	100
19	invoice_address_4	Header	N	Text	100
20	invoice_postcode	Header	Y	Text	100
21	invoice_country_code	Header	Y	Text	3	Three-letter ISO country code
22	invoice_vat_number	Header	Y	Text	15	The full identifier starts with an ISO 3166-1 alpha-2 (2 letters) country code and then has between 2 and 13 characters.
23	delivery_contact	Header	Y	Text	100
24	delivery_company	Header	N	Text	100
25	delivery_address_1	Header	Y	Text	100
26	delivery_address_2	Header	N	Text	100
27	delivery_address_3	Header	N	Text	100
28	delivery_address_4	Header	N	Text	100
29	delivery_postcode	Header	Y	Text	100
30	delivery_country_code	Header	Y	Text	3	Three-letter ISO country code
31	delivery_location_code	Header	N	Text	15
32	total_net	Header	Y	Decimal	N/A
33	total_tax	Header	Y	Decimal	N/A
34	total_gross	Header	Y	Decimal	N/A
35	spare_field_1	Header	N	Text	255
36	spare_field_2	Header	N	Text	255

	Column Header	Section	Required	Type	Max Length	Notes
1	section	Detail	Y	Text	255	Will always be “detail”
2	line_ref	Detail	Y	Text	5	Our unique identifier for the line within the order
3	supplier_sku	Detail	Y	Text	255	Your unique identifier for the product/service
4	retailer_sku	Detail	Y	Text	255	Our unique identifier for the product/service. If a delivery charge, please populate with “delivery”
5	grade	Detail	Y	Text	3	Grading scale 100 - New 150 - New - Damaged / Missing Packaging 175 - New - Cosmetic Defect 200 - Manufacturer Refurbished 250 - Manufacturer Refurbished - Cosmetic Defect 300 - Used 325 - Used - Damaged / Missing Packaging 350 - Used - Cosmetic Defect
6	description	Detail	N	Text	100	Line item description
7	quantity	Detail	Y	Numeric	N/A
8	unit_price	Detail	Y	Decimal	N/A	Price for a single unit excluding tax
9	net	Detail	Y	Decimal	N/A	Quantity x Net
10	tax_rate	Detail	Y	Numeric	N/A	The applicable tax rate for this line as a percentage
11	tax	Detail	Y	Decimal	N/A	The total amount of tax payable for this line
12	gross	Detail	Y	Decimal	N/A	Net + Tax
13	spare_field_1	Detail	N	Text	255
14	spare_field_2	Detail	N	Text	255

Was this article helpful?

Yes