Skip to content

Sage 200 Purchase Order Authorisations XML

The Import Purchase Order Authorisations task allows you to authorise existing purchase orders in Sage 200. The only information that needs to be provided in the XML is a list of orders you would like to authorise.

Please note that only orders of the type 'Purchase Order' can be authorised. Purchase returns can't be authorised.

Note

Purchase orders will be authorised by the user Zynk is running under. So you will need to ensure Zynk's user is configured as an authoriser in your authorisation rules in Sage 200.

Order Identification

At least one of the following fields must be provided to identify which order to authorise in Sage. The fields will be considered in the following order: UniqueId, PurchaseOrderNumber, Id, SupplierOrderNumber. If no match is found based on any of these fields, the order won't be authorised.

XML Field Sage Field  Example Type Length  Notes
UniqueId - 2841241 int - The database ID of the purchase order. In the Zynk PurchaseOrder object, this would be the UniqueId specified in the success file of a successfully imported PurchaseOrder or in the export file from Sage 200. If this data is obtained directly from the Sage database, then this relates to SOPOrderReturn.SOPOrderReturnID
PurchaseOrderNumber Order no 0000000005 string 10 The order no of the purchase order. In the Zynk PurchaseOrder object, this would be the PurchaseOrderNumber specified in the success file of a successfully imported PurchaseOrder or in the export file from Sage 200. If this data is obtained directly from the Sage database, then this relates to SOPOrderReturn.DocumentNo
Id - 12345 string 255 The external ID of the Zynk PurchaseOrder. If the PurchaseOrder was previously imported by Zynk and an Id (3rd party system identifier) was specified in the XML, then this can be used to match the purchase order. This will only be valid in scenarios where the PurchaseOrder was created by Zynk and an Id was specified. This is not something that can be obtained directly from the Sage 200 database.
SupplierOrderNumber Supplier order no  ABC12345 string 30 The supplier order no of the purchase order. In the Zynk PurchaseOrder object, this would be the SupplierOrderNumber specified in the success file of a successfully imported PurchaseOrder or in the export file from Sage 200. If this data is obtained directly from the Sage database, then this relates to POPOrderReturn.SupplierDocumentNo
<?xml version="1.0" encoding="utf-8"?>
<Company
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <PurchaseOrders>
    <PurchaseOrder>
      <UniqueId>2841241</UniqueId>
      <PurchaseOrderNumber>0000000005</PurchaseOrderNumber>
      <Id>12345</Id>
      <SupplierOrderNumber>ABC12345</SupplierOrderNumber>
    </PurchaseOrder>
  </PurchaseOrders>
</Company>