HOW TO USE THE LOAD EXCEL BUTTON IN SALES ORDER

    1. EXCEL TEMPLATE

    Here is the Excel template. The system can only allow to load an XLS file type

Mandatory fields are those highlighted in yellow.

Do not leave the LineDiscount1, LineDiscount2 and LineDiscount3 fields blank. If there is no line discount, simply put zero.

The Excel template may be downloaded using this button under the CO transaction. 

    2. HOW TO USE THE LOAD EXCEL BUTTON IN SALES ORDER

Fill up the CO transaction header.

Click on the Load Excel button to select the Excel template.

Click Open to proceed.

Please do not interrupt the auto-loading of line details, and the system will show the prompt message that imported successfully, then click save.

Here is the final result.

* END *

 Disclaimer: The information provided here is provided on an as-is basis without warranty of any kind, either expressed or implied, including warranties of merchantability and fitness for a particular purpose. In no events shall A2000 Solutions Pte Ltd or its agents, distributors and suppliers (collectively known as A2000) be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if A2000 have been advised of the possibility of such damages. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. All third party trademarks are the property of their respective owners.