Skip to main content
Solved

Where can i View Consumption ?

  • Feb 8, 2024 6:16 PM UTC
  • 5 replies
  • 315 views
  • Translate All

cervantes09
Freshman I
Forum|alt.badge.img

where can i view consumption per part number ?

 

Thank you. 

Best answer by jharris

Without MRP, you’ll need a custom GI to see the different material movements (Including Consumption and Adjustments). 

Here’s one that will break down Material Details by Transaction Date, Inventory ID, Production number, Work Center, and individual operations.  It will include reference numbers you can drill down into.  This GI pulls all the records and will take a little bit to pull all the data, so I suggest setting a parameter of your choosing. 

Otherwise you can also look at Inventory Transaction History but you’ll need to figure out what kind of issue/receipt the transaction type refers to and it isn’t easy from that screen...  

 

Let me know if this helps.

Thanks,

James

View original

5 replies

Debbie Baldwin
Community Manager
Forum|alt.badge.img+2
  • Acumatica Product Manager
  • Feb 8, 2024 6:18 PM UTC

@cervantes09 - can you provide more details? 

Translate

cervantes09
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • Feb 8, 2024 6:19 PM UTC

for replenishment purposes, how do i view my part number (inventory) consumption? i see replenishment data but do not find historical or open order(s) consumptions 

Translate

jharris
Semi-Pro I
Forum|alt.badge.img+8
  • Semi-Pro I
  • Feb 8, 2024 6:36 PM UTC

Hi @cervantes09 !

Under Material Requirements Planning, you can go to the Detail Inquiry here:
 

Select the inventory ID you’re looking at, and it’ll show you the total QTY on hand, as well as the historical production orders and purchase orders. If set up, it will also shoe you your Reorder Points, Min/Max Qty’s, Lot Qty, Replenishment source, lead times, etc.  

Translate

cervantes09
Freshman I
Forum|alt.badge.img
  • Author
  • Freshman I
  • Feb 8, 2024 6:43 PM UTC

i don't have his option 

Translate

jharris
Semi-Pro I
Forum|alt.badge.img+8
  • Semi-Pro I
  • Answer
  • Feb 8, 2024 6:55 PM UTC

Without MRP, you’ll need a custom GI to see the different material movements (Including Consumption and Adjustments). 

Here’s one that will break down Material Details by Transaction Date, Inventory ID, Production number, Work Center, and individual operations.  It will include reference numbers you can drill down into.  This GI pulls all the records and will take a little bit to pull all the data, so I suggest setting a parameter of your choosing. 

Otherwise you can also look at Inventory Transaction History but you’ll need to figure out what kind of issue/receipt the transaction type refers to and it isn’t easy from that screen...  

 

Let me know if this helps.

Thanks,

James

Translate