Go to “System” follow by “Data Import”

Click on import for “C07 - Populate delivery order cost”

It will pop up a dialog box asking you to select the file to import.

Click on “Select Files” then look for the excel file that you want to import.

Select the file and click open.

When the file has been successfully processed, a result screen will display the data import status.

APPENDIX

Data Import Excel File

Column Description

Column	Description	Value	Data Type	Mandatory
YEAR	Year for selected Delivery Order to be populated	2018, 2019, 2020 …	NUMBER	Yes
PERIOD	Year for selected Delivery Order to be populated	1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12	NUMBER	Yes
SOURCING PLANT	Source Factory Code	BK, BA, …	TEXT	No if available depot code
DEPOT	Depot Code	HU	TEXT	No if available sourcing plant
PRODUCT CODE	Product Code	4100, 4200, 5100, …	TEXT	Yes
PRODUCT FORM	Product Form	Bulk, Bags	TEXT	Yes
FIXED COST	Unit Price Amount for Delivery Order Fixed Cost	0 if no value	NUMBER	Yes
COST OF SALES	Unit Price Amount for Delivery Order Variable Cost/Cost of Sales/Manufacturing Cost	0 if no value	NUMBER	Yes