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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Inventory Trial Balanc...
Microsoft Dynamics SL (Archived)

Inventory Trial Balance / Valuation Variance (10.640.00)

(0) ShareShare
ReportReport
Posted on by JenWal 750

Hello!

I'm trying to figure out why there is a difference between the Inventory Trial Balance (10.630.00) report and the Inventory Valuation (10.620.00) reports. I have run the Inventory Trial Bal/Valuation Variance report (10.640.00) for the quantity format, and it's returning the same results. From the report description, it pretty much tells me that this is a report to find the difference between the two, which is great - But how do we fix it and what made this happen...?

The report is returning the 2 items that we know aren't matching up:

History Qty Total:     Item Site Qty Total:     Variance:

3894.00                    3895.00                       -1.00

1039.00                    1043.00                       -4.00

This happened within the last week. The beginning balances are correct (we double checked), and everything looks great for June until last week.

Any help understading how this happened and how to make these reports balance again would be much appreciated. Thanks!

-Jenny

*This post is locked for comments

I have the same question (0)
  • JenWal Profile Picture
    JenWal 750 on at

    We ran the Integrity Check and were able the find the batches, however we still aren't sure how to fix it. What are the next steps?

  • JenWal Profile Picture
    JenWal 750 on at

    More specifically, we ran Integrity Check to rebuild inventory item history and rebuild item quantity and cost for the 2 specific items that we know are the culprit. We are now receiving the following error message for both items:

    Variances found in master tables for InvtId: '02907' SiteId: 'MAIN'

    Quantity - Item2Hist:3216.00, ItemSite:3217.00, ItemCost:3217.00, Location:3217.00, LotSerMst:N/A

    Cost - ItemHist:7171.68, ItemSite:7173.91, ItemCost:7173.91

    Variances found in recalculated values

    Quantity - Item2Hist:3216.00 (3216.00), ItemSite:3216.00 (3217.00), ItemCost:3217.00 (3217.00), Location:3216.00 (3217.00), LotSerMst:N/A

    Cost - ItemHist:7171.68 (7171.68), ItemSite:7171.68 (7173.91), ItemCost:7173.91 (7173.91)

    System Rules Violation in Table INTran: (Batch '094475', LineRef '03338', RecordID: '21663710')

    transaction amount: 0.00 not equal sum of COGS transactions: -2.23.

    Any help is much appreciated. Thanks!

  • wahoo Profile Picture
    wahoo 275 on at

    Hi Jenwal,

    were you able to find a solution to this issue? I know it was almost a year ago, but I ran into this problem today.   I appreciate any info you can give.  thanks

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi

    You can check the below KB article. Hope this helps you to resolve your issues.

    support.microsoft.com/.../848418

    Thanks & Reagards

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans