Saturday, September 8, 2018

Search for Item Receipts where the Quantities Received are not the same with the Return Authorization's Quantities

  • User has Allow Overage In Item Receipts = True (Setup > Accounting > Accounting Preferences > Order Management tab).
  • User has discrepancies between Return Authorization and related Item Receipts transactions
  • This refers to Customer Return Authorization.

To search for item receipts where the quantities received are not the same with the return authorization's quantities:

1. Navigate to Lists > Search > Saved Searches > New > Transaction.


2. In the Criteria tab > Standard sub tab > add the following filters:

  • Type = Return Authorization
  • Applying Transaction Fields > Type = Item Receipt
  • Formula (Numeric)
  • Formula = {quantity}-{applyingtransaction.quantity}
  • Formula (Numeric) = not equal to
  • Value = 0
3. In the Results tab > Columns sub tab > add the following fields:

  • Quantity
  • Applying Transaction Fields = Quantity
  • Formula (Numeric) = Formula is {quantity}-{applyingtransaction.quantity}
4. Preview or Save the search.

  • This will list those transactions wherein the return authorization and item receipt quantities are not equal. 
  • If the Formula (Numeric) column has a negative quantity, this means that the Item Receipt has lesser quantities compared to its related Return Authorization.
  • A positive quantity means the Item Receipt quantities is greater that the Return Authorization (there is an overage).
Note:  User might want to rename the columns to avoid confusion. Simply add a text in the Custom Label field for each column. This can be found at Results tab > Columns sub tab.  

No comments:

Post a Comment