Overview
It is possible to load various types of information and data into Fourth's Purchase to Pay product (formerly known as Trade Simple). Both customers and Suppliers can use this functionality to import documents that largely correspond with paper-based equivalents, for example - Purchase Orders, Delivery Notes or Invoices. These documents are in Fourth’s XML format.
This article details the content and rules governing the sending of Invoices via Purchase to Pay where the Fourth xml format has been selected.
Please Note: This article is aimed at users with technical knowledge, and a working familiarity with xml files is essential.
Purchase to Pay (TradeSimple) XML Specifications
Specifications for all document types can be found in the PDF file (linked below). A full table of contents is listed on the first page.
The XML schema is also attached.
For information on CSV file specification, please see P2P&I - Purchase to Pay CSV Specification - Contents Page.
When an inbound XML file is transformed to CSV, it will not be processed if it contains characters that require escaping for the CSV format. These include quotation marks and commas. Where XML data is received that contains non-escaped characters, the document will not be processed, and the sender will be notified by email
Double quotes intended as part of data must be escaped by preceding them with another double quote.
For example
Tomato pizza 9" thick crust
should be sent as either
Tomato pizza 9"" thick crust
or"Tomato pizza 9"" thick crust"
If text data contains commas, it should be enclosed in double quotes.
For example:
"Tomato, pizza 9"" thick crust"
The escaping of commas and double quotes can be sense-checked with the following rule:
Any field that contains double quote characters should always contain an even number of them.
Comments
Please sign in to leave a comment.