Skip to main content
Question

Report/GI for Inventory Consumption by Project


Hello, I’m looking to pull together a report or GI that can show our PM team the inventory that has been consumed (issued) by each of their projects. The report/GI would need to group together each SKU that’s been issued. For our company, we are issuing material as a way of consuming it out of our inventory and into either production in the factory or directly sent to the job site.

 

For example, we have project A and B and inventory items 1,2 and 3. I need something that shows us for project A, how much of items 1, 2 and 3 have we Issued and the same thing for project B.

 

I have looked into the Project Cost History report, but this doesn’t show us the SKUs that have been issued.

 

Thanks!

5 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • Captain II
  • 547 replies
  • June 21, 2024

Hi @brettsolomon 

Please refer to the "Project Balance" report available on Acumatica
You can edit this report to make it best for you.

 

 

 

Best Regards,

NNT


  • Author
  • Freshman I
  • 7 replies
  • June 24, 2024

This isn’t quite the report that I’m looking for… looking to put together a GI that can list our every issue that’s occurred on the line item level for each project. If you/anyone knows how to pull this together, that would be greatly appreciated!


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 562 replies
  • June 24, 2024

@brettsolomon could something like this give you what you need? I filtered it down to the one project i was testing with but essentially it shows the inventory ID with what the revised qty is on the cost budget and there’s a column for actual quantity? 

 

in this case, I had two issues but I think grouping by inventory ID would be helpful.  

 


  • Author
  • Freshman I
  • 7 replies
  • June 25, 2024

Might need to look into asking our implementation team to pull together a custom report for us as these aren’t exactly the types of reports that we need. Appreciate the responses everyone!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2780 replies
  • July 31, 2024

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


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