web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Answered

Trial balance Vs Inventory value report not matching

(0) ShareShare
ReportReport
Posted on by 92

Hi All,

 i am going through Trial balance Inventory Vs Inventory value report both are showing different value 

First Please let us know what is the cause of this difference 

and second can i get ledger stock by items which is matching with Trial balance

I have the same question (0)
  • Verified answer
    saurabh bharti Profile Picture
    15,039 Moderator on at

    Hi Imran,

    This is a common reconciliation issue:

    Few basic checks :

    1. Create Inventory value report ID to generate at transaction level along with Item, Item group etc..

    2. Extract Inventory value report for the month where difference exists, You will get Voucher wise amount

    3. Extract Voucher transactions for inventory Main accounts (Make sure you includes - Posting type)

    4.  You can first check in extracted vouchers , are there entry with posting type "Ledger" if yes then those transactions will not be available in Inventory value report because those are direct ledger entry without item

    5. Do comparison of vouchers between both extracts and find the difference

    6. If you are following moving average, look if this difference is due to purchase price variance account

    7. Apart from this you can generate standard report which gives conflicts between inventory and ledger

    pastedimage1629067830156v2.png

  • Suggested answer
    Prem Kumar Bachu Profile Picture
    3,418 on at

    Hi Imran,

    There might be some adjustment transactions directly posted to main account if you do not opt for "Do not allow manual entry" in the main account.

    We have to check it for all the main accounts related to inventory mapped in inventory posting.

    Regards,

    Prem

  • jannawangD365 Profile Picture
    on at

    potential conflict report is a very useful tool when you doing the inventory reconcilliation.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 296 Super User 2025 Season 2

#2
Siv Sagar Profile Picture

Siv Sagar 178 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 123 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans