Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Inventory value report Ax2012R3

Posted on by 15
Hi all, i hope that someone can help me.
We´ve been using the inventory value report to reconcile our inventory, but for the past few months, once the inventory is already closed, the output of the report is different, and we´re not able to find the explanation for it.

Let me be a little bit more specific:
Inventory closed for Jun23, i get the inventory report (specific settings) as of the 30 June 2023 after the inventory is closed, and i get a financial qty and a financial amount.
If i get the report some time later, same report, same "as of date (30.06.2023)", the output is different. We have looked at one specific item and the difference is kept in the opening balance, even though we know that that item didn´t have a beginning balance. Have anyone experience the same? any ideas? I´m using Ax2012R3 version. Thanks a lot in advance.
Categories:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    Inventory value report Ax2012R3
    Hi Nieves,
     
    The reference type Opening balance is not standard. Do you have a customization or partner add-on in your environment that has additional functionality for an inventory opening balance? Can you check that?
  • Nieves Profile Picture
    Nieves 15 on at
    Inventory value report Ax2012R3
    Thanks a lot André for your answer, but i don´t think i have explained myself properly. Tried to describe in detailed the problem we´re facing. Thanks again for your help. Much appreciated. 
     
    Description of the issue
    Inventory value report is providing different values (quantities, financial value and physical value) for the same resource/item, same time frame when inventory closing activity, as standard process, is been done for the requested period.

    Description of the issue for an specific resource/item nº 008816
    We need to know the financial quantity of item 008816 as of the 31st of October 2023, taking the starting point as the initial date of inventory transactions for that specific company. That year was 2018, but to be sure we get everything, we will use as “From date”=”01-01-2000” and “end date” = 31-10-2023.

    Find below the 2 different outputs for the same report/same settings, same resource/item and same time frame:
    1. Version 1. Report was downloaded at the beginning of November 2023 when doing the regular inventory closing activities.
    2. Version 2. Report was downloaded today 9th July 2024 to document the potential inconsistency of the inventory value report.

    Version 1
    Financial quantity for item 008816 is -406.34 pieces.

    See below the settings:



    Version 2



    Difference
    if I take the transactions report for the same item, same period-see below settings:



    I get an opening balance of 100 pieces, without a voucher/number, that it´s the exact difference and that it is wrong, because this company starts running inventory in 2018. You can also see the first transaction on the 1st November 2018.


    As standard procedure, the inventory was closed on the 31st of Oct 2023. Pl see below.

    How can the same report, same settings, same period, same item/resource shows different quantities, and put the mismatch as “opening balance”? Thanks.
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    Inventory value report Ax2012R3
    Hi Nieves,
     
    When you closed inventory on June 23, anyone can post transactions after this date at any time. If you run the value report today, after new postings, it can indeed have other transactions included. If you close inventory on June 30, then no new transactions are possible on or before that date anymore.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans