How do I import an order with ordered_quantity different from pricing_quantity?
I need to import an order line thru Order Import interface by populating the interface tables, with a pricing_quantity that is different from the ordered_quantity. The UOM is the same for both.
I need this in order to be able to price the item using a different quantity from the ordered quantity. The qty invoiced is the ordered_quantity, but the price derived from the pricelist, which has price breaks, should be based on the pricing_quantity.
In the OE_LINES_IFACE_ALL TABLE when I populate the ordered_quantity with a value of say 10, and pricing_quantity of 15, the order gets imported and created with ordered_quantity and pricing_quantity of 10 for both. My input of 15 for pricing_quantity is ignored. Price is also calculated by order import based on quantity of 10. The value of 15 that i passed is ignored.