Inventory Valuation List match on total but not in detail

(0) Share

Report

Posted on by Hecht

125

When I run the Inventory Evaluation list, the total value of the list equals exactly with the Cost Posted to G/L and again the same amount is booked in the G/L. Something must be right

Chart of Account

If I then go into details with the Valuation list, the inventory does not match the inventory seen on the Items list screen:

Item list screen:

Can you please help me and explain this exiting phenomenon?

Version: DK Business Central 16.5 (Platform 16.0.15884.15941 + Application 16.5.15953.0) - On Premise

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

JAngle 152 on at

Like (0)

Report
Copy link

Link copied!

Are you running the report in a like for like way with the list? Inventory valuation can be run with a date or location filter. You can add a date or location filter on the list page too but by default they’re off

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

In addition to what Josh wrote, when I teach about reconciling Inventory to G/L I show users the Inventory to G/L Reconcile report. This truly breaks down the Inventory Valuation (Qty/dollar) to Received not Invoiced, Shipped not Invoiced, Expected entries, and what was Posted to G/L. Consider running this report.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Hecht 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you both for your helpful inputs. The report is run without any filters which is necessary to make the list total match the finance account. "Include Expected Cost" was off.

When I switch it on, I get this information regarding the upper line in my example. The -8 expresses the inventory without the latest Purchase Receipt (which have not been invoiced yet).

The quantity 17 mirrors the actual inventory including latest purchase received (purchase 25 pcs). It is the same inventory as seen on the Item List screen.

I wonder if there is a list that shows the exact inventory seen on the Item List screen regardless of the purchase being invoiced or not?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello,

I ran the Inventory Valuation Report, shown below, which matches my Item List (2nd pic).

Hope this helps. Not sure if you use Jet Report or Power BI, but both these reporting tools can also help.

Thanks,

Steve

Was this reply helpful? Yes No