...
Fill up the information for the configuration that use for data import from excel template
# | Field | Description |
---|---|---|
1 | Import to Customer No | The customer number that system create SO for the import file |
2 | Order No. Prefix | The Sales Order number prefix that system create SO for the import file |
3 | SO Group By | Select how to create sales order by the import file. Two option is available (1) Group by Order Date / (2) Group by Shipment Date |
4 | First Row ID | The 1st row in import file with sales line data use for creating sales order |
5 | Use System Discount | Select the option if the line discount according to the setup in Sales Price & Discount table for example, if the customer (1), item has 5% discount. when the order line imported, 5% line discount default to the sales line. if the option is turn-off, that means if sales price & discount table has 5% discount, the order line will not have the discount. in this case, the template will not have discount column. |
6 | Calculation | Select the appropriate option if needs. Calculate Unit Price - the unit price Sales order line is calculated by Sales Price / Qty, sales price means total amount of the line. in this case, the template will only have unit price. Calculate Sales Price - the sales price in sales order line is calculated by Unit Price 8 Qty, sales price means total amount of the line. in this case, the template will only have sales price. |