Historical Inventory Report help

(0) Share

Report

Posted on by VandyDoc

I have a client who needs a physical inventory from 12/31/08 with POS 2.0. The inventory report does not allow me to change the date. Any ideas on doing a custom query or another solution? Thanks in advance K

*This post is locked for comments

All responses (5)

Answers (0)

Jean Holland 350 on at

Like (0)

Report

Re: Re: Re: Historical Inventory Report help

The report we have will work if the customer has been using purchase orders to receive goods. Otherwise, there is no other way than to restore a data base backup from the date in question. Jean
Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Re: Historical Inventory Report help

You can contact either Jean or myself and we'll help you with this. let us know if our customer has been using Purchase Orders.

Marc Cotton

mbcotton@princeton-pos.net
VandyDoc 70 on at

Like (0)

Report

Re: Re: Historical Inventory Report help

Thanks Marc and Jean for your suggestions. It sounds like a good idea for any future reporting. Am I right that that would have to be done from today onward? So the report she needs from 12/31/08 is a no go? Thanks again Kevin
Jean Holland 350 on at

Like (0)

Report

Re: Historical Inventory Report help

We have a "Back In Time" report that will generate the actual inventory counts on a particular day. Since RMS does not store historical inventory counts, you need a report that will calculate the count on that day. The suggestion by Marc Cotton is really the best way to capture and save inventory counts for reporting purposes but until you implement a solution such as that you can use this "Back In Time" report. Jean Holland Group, LLC, jean@jeanholland.com
Community Member Microsoft Employee on at

Like (0)

Report

Re: Historical Inventory Report help

We put a trigger into a customer's database that accumulates inventory snapshots on a defined schedule. That was the only way we could lookback. I'd like to know of other options if they exist.

Marc Cotton

Princeton POS