Nominal Accounts
Every day at midnight, new and modified nominal accounts will be exported from Sage. This data will then be converted into the Yooz master data CSV format. The final file will be uploaded to Yooz using the POST /orgUnits/{orgUnitCode}/importMasterData API call.
Requirements & Assumptions/Assertions
- A distinct CSV file will be generated for each organisation and uploaded to the corresponding organisation in Yooz.
- Separate master data files will be created for suppliers, nominal codes, and cost centres.
- For Sage 50, the file will enumerate each individual nominal code.
Zynk Process
- Zynk will export new and modified nominal accounts from Sage.
- The data will be converted into the Yooz master data CSV format.
- The CSV file will be uploaded to Yooz via the API.
Data Format
- The CSV separator is TAB.
- The CSV row ending is CR LF.
- The CSV requires two header rows:
- Yooz Rising
- ACCOUNTANT_PLAN_TAB
- If any string values contain TAB, CR or LF characters, they will be stripped from the data (rather than surrounding the string with quotes).
Scheduling
The default schedule for this solution point is to run daily at midnight.
Field Mappings
| Yooz Col. | Yooz Column Description | Sage 50 Nominal Field | Notes |
|---|---|---|---|
| 1 | Account Number | N/C | --- |
| 2 | Account label | Name | --- |
| 3 | Classification | Will always be set to YZ_ENTRY | --- |