Is there any way to get RMS to display the Item Value List on previous dates?
I would like to be able to view historical inventory category values.
TIA
______________________________________________________
Larry Leveen OlyBikes Bikes, Parts, Repairs & GREAT Customer Service!
P: 360-753-7525 F: 360-528-7526 snipped-for-privacy@olybikes.com
I actually just contacted Microsoft about this myself for a client of mine.
They informed me that the inventory lists are real-time only, that there is no way to pull historical data from the system. I'm hoping they have solved this problem in v2.0, but I do not know yet.
The only way I can see to do it is to write a custom report pulling the current inventory list and reversing sales and inventory updates, but I don't know if all the information needed is stored in tables ...
There is an article in the knowledge base that explains how to calculate inventory for a previous date by using the current quantity and the Item Movement. You have to run 2 reports and do some math, but it CAN be gotten out of the system.
I believe there are some add-ins available that make it easier, but I don't have any specifics on that. There are various techniques that can be used to take 'snapshots' of inventory at set periods to make this easier...
Glenn Adams Tiber Creek C> I actually just contacted Microsoft about this myself for a client of mine. >
Have something to add? Share your thoughts — no account required.
Ask the community — no account required