Need Help with Saved Search of Item Receipt discrepancies from Purchase Orders

Hello, I am looking to create a saved search that shows item receipts for purchase orders by item that were received either over or short of the quantity that was ordered.

Any help would be appreciated.

Thank you,


Rookie Asked on November 5, 2019 in Saved Searches.
Add Comment
3 Answer(s)

This should get you over received.

Type= is PO
Main line = falase
Item= is none of none

Document number
Quantity fulfilled/received
Formula (text):  {quantityshiprecv}-{quantity}

Rookie Answered on November 8, 2019.
Add Comment

Thank you, what kind of search is this, item, transaction, etc? When I put the criteria in, I can’t put item as “is none of none”. It is looking for actual items.

Rookie Answered on November 12, 2019.
Add Comment

This is a transaction search.

Item none of none eliminates any that don’t have an item. This will get you your results.

Rookie Answered on November 12, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor