Exporting and importing sales, purchase and movement transactions and orders

Sales, purchase and movement queries have a mandatory field called Transaction Type. This is the transaction type that appears on the transaction in the header record.

You can export Order Fulfilment transactions of only one type to any particular payload. To export multiple transaction types, you must export them to multiple different payloads; one per type.

Importing sales, purchase and movement orders

We do not recommend importing sales, purchase and movement orders using a Start of Document, Line or End of Document preset type.

Start of Document and Line preset types can cause inconsistency in the line numbers. For example, when importing a new sales order using a Start of Document preset type, the order is created with a preset line, then imported into a sales type that also creates a preset line.

Creating a new orders line using the End of Document preset type will not work, because an empty line is required to insert the new lines information. The empty line is not present if this preset type has been used.