Finance | Project Operations, Human Resources, ...

Cost group updated cause variance between Trial balance vs. Inventory value report

(3) Share

Report

Posted on by HH-24110303-0

There are several item cost group updated cause variance between Trial balance vs. Inventory value report. Is there any report can be used for tracing all these item transactions with inventory account code, thanks! Thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

H.M.Burhan 390 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you check the following two reports in Inventory management module?

Cheers,

Burhan

Was this reply helpful? Yes No
HH-24110303-0 10 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Thanks for your professional suggestion. I check the two reports, many transactions I cannot find the variance breakdown of inventory value report vs. Trial balance report. Can I find a report to get full detailed accounts of these cost group undated items? Thanks!

Best Regards,

Heman

Was this reply helpful? Yes No
H.M.Burhan 390 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Heman,

I’m afraid you may not be able to obtain all the details you are looking for from a single report. However, you can extract the required information from various inquiries and reports, and then consolidate the data in Excel to achieve the desired results. Alternatively, you may consider developing a custom report.

Typically, reconciliation issues arise when transactions are posted directly to subledger accounts—i.e., the accounts configured in the module’s posting profiles. To help identify such cases, ensure that a separate voucher series is set up for General Journals. You can then filter voucher transactions based on this voucher series (or its prefix, if one has been defined). If you find any entries posted directly into subledger accounts, these should be reversed.

Finally, verify whether any customisations in your module are posting directly to General Ledger main accounts and bypassing the subledger processes. If this is occurring, it indicates an incorrect approach. The customization should be corrected so that GL entries are always recorded through the appropriate subledger processes.

I hope the above information is helpful. Let me know if you need further clarification.

Cheers,

Burhan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future.

Was this reply helpful? Yes No
Suggested answer

H.M.Burhan 390 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Heman,

Please check the Reconcile Accounts AI agent. You may benefit from this feature and may not need to develop an SSRS report for the inventory reconciliation issue you mentioned.

https://learn.microsoft.com/en-us/dynamics365/release-plan/2025wave2/enterprise-resource-planning/dynamics365-finance/reconcile-accounts-faster-using-enhanced-account-reconciliation-agent

Cheers,

Burhan

Was this reply helpful? Yes No