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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Ledger Reconciliation ...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Ledger Reconciliation - WIP Report Deviation

(2) ShareShare
ReportReport
Posted on by Ammad Jawed1 24
Hi Community,
 
I have questions about ledger reconciliation - WIP report under the project management and accounting module in D365. The question is that the report is showing me a deviation balance of 314.07. The voucher is the same, the only difference 233.57 transaction has 2 dimensions, whereas the 90.50 has 4 dimensions. Account wise, there is a difference. And on the WIP report, we don't have the dimension filter. How to resolve this deviation? I am going to communicate to the client that if the voucher had an offset account as a project, then there will be no deviation.
 
Categories:
Dynamics 365 Finance
Dynamics 365 Project Operations
I have the same question (0)
  • Suggested answer
    SajeedMullaji Profile Picture
    SajeedMullaji 266 on at

    @Ammad Jawed1 
    the deviation is a reporting presentation issue, not a financial corruption — your GL and project subledger are actually in balance. The WIP reconciliation report does a strict line-by-line join using LedgerDimension, which in D365 is not just the main account number but the unique combination of main account plus financial dimensions. When the same voucher has lines with different dimension combinations — your 233.57 with 2 dimensions and 90.50 with 4 dimensions — the join breaks within that voucher grouping and the report throws the unmatched amounts into the Deviation column even though the money is correctly posted.

    On the offset account point — changing the offset account type to Project will not fix this and will actually create a second subledger transaction moving costs between projects. The offset should stay as a Ledger account type.

    For the existing posted voucher — you don't need to reverse it. Confirm your Trial Balance WIP main account total matches your Project Subledger WIP total and your financials are clean. The line-level deviation on that specific voucher is a reporting artefact.

    To prevent this going forward — go to General ledger → Journal setup → Journal names → select the journal name used for these project transactions → General FastTab → change the New voucher parameter to In connection with balance. This forces a new voucher number every time the financial dimension combination changes, giving the WIP report a perfect 1:1 LedgerDimension match and dropping deviations to zero.

    Hope that helps — feel free to mark as verified if it resolves the issue.

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288 Super User 2026 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 270 Most Valuable Professional

#3
Anton Venter Profile Picture

Anton Venter 217 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans