Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Inventory Value Report
Finance | Project Operations, Human Resources, ...
Answered

Inventory Value Report

(0) ShareShare
ReportReport
Posted on by Laxmi Narayana 130

Dear All,

I would like to ask about the AX Inventory value report.

First of all, I'm running my inventory cost at weighted average and financial cost at Site only.

We have developed a "monthly report" to check the monthly closing qnty at warehouse and site level. This report shows the issue/receipt transactions occurred in inventory related transactions with status “Purchased” or “Sold”.

When I run the inventory valuation report for December-2020 month and monthly report but, Im getting a difference.

Inventory valuation report qnty is lesser than the monthly report.

I believe the Inventory valuation includes only Purchased and Sold status inventory transactions.

Kindly correct me if Im wrong...

Thank you
Laxmi narayana

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report

    Hello Laxmi,

    Great. Is there any other information / help that you need in this regards?

    If this is not the case then let's please verify the answer to get this thread completed.

    Many thanks and best regards,

    Ludwig

  • Laxmi Narayana Profile Picture
    Laxmi Narayana 130 on at
    RE: Inventory Value Report

    Hi Ludwig,

    Many thanks for the reply.

    Yes, I have investigated the Physical and Financial inventory values, both physical and financials are posted and updated as expected.

    The production order was delayed due to pandemic situation..

    I have observed one more here in Inventory valuation Report ID: 

    pastedimage1615380653409v1.png

    I have removed the "Summarize Physical and Financial values" and checked then qnty was coming properly and match with Purchased and sold status inventory for the month.

    When I check this and run the report and run the report (Dec-2020) then it shows the transaction posted as per physical date(Dec-20202).


    Thank you

    Laxmi Narayana

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report

    Hi Laxmi,

    Do you investigate the physical and financial inventory values and quantities or do you have them combined in a single number / column?

    To me it sounds as there is no issue, except that you run the production orders for a very long time.

    What might help here is - if possible - to check and close production orders on a regular basis.

    Sometimes people forget to end them resulting in sometimes strange inventory data and temporary incorrect valuations.

    Best regards,

    Ludwig

  • Laxmi Narayana Profile Picture
    Laxmi Narayana 130 on at
    RE: Inventory Value Report

    Hi Ludwig,

    Thank you for the quick reply.

    I have observed the below details..

    1. A Raw material item "RM-001" of qnty 40 was consumed (Physical date: 03/05/2020) in production order on March-2020.

    2. The Production order was ended (Financial date: 07/02/2020) in July-2020.

    3. When I run the Inventory report for Mar-2020. The item was shown with "-40" qnty.

    4. But, When I run the Inventory report for July-2020. The item was shown with "0" qnty.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report

    Hi Laxmi,

    Do you mean that you have a qty of 0 but an inventory value shown in the report?

    If this is the case then try to run an inventory recalculation first before you open the inventory value report.

    Most of the time the inventory recalculation fixes those issues.

    Best regards,

    Ludwig

  • Laxmi Narayana Profile Picture
    Laxmi Narayana 130 on at
    RE: Inventory Value Report

    Hi Ludwig,

    Thank you for the reply.

    I have found few conditions which cause the difference.

    Can you please help me in one more point?

    In Inventory value report few items Inventory qnty is zero. I couldn't find the reason..

    Thank you

    Laxmi Narayana

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Inventory Value Report

    Hi Laxmi,

    If your self-developed report shows different data than the inventory value report then you have to catch up with the developer who created your report and ask what the difference is.

    The inventory value report can show you the physical and financial inventory transactions, COGS transactions from sales and inventory adjustments. You can also show the transactions that have not been financially updated and that are not posted to ledger yet.

    So, I think the inventory value report gives you a wide variety of what can be reported and what not and you have to find out with your developer how your self-developed report differs from the standard inventory value report.

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans