How to use load excel in sales order ?

Katrina Loste

1313-1212-2019201920192019

0 Comments

This LOAD EXCEL button is very convenient for orders having 50 or more line details.

1. EXCEL TEMPLATE

Here is the excel template. The system only can allow to load a 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.

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 on the excel template.

Click OK to proceed.

Please do not interrupt the auto-loading of line details.

Here is the final result.

* END *