2. Select Transaction type.
3. Under Criteria Tab > Standard Subtab.
-- Add Type = Transfer Order
-- Add Transaction Line Type.
-- Select Item to see only Item related lines.
4. Under Results Tab > Columns Subtab, set the following:
-- Number
-- Date
-- Location
-- Item
-- Item Style Name (Custom)
-- Item Colour (Custom)
-- Quantity > Function = Absolute Value so it will appear in Positive value
-- Transfer Order Quantity Committed
-- Transfer Order Quantity Sending to Warehouse
-- Transfer Order Quantity Packing
-- Transfer Order Quantity Fulfilled
-- Transfer Order Quantity Shipped
-- Formula (Numeric) and set Formula= ({quantity}+nvl({transferorderquantitycommitted},0))+nvl({transferorderquantityshipped},0)
3. Click Save and Run.
No comments:
Post a Comment