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 will be uploaded to the corresponding organisation in Yooz.
- Separate master data files will be created for suppliers, nominal codes, and cost centres.
- For Sage 200, the file will enumerate each valid combination of nominal code, cost centre, and department.
Zynk Process
- Zynk will export new and modified nominal accounts from Sage.
- The data will be transformed 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 200 Professional Nominal Account Field | Notes |
|---|---|---|---|
| 1 | Account Number | Nominal Code Cost Centre Code Department Code |
The nominal code, department and cost centre will all be in this single column, separated by forward slashes. E.g. 4000/COS/DEP |
| 2 | Account label | Name | --- |
| 3 | Classification | Will be set based on the nominal code, as follows: 4000 to 4999 > YZ_CUSTOMER 5000 to 5999 > YZ_SUPPLIER All others > YZ_ENTRY |
--- --- |