Skip to main content

Notifications

Microsoft Dynamics RMS forum

End of year inventory report

Posted on by 300

Hi,

We are trying to run our end of year inventory report (All the items that are still in the system and the total actual cost of all the items - what we are paying for the items, so we can have total $$ for all the items that we still have in the system)

Is there a report that I can run to generate this results, or do I need to run a SQL query?

If it's via a SQL query do anyone know what query to run?

Thanks in advance

guy

*This post is locked for comments

  • AnnO Profile Picture
    AnnO 40 on at
    RE: End of year inventory report

    Tim-

    also can I get a report that only shows by department so that the report isn't 2500 pages long?

    Ann

  • AnnO Profile Picture
    AnnO 40 on at
    RE: End of year inventory report

    Hello Tim,

    I see your post is several years old, but could you tell me how to set up this customized report to show inventory valuations with a previous date?

    Thanks,

    Ann

  • Craig Wood Profile Picture
    Craig Wood 785 on at
    Re: End of year inventory report

    FP1 has this report, but I have no plans to implement FP1 until all the bugs are worked out, which could take months more. A lot of people are impatiently waiting for this feature pack to be stable and ready to go. There are several features, along with the ability to see inventory cost at a previous date, that will really be helpful. But until I hear from people I trust that it's ready to go, it's going to sit on my hard drive taking up space.

    Remember that the value report in RMS Tim is talking about is for the date you're running it only.

    Craig

  • guylevy Profile Picture
    guylevy 300 on at
    Re: End of year inventory report

    Thank again TimB, this is what I needed!!!

  • Verified answer
    TimB Profile Picture
    TimB 1,175 on at
    Re: End of year inventory report

    In Manager go to Reports --> Items --> Value List. That report can only give the current value of your stock. If you need something from further back you will need a customized report or sql query. This would be a complex query to run for a prior date but possible... Contact me if you're interested in a customized report.

    Thanks, Tim Braun. timmy@rallican.com

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

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,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,129 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans