Purchase Receipt Inquiry PO-Receipt - Add Order Number

Hi Nathan,

You are correct that it could be a One-to-Many Relationship. 
I would proceed like this:

Take a copy of the Inquiry and work with Add Related Tables to add the PO Order Table. If the result is as expected and works after you add the Field, great! If not, I would recommend exploring Side Panels if you are in 2022R2 or above. There you can have a side by side view of Purchase Receipt and Purchase Orders connected to it. 

If you need help with that, feel free to ask additional Questions!

@krausef77 adding the PO Order Table gives the field “OrderNbr” but it does not show any results, probably requires some relations/parameters?

Anyways, looks like the default side panels from 2022 R2 includes a quick view of the purchase receipt where you can see the orders tab.

Thank you!

If you share the Inquiry as .xml or Screenshots of the Relations you have set-up the Community could take a deeper look if needed.

@krausef77 I’m not really sure where to start.

I know how to add the table, but not sure how to setup the correct table relationship.

Any assistance is appreciated. The side panel is great, but what we really want is to be able to filter/search by PO Order number. There is a “origPONbr” within the POReceipt table, but that displays no results in the inquiry.

Do you mean you want to see this below?

@marina25 Originally, we wanted to show the PO Order Number in the PO-Receipt inquiry. But, we also want to show the PO Receipt Number in the PO-PurchaseOrder inquriy.

Did you add the POReceipt table to the PO-PurchaseOrder inquiry? Also, I wonder if this will list all of the PO Receipt Number relating to the PO Order Number?

Highlight the PO Receipt Table and click Add related Table:
 

Search for POOrder and hit Select Related Table when you marked the POOrder Table Line.
Click Add. 
Acumatica will do the Join for you.

Confirm after adding the necessary fields that the Results are the same (that’s why I always take a copy for Testing, so I do not mess with the native Inquiry):
 

I hope this helps for Starters

Try to import this GI XML 

@marina25 this almost worked, but I suspect we are running into an issue because of 1-to-many relationship. I tested briefly how it would react to a PO Order with multiple (2) PO Receipts.

It shows the first PO Receipt but not the second PO Receipt in the GI. Also, it duplicates the “Order Qty” in the GI. In my sample, the original order qty was 100. I did a PO Receipt for 50, then for the remaining 50. In the GI it shows the first PO Receipt and the order qty as 200 instead of 100.

Then you need to group by multiple parameters and I am using the PO inquiry not PO Receipt. The repetition is driven by grouping and PO Receipt Line.

@marina25 I imported the xml to the PO-PurchaseOrder GI. Any suggestion on the additional grouping parameters required?

Try some of the fields from the drop down below

It duplicates the quantity received from PO GI. I would need to add PO from PO Receipts GI. I will work on it and will post it. 

@marina25 I appreciate your help!

Try this table from Purchase Receipts

@marina25 thank you for sharing - I will give that xml a try

Hi @nathantrauscht  were you able to find a solution? Thank you!

Hi @Chris Hackett / @nathantrauscht ,

I tried the join  POOrderPOReciept with the POReciept and it worked as required. It is fetching the PO# on the PO Receipt GI.

Attaching the XML file.

Cheers!

Shilpi