Skip to main content

Notifications

Microsoft Dynamics RMS forum

Inventory Value on Previous Date?

Posted on by 40

Hello,

We are running MS RMS 2.0 for a single store location.

I am trying to find a way to run a report or calculation that will simply show me the inventory value on a specific past date.  We are trying to look at inventory at the last day of every month back to December of 2009. From forum postings it appears that FP 1 has a new report that will allow us to get this data. However,we do not have Feature Pack 1 loaded and I would like to avoid it if possible. It looks like if we do load this we will have to go through a complex fix to get the reports for past data, and we would like to keep the store open for business during this process if possible.

I saw a forum posting that recommended that we run the current inventory value and than run an "item movement history report" for every date for which we want an inventory number, than subtract the two. I am not familiar with the item movement history report.  Can someone please verify that this will get us what we want, and that the reports won't take 1 hour each to process! :) We have about 2600 pos items in stock.

Or is there an easier way to get this data? If there is an easy custom report out there please let me know where.

Thanks,

Jeff

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Value on Previous Date?

    Hi Ahmed,

    Can you please provide me the query, I am fine without value too.

    Thanks in advance.

    Upendra Nath M.

    nathupendra@gmail.com

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: Inventory Value on Previous Date?

    Check with RITE www.rite.us as they have some kind of look-back report available.

  • Jcrouch Profile Picture
    Jcrouch 40 on at
    Re: Inventory Value on Previous Date?

    Thanks for the offer, but we need the quantity and cost so that we can calculate the total value on that given date.

    If I am understanding you correctly we would lose all cost data so that won't work for us.

    Thanks though!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Inventory Value on Previous Date?

    Jeff

    I can provide u with a query that does the job for u but it handles only the quantities without the cost, so it's the inventory (without value) on a previous date.

    A Hassan

    RMS Leaders

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

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans