Skip to content

Suppliers

Every day at midnight, new and updated suppliers will be exported from Sage 200. 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 created for each organisation and uploaded to the corresponding organisation in Yooz.
  • Separate master data files will be produced for suppliers, nominal codes, and cost centres.

Zynk Process

  • Export new or updated suppliers from Sage 200 Standard.
  • Convert the supplier data into the Yooz master data CSV format.
  • Upload the CSV file 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
  • SUPPLIER_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 200 Standard Supplier Field
1 Third party code Company → Code
2 Third party label Company → Name
3 VAT number Trading → VAT number
4 Phone Number Company → Telephone
5 Fax Number Company → Fax
6 Website Company → Website
7 Address Company → Address (Line 1)
8 Address (line 2) Company → Address (Line 2)
9 Zip code Company → Postcode
10 City Company → City
11 Country Company → Country (2 char ISO code)
12 Contact name Will be left blank as this field is not available via the 200 online API.
13 Contact e-mail Will be left blank as this field is not available via the 200 online API.
15 Bank code Bank → Sort code
16 Counter code N/A, will be left blank
17 Bank account number Bank → Account number
18 RIB key / Control Key N/A, will be left blank
19 IBAN Bank → IBAN
20 Linked GL account N/A, will be left blank
21 Company registration number N/A, will be left blank
22 SIREN N/A, will be left blank
27 Action Will always be set to ‘CREATE’ (suppliers can’t be disabled in Sage 200).