Skip to content

Purchase Orders

The solution can be configured to import files as both Purchase Orders and then Bills against those POs. This is set using the ImportPOs setting.

Requirements & Assumptions/Assertions

  • The same data from Yooz will be used to create the PO and the Bill against it so these will both have the same values
  • Sage 50 US is single currency, therefore it is assumed that all data from Yooz will be in the base currency of Sage. Zynk will not perform any currency conversion

Zynk Process

  • Download data from Yooz
  • If ImportPOs is set to 'true' then convert the data into the Sage 50 US format
  • Import the POs into Sage

Scheduling

This part of the solution will be run each time the solution is scheduled.

Field Mappings

Yooz Col. Yooz Column Description Sage 50 US Purchase Order Field Notes
1 Yooz Number N/A The ‘Yooz number’ will be used by Zynk internally to ensure transactions are never duplicated in Sage.
2 Supplier Code Vendor ID ---
3 Invoice/Credit code Transaction Type Only PI lines will be processed
4 Currency ISO code N/A ---
5 Document Date Date ---
6 Due Date N/A ---
7 Document Number N/A ---
8 Order Number PO No. Will be referenced by the Bill
9 PO line number N/A ---
10 Item code Purchase Order Line → Item ---
11 Invoiced quantity Purchase Order Line → Quantity ---
12 Account number Purchase Order Line → GL Account ---
13 Cost Centre Code N/A ---
14 Department Code N/A ---
15 Line description Purchase Order Line → Description ---
16 Line net amount N/A Not used as Sage 50 US amounts are gross values
17 Tax Code N/A ---
18 Project Code N/A ---
19 Cost Code N/A ---
20 Tax Amount N/A ---
21 Total Amount Purchase Order Line → Amount The line total - divided by the quantity to calculate the Unit Price
22 AP Account A/P account ---
23 PI Terms Terms ---