Skip to main content
Solved

Where to see the Physical Inventory history


Does anyone knnow where in the system I might be able to find the history of a physical inventory by item?   Is there a report or  screen where I can access that or pehaps someone knows the underlying table that I could look at through the DAC browser?   Any thoughts would be appreciated.

Best answer by ericwolfe74

You could use the inventory Transaction History.  You can enter a specific stock item and date and see when the last time it was counted by the transaction type of adjustment.  If the reference number matches a physical inventory review then that would confirm the transaction was a physical inventory count and not a manual adjustment.  Other than that it would be a custom report or GI.

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

8 replies

Forum|alt.badge.img+3
  • Captain II
  • 317 replies
  • May 19, 2023

Hello @lorneweinstein ,

Acumatica provides its users with the flexibility to create Audit Histories for most of the screens. The below mentioned blog might be helpful to you.

https://www.netatwork.com/setting-up-audit-history-within-acumatica-erp/


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • May 19, 2023

Hi, @lorneweinstein  Below screens might help you with the History of Physical Inventory.

 

 


Thank you both for those suggestions.  However, what I am looking for is to look at a specific item and see the last time it was counted. I dont think either idea will provide that.


bzelinski
Varsity II
Forum|alt.badge.img
  • Varsity II
  • 61 replies
  • May 19, 2023

If you open the individual inventory item and you look on the sidebar you can see “Inventory Transaction History”. Make sure you change the start date to earlier in the year, as it usually sets to the first day of the current month. That will show any time there has been purchases, receipts, or number in stock quantity adjustments. Does that show what you are looking for?

 


It would show if there was an adjustment.  My goal is to be able to see the history of physical inventory by date.  I figure it must be in the system somewhere since the Physical Inventory types by movement class and by ABC know when and how many times an item has been counted.   I would like the same level of info if I count a list of items 


Forum|alt.badge.img
  • Jr Varsity II
  • 42 replies
  • May 19, 2023

That would be a great field, I don’t think it is available. Maybe it should be added as a feature request, it would be useful to just have a field on a stock item showing the last time a PI was completed for said stock item.


Forum|alt.badge.img+1
  • Jr Varsity III
  • 66 replies
  • Answer
  • May 20, 2023

You could use the inventory Transaction History.  You can enter a specific stock item and date and see when the last time it was counted by the transaction type of adjustment.  If the reference number matches a physical inventory review then that would confirm the transaction was a physical inventory count and not a manual adjustment.  Other than that it would be a custom report or GI.


Forum|alt.badge.img
  • Jr Varsity II
  • 42 replies
  • May 22, 2023

@ericwolfe74 

 

If the item was counted but not adjusted (stock was correct already) then it would not show up on the transaction history. We are suggesting that it would be nice to be able to see the last count date without relying on the part having to have been adjusted.


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