Skip to content

Cost Centres

Every day at midnight, new and modified cost centres will be exported from Sage. This data will then be converted into the Yooz master data CSV format. The resulting file will be uploaded to Yooz using the POST /orgUnits/{orgUnitCode}/importMasterData API call. The data sent to Yooz will include departments, project references, and cost codes.

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.
  • All cost centre data will be consolidated into a single master data file.
  • The 'Analytical axis code' column will denote the type of data contained in each row. For Sage 50, the values will be 'Department', 'Project', and 'Cost code'.

Zynk Process

  • Zynk will export new or modified department information from Sage.
  • Zynk will export new or modified project information from Sage.
  • Zynk will export new or modified cost code information 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
  • COST_CENTER_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 Column Yooz Column Description Sage 50 Field
1 Analytical axis code Will be either “Department” / “Project” / “Cost code”
2 Cost center code Department Reference / Project Reference / Cost Code
3 Cost center label Department Name / Project Description / Cost Code Description