Nominal Accounts
Nominal accounts that are new or have been modified will be exported from Sage 200 Standard every day at midnight. This data will then be converted into the Yooz master data CSV format. The file that results from this process will be uploaded to Yooz using the POST /orgUnits/{orgUnitCode}/importMasterData API call.
Requirements & Assumptions/Assertions
- A distinct CSV file will be created for each organisation and will be uploaded to the corresponding organisation in Yooz.
- Separate master data files will be produced 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 200 Standard.
- 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 200 Standard 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 |
--- |