Supplier open items file

The file Supplier open items (supplier_items) gives the open items of each supplier at the cutover date, for example the bills that the company did not pay. The items go into the lines Party balances of the draft opening balances, on the control account of the suppliers.

Rules of the rows

The company must be Migrating, and the opening balances must be a draft.
Each party must have the role supplier.
Write one row for each open item, with its original date. Without a date, the item has the cutover date. A date after the cutover date is an error.
Write the amount that the company must pay in credit. Write an advance to the supplier in debit.
The items of one supplier must all be on the same side. Write the net amount.
Caution: A new file replaces all the lines of the earlier file.

Rules of the file

Row 1 has the column names. Do not change them. The data starts on row 2.
Write the data on the sheet "supplier_items". The system reads the sheet "supplier_items", or else the first sheet.
A column that is not necessary can stay empty. You can remove a column that is not necessary.
A file can have at most 100,000 data rows and 20 MB. Put more data in more than one file.
Codes and other text: write them as text. Excel keeps a code such as 001 only in a text cell.
Y means yes and N means no. A list column takes more than one value, separated by ";".
Do not write formulas. The system reads the values only.

Columns of the file (version 1)

Column	Necessary	Type	Meaning	Example
`party_code`	Yes	code, at most 32 characters	The code of a party with the role supplier.	`C-0001`
`item_date`	No	date YYYY-MM-DD	The date of the item (for example of the bill). Empty: the cutover date. Not after the cutover date.	`2026-08-15`
`reference`	No	text, at most 40 characters	The number of the source document, for example the bill number.	`INV-1042`
`debit`	No	amount, at most 2 decimals, without a thousands separator	An advance to the supplier.	`2500.00`
`credit`	No	amount, at most 2 decimals, without a thousands separator	The amount that the company must pay.
`description`	No	text, at most 500 characters	A text for the item.
`source_note`	No	text, at most 100 characters	A note that identifies the row in your source. The system shows it in the messages, and it does not keep it.	`voucherdt:001`

Example

A file with one row, in CSV format. Row 1 has the column names.

party_code,item_date,reference,debit,credit,description,source_note
C-0001,2026-08-15,INV-1042,2500.00,,,voucherdt:001