Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

Inventory Value on Previous Date?

(0) ShareShare
ReportReport
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,382 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

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,703 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans