Peoplevox XML Purchase Orders

Zynk will import the data using the standard fields under Integration Templates that can be ran configured your Peoplevox web application. Note, the fields must use the default names, you can import the correct configuration using the file below.

Tasks

Integration Templates

Purchase Order

Download Template

PurchaseOrderNumber,Status,Reference,Supplier,AddressLine1,AddressLine2,AddressCity,AddressRegion,AddressPostcode,AddressCountry,AddressReference,RequestedDeliveryDate,SubmittedDate,User,EndDate,ExpectedDeliveryDate

Purchase Order Item

Download Template

PurchaseOrderNumber,ItemCode,Status,Quantity,RequestedDeliveryDate,Line,Sequence,CostPrice,ExpectedDeliveryDate

Identifiers

For inserting or updating records to Peoplevox Zynk uses the PurchaseOrderNumber field on a PurchaseOrder. It is invalid to insert / update a PurchaseOrder without providing the PurchaseOrderNumber. If updating an existing PurchaseOrder the items will be added or edited depending on what information is provided, it is not possible to remove lines.

Fields

PurchaseOrderNumber

Required
Purchase order number.

Type Example XML
string(50) PO-123456 <PurchaseOrderNumber>PO-123456</PurchaseOrderNumber>

Status

Optional
Status.

Type Example XML
string(50) Pending <Status>Pending</Status>

Available Values

  • Pending
  • Cancelled
  • Deleted

Reference

Optional
Reference.

Type Example XML
string(50) PO-ABCDEF <Reference>PO-ABCDEF</Reference>

Supplier

Optional
Supplier name or external reference.

Type Example XML
string(50) Andrew Snape <Supplier>Andrew Snape</Supplier>

AddressLine1

Optional
Line 1.

Type Example XML
string(100) i6 <AddressLine1>i6</AddressLine1>

AddressLine2

Optional
Line 2.

Type Example XML
string(100) 6 - 8 Charlotte Square <AddressLine2>6 - 8 Charlotte Square</AddressLine2>

AddressCity

Optional
City.

Type Example XML
string(100) Newcastle <AddressCity>Newcastle</AddressCity>

AddressRegion

Optional
Region.

Type Example XML
string(100) Tyne and Wear <AddressRegion>Tyne and Wear</AddressRegion>

AddressPostcode

Optional
Post code.

Type Example XML
string(100) NE1 4XF <AddressPostcode>NE1 4XF</AddressPostcode>

AddressCountry

Optional
Country.

Type Example XML
string(100) United Kingdom <AddressCountry>United Kingdom</AddressCountry>

AddressReference

Optional
Reference.

Type Example XML
string(100) WORK <AddressReference>WORK</AddressReference>

RequestedDeliveryDate

Optional
Requested date in "yyyy-MM-dd HH:mm:ss" format.

Type Example XML
string(19) 2017-07-20 00:00:00 <RequestedDeliveryDate>2017-07-20 00:00:00</RequestedDeliveryDate>

SubmittedDate

Optional
Submitted date in "yyyy-MM-dd HH:mm:ss" format.

Type Example XML
string(19) 2017-07-10 00:00:00 <SubmittedDate>2017-07-10 00:00:00</SubmittedDate>

EndDate

Optional
End date in "yyyy-MM-dd HH:mm:ss" format.

Type Example XML
string(19) 2017-08-20 00:00:00 <EndDate>2017-08-20 00:00:00</EndDate>

ExpectedDeliveryDate

Optional
Expected delivery date in "yyyy-MM-dd HH:mm:ss" format.

Type Example XML
string(19) 2017-07-18 00:00:00 <ExpectedDeliveryDate>2017-07-18 00:00:00</ExpectedDeliveryDate>

PurchaseOrderItems

Required
You need to provide a collection of items as part of the import.

ItemCode

Required
Item code

Type Example XML
string(50) PROD001 <ItemCode>PROD001</ItemCode>

Status

Optional
Purchase order item type status name.

Type Example XML
string(50) Pending <Status>Pending</Status>

Available Values

  • Pending
  • Closed

Quantity

Optional
Quantity.

Type Example XML
int 2 <Quantity>2</Quantity>

RequestedDeliveryDate

Optional
Requested delivery date in yyyy-MM-dd HH:mm:ss format.

Type Example XML
string(19) 2017-07-19 00:00:00 <RequestedDeliveryDate>2017-07-19 00:00:00</RequestedDeliveryDate>

Line

Optional
Line.

Type Example XML
string(16) <Line></Line>

Sequence

Optional
Sequence.

Type Example XML
int 1 <Sequence>1</Sequence>

CostPrice

Optional
Cost price.

Type Example XML
decimal 10 <CostPrice>10</CostPrice>

ExpectedDeliveryDate

Optional
Expected delivery date in yyyy-MM-dd HH:mm:ss format.

Type Example XML
string(19) 2017-07-21 00:00:00 <ExpectedDeliveryDate>2017-07-21 00:00:00</ExpectedDeliveryDate>

SupplierData

Optional
If you have the Auto Create Suppliers option enabled, you must provide the supplier information object in the element.

See Peoplevox XML Suppliers

Example XML

Please see below an example of purchase order XML:

<?xml version="1.0" encoding="utf-8"?>
<PurchaseOrders>
    <PurchaseOrder>
        <PurchaseOrderNumber>PO-123456</PurchaseOrderNumber>
        <Status>Pending</Status>
        <Reference>PO-ABCDEF</Reference> 
        <Supplier>Andrew Snape</Supplier>
        <AddressLine1>i6</AddressLine1>
        <AddressLine2>6 - 8 Charlotte Square</AddressLine2>
        <AddressCity>Newcastle</AddressCity>
        <AddressRegion>Tyne and Wear</AddressRegion>
        <AddressPostcode>NE1 4XF</AddressPostcode>
        <AddressCountry>United Kingdom</AddressCountry>
        <RequestedDeliveryDate>2017-07-20 00:00:00</RequestedDeliveryDate>
        <SubmittedDate>2017-07-10 00:00:00</SubmittedDate>
        <EndDate>2017-08-20 00:00:00</EndDate>
        <ExpectedDeliveryDate>2017-07-18 00:00:00</ExpectedDeliveryDate>
        <PurchaseOrderItems>
            <PurchaseOrderItem>
                <ItemCode>PROD001</ItemCode>
                <Status>Pending</Status>
                <Quantity>2</Quantity>
                <RequestedDeliveryDate>2017-07-19 00:00:00</RequestedDeliveryDate>
                <Line></Line>
                <Sequence>1</Sequence>
                <CostPrice>10</CostPrice>
                <ExpectedDeliveryDate>2017-07-21 00:00:00</ExpectedDeliveryDate>
            </PurchaseOrderItem>
        </PurchaseOrderItems>
    </PurchaseOrder>
</PurchaseOrders>

Please see below an example of purchase order XML with supplier data included:

<?xml version="1.0" encoding="utf-8"?>
<PurchaseOrders>
	<PurchaseOrder>
		<PurchaseOrderNumber>PO-223456</PurchaseOrderNumber>
		<Status>Pending</Status>
		<Reference>PO-BBCDEF</Reference>
		<AddressLine1>i6</AddressLine1>
		<AddressLine2>6 - 8 Charlotte Square</AddressLine2>
		<AddressCity>Newcastle</AddressCity>
		<AddressRegion>Tyne and Wear</AddressRegion>
		<AddressPostcode>NE1 4XF</AddressPostcode>
		<AddressCountry>United Kingdom</AddressCountry>
		<AddressReference>WORK</AddressReference>
		<RequestedDeliveryDate>2017-07-20 00:00:00</RequestedDeliveryDate>
		<SubmittedDate>2017-07-10 00:00:00</SubmittedDate>
		<EndDate>2017-08-20 00:00:00</EndDate>
		<ExpectedDeliveryDate>2017-07-18 00:00:00</ExpectedDeliveryDate>
		<PurchaseOrderItems>
			<PurchaseOrderItem>
				<ItemCode>PROD001</ItemCode>
				<Status>Pending</Status>
				<Quantity>2</Quantity>
				<RequestedDeliveryDate>2017-07-19 00:00:00</RequestedDeliveryDate>
				<Line/>
				<Sequence>1</Sequence>
				<CostPrice>10</CostPrice>
				<ExpectededDeliveryDate>2017-07-21 00:00:00</ExpectededDeliveryDate>
			</PurchaseOrderItem>
		</PurchaseOrderItems>
		<SupplierData>
			<Name>John Doe</Name>
			<FirstName>John</FirstName>
			<LastName>John Doe</LastName>
			<Phone>0191 820 1484 +24</Phone>
			<Mobile>0773 862 6085</Mobile>
			<Email>[email protected]</Email>
			<CreditLimit>1000</CreditLimit>
			<Notes>Main supplier for PROD001</Notes>
		</SupplierData>
	</PurchaseOrder>
</PurchaseOrders>