Sunday, June 9, 2019

Formula for item saved search to show quantity received from Purchase Orders

In an Item Saved Search, to add a column for quantity received from Purchase Orders user can add in the Results tab > Columns subtab > Field is Formula (Numeric) then the formula is DECODE('Purchase Order',{transaction.type},{transaction.quantityshiprecv})

No comments:

Post a Comment