historical inventory (Item Value List)

Posted by OlyBikes on January 23, 2007, 9:39 pm

Please log in for more thread options

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!

124 State Avenue NE
Olympia, WA 98501

P: 360-753-7525
F: 360-528-7526
info@olybikes.com

www.olybikes.com
Featuring free bike advocacy and safety materials!

Posted by smower on January 25, 2007, 11:37 am

Please log in for more thread options

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 ...

--
Stephanie L. Mower
TnK Group, Inc. Technical Associate
smower@tnkgroup.com
148 Maple St.
Danvers, MA 01923
(978) 774-0244

> 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!

> 124 State Avenue NE

> Olympia, WA 98501

> P: 360-753-7525

> F: 360-528-7526

> info@olybikes.com

> www.olybikes.com

> Featuring free bike advocacy and safety materials!

Posted by Glenn Adams [MVP - Retail Mgmt on January 25, 2007, 1:02 pm

Please log in for more thread options

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 Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

smower wrote:

> 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 ...