Vendors

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

Zynk Process

• Export new or updated vendors from Sage.
• Convert the vendor data into the Yooz master data CSV format.
• Upload the CSV file to Yooz using 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 50 Vendor Field
1	Third party code	Vendor ID
2	Third party label	Name
3	VAT number	N/A, will be left blank
4	Phone Number	Telephone 1
5	Fax Number	Fax
6	Website	N/A, will be left blank
7	Address	Mailing Address (1)
8	Address (line 2)	Mailing Address (2)
9	Zip code	Zip
10	City	City
11	Country	Country
12	Contact name	Contact
13	Contact e-mail	N/A, will be left blank
15	Bank code	N/A, will be left blank
16	Counter code	N/A, will be left blank
17	Bank account number	N/A, will be left blank
18	RIB key / Control Key	N/A, will be left blank
19	IBAN	N/A, will be left blank
20	Linked GL account	Expense Account
21	Company registration number	N/A, will be left blank
22	SIREN	N/A, will be left blank
27	Action	Will be set based on the Inactive checkbox - Not ticked → CREATE (to add/update a supplier), Ticked → DELETE (to deactivate an existing supplier)
30	Custom1	Vendor Payment Terms