Finance | Project Operations, Human Resources, ...

Inventory value report Ax2012R3

(1) Share

Report

Posted on by Nieves

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.

All responses (3)

Answers (0)

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

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 15 on at

Like (0)

Report
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 31^st 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:

Version 1. Report was downloaded at the beginning of November 2023 when doing the regular inventory closing activities.

Version 2. Report was downloaded today 9^th 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 1^st November 2018.

As standard procedure, the inventory was closed on the 31^st 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 Cal... 291,280 Super User 2024 Season 2 on at

Like (1)

Report

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.