Hey Guys, we can get the current stock of any inventory using inventory part in stock window. But we need stock report on any previous date. Is it possible? Please let me know.
Best answer by ShawnBerk
View original
Is it possible to get stock report at a specific time or date?
Userlevel 3
+4
Userlevel 6
+20
Check if the Inventory Part OnHand Development page will get you what you need.
No, you can’t retroactively look at what the inventory position was at a previous point in time for all inventory as a total. You can work out parts on an individual basis, but there is no way to go back in time for the total.
Userlevel 3
+4
Thanks to Mr.matt.watters for your comments. Its very helpful to me.
If you have the Database Task ‘Aggregate Inventory Transactions per Period’ scheduled you can go back to the end of the previous financial period (usually month) by looking in the screen ‘Inventory Value per Period’.
If you have a recurring requirement to look back at stock positions on a more granular level I would create an IAL which you schedule to ‘Copy Only New Data’ at a frequency that suits your needs.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.