...
# | 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 series that system uses to 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 | To determine which row is the first row of data |
5 | Use System Discount | When the option is selected, system will use the discount for the customer its setup in business central. No matter the discount field is mapped in Configure Excel Column, the data in import file to be ignore. |
6 | Configure Excel Column | To determine the import file columns to be displayed in the sales orders generated |
7 | Calculation | Select either one option Calculate Unit Price - select this option for always use the sales price to calculate the unit price. - when this option is selected, no matter the unit price field is mapped in Configure Excel Column, the data in import file to be ignore.The sales orders will be generated with the final price after deducting the store credit / dicount granted Calculate Sales Price - select this option for always use the price setup in system to calculate sales price.The sales orders will be generated with the sales price before deducting any store credit / dicount granted |