Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Inventory Valuation List match on total but not in detail

Posted on by 81

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 

3580.jpg

2475.jpg

Chart of Account

 4555.jpg

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

 7635.jpg

1715.jpg

Item list screen:

4885.jpg

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

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Valuation List match on total but not in detail

    Hello,

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

    pastedimage1612307596119v1.png

    pastedimage1612307615198v2.png

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

    Thanks,

    Steve

  • Hecht Profile Picture
    Hecht 81 on at
    RE: Inventory Valuation List match on total but not in detail

    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).

    4743.jpg

    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?

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory Valuation List match on total but not in detail

    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.

    pastedimage1612212358759v1.png

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,137 on at
    RE: Inventory Valuation List match on total but not in detail

    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

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... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans