web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Historical Inventory R...
Microsoft Dynamics RMS (Archived)

Historical Inventory Report help

(0) ShareShare
ReportReport
Posted on by VandyDoc 70
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

I have the same question (0)
  • Jean Holland Profile Picture
    Jean Holland 350 on at
    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 Profile Picture
    Community Member on at
    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 Profile Picture
    VandyDoc 70 on at
    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 Profile Picture
    Jean Holland 350 on at
    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 Profile Picture
    Community Member on at
    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 

      

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans