Skip to main content
Solved

Purchase Order Details by Inventory ID

  • October 25, 2022
  • 8 replies
  • 567 views

Forum|alt.badge.img

Hi,

 

I am trying to run a report that lists all PO#’s (Open, Closed, etc.) that include a specified Inventory ID.

 

The Purchase Order Details by Inventory ID seems exactly what I am looking for but it only lists results for items that have Open POs? 

 

The Inventory Transaction History shows the PO receipt #, but you need to navigate individually through the PO receipt to get the PO# so no value.

 

The Inventory Allocation Details only shows outstanding POs.

 

Can’t imagine this doesn’t exist out of the box - surely the Purchase Order Details by Inventory ID can display results including both Open and Completed Orders?

 

 

Best answer by Kandy Beatty

HI @jwarren 

You could add Status on the report and include all statuses.

 

View original
Did this topic help you find an answer to your question?

8 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • October 25, 2022

HI @jwarren 

Here is the help on what each report is supposed to show. 

https://help-2022r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=6b911951-74c7-46d2-a9e3-2bc2bf3ff977

 

For this report: Purchase Order Details by Inventory ID- is there possibly a filter on that report?


Forum|alt.badge.img
  • Author
  • Varsity III
  • 112 replies
  • October 25, 2022
kbeatty21 wrote:

HI @jwarren 

Here is the help on what each report is supposed to show. 

https://help-2022r2.acumatica.com/(W(1))/Help?ScreenId=ShowWiki&pageid=6b911951-74c7-46d2-a9e3-2bc2bf3ff977

 

For this report: Purchase Order Details by Inventory ID- is there possibly a filter on that report?

Hi there,

 

The report is actually only showing Open POs for the specified Inventory ID (not only Critical Materials - I misdiagnosed the issue).

 

Is there a way I can go into Report Designer and modify so it shows a full history of POs (regardless of Open vs Closed?)


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2209 replies
  • Answer
  • October 25, 2022

HI @jwarren 

You could add Status on the report and include all statuses.

 


Forum|alt.badge.img
  • Author
  • Varsity III
  • 112 replies
  • October 25, 2022

Thanks Kandy.

 

That worked for me.

 

Jack


bigred1022
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • 31 replies
  • May 24, 2024

Hey @jwarren , I’m experiencing this same exact issue with the same exact report.  Did you do anything else besides adding the POOrder.Status to the Sorting and Grouping tab in the Schema Builder?  I have saved it back to our server, it’s active, and I can still only get Status of OPEN in the report.


Forum|alt.badge.img
  • Jr Varsity III
  • 51 replies
  • June 19, 2024
bigred1022 wrote:

Hey @jwarren , I’m experiencing this same exact issue with the same exact report.  Did you do anything else besides adding the POOrder.Status to the Sorting and Grouping tab in the Schema Builder?  I have saved it back to our server, it’s active, and I can still only get Status of OPEN in the report.

have you found the answer to this? I am trying to solve this exact same issue.


bigred1022
Jr Varsity II
Forum|alt.badge.img
  • Jr Varsity II
  • 31 replies
  • June 19, 2024
BrendanL wrote:
bigred1022 wrote:

Hey @jwarren , I’m experiencing this same exact issue with the same exact report.  Did you do anything else besides adding the POOrder.Status to the Sorting and Grouping tab in the Schema Builder?  I have saved it back to our server, it’s active, and I can still only get Status of OPEN in the report.

have you found the answer to this? I am trying to solve this exact same issue.

Unfortunately not yet.


Forum|alt.badge.img
  • Author
  • Varsity III
  • 112 replies
  • June 19, 2024

Hey guys @bigred1022 & @BrendanL ,

 

Take a look at the filters tab - there are some conditions that you will need to delete.

 

Believe I deleted POLine.Completed = False if you want to see the Completed PO lines. I left on POLine.Canceled = False on my report as I did not want to see cancelled POs in my report.

 

Good luck.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings