RE: 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.
VishalThoughts Rookie 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.

RE: Adding PO Receipt data in PO saved search

 

 

on October 23, 2020.
Add Comment
1 Answers

Never mind, found the answer. Thanks

Rookie Answered on October 23, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.