Friday, June 28, 2019

Search to Show Billed Quantity or Receipted Quantity is Greater than the Purchase Order Quantity

1. Navigate to Lists > Search > Saved Searches > New > Transaction.
2. Under Criteria subtab, mark the Use Expressions check box.
3. Under Criteria subtab, enter the following:
Type: is Purchase Order And
( Formula (Numeric): ABS{quantity}-ABS{quantityshiprecv} is greater than 0 Or
Formula (Numeric): ABS{quantity}-ABS{quantitybilled} is greater than 0 )
4. Under Results subtab, enter the following:
Date
Number
Quantity
Quantity Billed
Quantity Fulfilled/Received

Formula (Numeric): ABS{quantity}-ABS{quantityshiprecv}
Custom Label: Quantity not yet Received

Formula (Numeric): ABS{quantity}-ABS{quantitybilled}
Custom Label: Quantity not yet Billed

5. Enter a Search Title and click Save.

No comments:

Post a Comment