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 | --- |