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.
HI
Have you thought of using the Inventory Transaction History? Those tables are INTran
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….
Hi
What about turning on the audit history and using those tables?
Hi
Try checking the DAC INItemStats as it maintains both QtyOnHand and Cost.
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!
Hi
What about turning on the audit history and using those tables?
Which tables are those?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.