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+10
  • Captain II
  • 389 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
  • 525 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
  • 2640 replies
  • July 31, 2024

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


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