Purchase Invoices
The solution will retrieve the purchase invoice CSV files exported from Yooz, using the GET /orgUnits/orgUnitCode/exportResults API call. The data will then be reformatted to suit the import requirements of Sage 50, depending on the type of data received from Yooz.
You have the option of either importing the files into Sage as 'Bills' directly or using the files to create Purchase Orders in Sage and then creating the Bills against the PO.
Requirements & Assumptions/Assertions
- Zynk is unable to import vendor credit memos due to limitations of the Sage software interface.
- Zynk will not create a Bill against a PO that already exists - it will either create a Bill only or create a PO and Bill together
- 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
For each purchase invoice CSV file exported from Yooz:ser - Download the file to Zynk’s working directory - Transform the data to the appropriate format(s) for import into Sage 50 - Import the data into the 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 | Invoice No. | --- |
| 8 | Order Number | Customer SO No. | --- |
| 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 | --- |