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.
Solved
Is it possible to get stock report at a specific time or date?
+4Best answer by ShawnBerk
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.
+25Check if the Inventory Part OnHand Development page will get you what you need.
If a response resolves your issue, please use "Best Answer" so that the thread can be closed and others can find solutions more easily. Regards - Matt
1 person likes this
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.
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.