You have to implement muli-warehouse in your database, then go to the Warehouse menu, ->Inventory control->Location Structure. Select from the browse any location, and you'll get a screen that asks you to either 'Analyze current inventory' or 'Analyze period', as a selection from a combo box. Then a browse contains products with quantities represent that overall qty stock of each product over the selected period, or up to the current moment. This is a 'stock ageing' calculation.
You can export it to excel and get the result you desire
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/6/15, 4:56 PM|
|Seen: 786 times|
|Last updated: 9/20/15, 4:36 PM|