Complete the following procedure to import stocktaking data into the Product Inventory Stocktaking screen by creating, populating, and importing a formatted Excel file.
Navigate to the Product Inventory Stocktaking screen.
Right-click on the list to display an Export to Excel option.
Click the Export to Excel option to export the template format to an Excel file.
Populate the Excel file with stocktaking information.
Note: The file must adhere to the validation requirements indicated in row 1 and below:
Save the Excel file.
Click the Import button on the Product Inventory Stocktaking screen to display the Load Excel Import window.
The system displays an amend/overwrite selection window.
Complete one of the following procedures to close this window:
Note: No quantities are entered into the system at this point.
If the system detects any errors, it displays the Import Complete with Errors window.
Complete any of the following as needed:
When the import is complete, the system displays the Upload Complete window.
|
|
© 2016 AcuSport Corporation |