Skip to main content
Solved

Identify any stock item where the QTY available has changed

  • 26 September 2024
  • 6 replies
  • 51 views

Forum|alt.badge.img+6

Hello,

We are trying to identify stock items where the QTY available has changed since xx/xx/xxxx date.  This would be run periodically to support something they are attempting to do.  I thought InSiteStatus was the ticket, but they did an inventory receipt (it was released) and the date indicated did not change.  Any suggestions on how I can get the date the available QTY of a stock item has changed.  

 

Best answer by Kandy Beatty

Hi @ltussing03 

What about turning on the audit history and using those tables?

 

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

Kandy Beatty
Captain II
Forum|alt.badge.img+16

HI @ltussing03 

Have you thought of using the Inventory Transaction History? Those tables are INTran

 


Forum|alt.badge.img+6
  • Captain II
  • September 26, 2024

Kandy, thanks for the suggestion!  However, we are not just looking at inventory.  We want to know if availability changed by looking at a single field with the part ID in it.  So, if a Sales order is entered, that would change the availability without an inventory transaction etc….


Kandy Beatty
Captain II
Forum|alt.badge.img+16

Hi @ltussing03 

What about turning on the audit history and using those tables?

 


hdussa
Jr Varsity I
Forum|alt.badge.img
  • Jr Varsity I
  • September 26, 2024

Hi @ltussing03 ,

Try checking the DAC INItemStats as it maintains both QtyOnHand and Cost.


Forum|alt.badge.img+6
  • Captain II
  • September 27, 2024

Thanks everyone for the replies!

 

I was hoping to have a table out of the box that could be utilized.  However, it looks like we need to apply some logic and determine this date on our own.

 

Thanks again for taking the time to add input!


cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Semi-Pro III
  • October 3, 2024
Kandy Beatty wrote:

Hi @ltussing03 

What about turning on the audit history and using those tables?

 

Which tables are those? 

 


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