Example of Importing Price Details
Specify how to use price details when you import a sales order.
Example Values for This Topic
Assume there are two charges for the order line.
|
Original Order |
Import Payload |
|---|---|
|
UnitListPrice equals 100. Shipping charges equal 20. Tax equals 10. |
Price equals 120. Shipping charges equal 24. Tax equals 12. |
Assume.
-
Current price for the item is 130.
-
Shipping charges at runtime are price multiplied by 20%.
-
Tax calculated at runtime is total net price plus shipping multiplied by 10%.
Values That You Can Use for Freeze Attributes with Unreferenced Returns
Here are the values you can use when your import includes a sales order line or a return line that doesn't reference the original sales order.
|
FreezePriceFlag |
FreezeShippingChargeFlag |
FreezeTaxFlag |
Description |
|---|---|---|---|
|
Y |
Y |
N |
Pricing uses the price and shipping charges from the import payload, but calculates the tax. Price equals 120. Shipping charges equal 25. Tax equals 14.50. |
|
Y |
N |
N |
Pricing uses the price from the payload, but calculates shipping and tax. Price equals 120. Shipping charges equal 24. Tax equals 14.40. |
|
N |
Y |
N |
Pricing uses the shipping charges from the payload, but gets the price from your set up in Pricing Administration and calculates tax. Price equals 130. Shipping charges equal 24. Tax equals 15.40. |
Values That You Can't Use for Freeze Attributes with Unreferenced Returns
Here are the values that you can't use when your import includes a sales order line or a return line that doesn't reference the original sales order.
|
FreezePriceFlag |
FreezeShippingChargeFlag |
FreezeTaxFlag |
Description |
|---|---|---|---|
|
N |
N |
Y |
Pricing can calculate the price and shipping, but can't validate that the imported tax is correct for the price and the shipping it calculates. |
|
Y |
N |
Y |
Pricing can calculate shipping, but can't validate that the imported price and tax is correct for the shipping it calculates. |
|
N |
Y |
Y |
Pricing can calculate shipping and tax, but can't validate that the imported price is correct for the shipping and tax that it calculates. |
Referenced Return Line
Assume your import includes a return line that does reference the original sales order.
|
FreezePriceFlag |
FreezeShippingChargeFlag |
FreezeTaxFlag |
Description |
|---|---|---|---|
|
Y |
Y |
Y |
Pricing ignores the original sales order. Instead, it uses values from the import payload. Price equals 120. Shipping charges equal 24. Tax equals 12. |
|
Y |
N |
Y |
If at least one of these attributes equals N, then Pricing prices everything from the original sales order, and ignores price, shipping charges, and tax that the import payload contains. Price equals 100. Shipping charges equal 20. Tax equals 10. |
Required Attributes
If you freeze pricing, then you must include values for required attributes in your import payload. For details, see Freeze Price on Sales Orders.