Adding PO Receipt data in PO saved search

Hi All,
I have recently created a saved search with PO data (from all levels) and it is working fine. Now I am needed to add when the corresponding item was receipted to the existing search. I need to use the ‘Delivery Due Date’ from the related item receipt for this. I did try to add it but the receipt field data is not available in the field dropdown.
Can someone please help in this regard?
Thanks in advance.
Beginner Asked on October 23, 2020 in Saved Searches.

If your search is based on the PO which it should be, then you need to reach into the Item receipt for that information.  There is a field called. “Fulfilling/Receiving Transaction” That will get you the IR, to pull fields from the IR, you need to got to  “Fulfilling/Receiving Transaction…” at the bottom and select fields from that record.  Below is a screen grab of what my search looks like. Bear in mind that this creates multiple lines if there are partial receipts.  So if you want it all on one line and you do have multiple receipts you’ll need to do a summary search and set the date the maximum. That will get you the date of the latest receipt.

Adding PO Receipt data in PO saved search



on October 23, 2020.
Add Comment
1 Answer(s)

Never mind, found the answer. Thanks

Beginner Answered on October 23, 2020.
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   Become a Sponsor   Become a Sponsor