Saturday, February 23, 2019

Transfer Order Search displaying Back Order quantity.

1. Navigate to Reports > New Search.
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