Supplier Prices: Import/Export Function

This feature will add 2 new menu items to the xisting byondpro item import/export function:

- Export Supplier Prices

- Import Supplier Prices

The Supplier Prices import/export will function to the same specification as the existing Item Prices, but using the column headers shown below.

Import rule - validate that matching entry does not exist: Item Code + Supplier + Price + Valid From + Valid Until + Territory.
- if so, show as pre-import validation error (Entry already exists) and do not proceed.

Excel Template: import/export functions

ID	ITEM CODE	ITEM DESCRIPTION	SUPPLIER	PRICE	VALID FROM	VALID UNTIL	TERRITORY NAME
6001	M-1000	Memorial Items: Bronze rectangle plaque small	Arrow Bronze Pty Ltd	2000.00	2021-01-01	2021-12-31	South East Regional Cemeteries
6002	M-1000	Memorial Items: Bronze rectangle plaque small	Arrow Bronze Pty Ltd	3100.00	2022-01-01	2022-12-31	South East Regional Cemeteries

Supplier Prices: Import/Export Function

The online help was created with Dr.Explain