Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
We have issue of difference of values between the GL and Reports
We have individual GL code for FG, WIP, Projects ...
after generating the report , we found the mismatch of the values respectively
Mainly the Production posting hits different journals
please advise, from where to start the reconciling or check the mapping
As per GL (INR)
As per Report (INR)
Good Morning Sriram GS,
Can you let us know what reports you run exactly?
You just mentioned 'the report' and I wonder what that report was.
Would be great if you could provide some more details; not only on the report but also on the process how you reconciled the data.
Many thanks and best regards,
hi Ludwig , the report run thru the SSRS and BI report
Hello Sriram GS,
Many thanks for that update.
Can you let us know the report names also? ;-)
This would help a lot.
Some reports are not necessarily meant to match because they use different logic with regard to dates e.g transaction date vs posting date. Differences can arise in the reports with closed dates of transactions and the reports may not necessarily match for that reason e.g.
• Vendor Balance list records the balance as at a date.
• Vendor Ageing Report looks at what transactions are OPEN at a date.
Through open transaction editing (normally) the date principle determines the date the transaction is settled (closed) and this could be closed at a date prior to your balance date, and be settled against a payment past your balance date.
Therefore it would be excluded from the Ageing Report, but not the balance list.
Dynamics AX is date driven system rather than by period buckets, – when you set the date principle to the date on which you do the open transaction editing settlement (i.e. today's date), generally the results match. It is possible to get currency differences after exchange rate adjustment when the invoice stays open after financial closing and you are running a back dated report.
There have been some hotfixes for TB in the past- I don't know what version you have.
Voucher prefix, Transaction type and Posting type, help you identify mis-postings.
Ensure the 'Do not allow manual entry' checkbox is marked on the ledger account to avoid direct posting to the account. This setting requires that all transactions post through the subledger accounts.
Reports that can be used for reconciliation are:
•Bank to ledger reconciliation report
•Customer to ledger reconciliation report
•Potential conflicts – work in process and general ledger
•Inventory value report
•Potential conflicts – inventory and general ledger
•Vendor to ledger reconciliation report
•Sales tax/ledger reconciliation report
Dear Mr. Ludwig,
We are using AX2012 R3.
The main issue is the Value of GL vs Sub GL is not matching.
we could not find the root cause for the issue
We suspect , error in mapping the transaction with respect to the GL and Sub GL
Also the difference is accumulating over a period. hence we could not able to fix it
Could you please suggest some solution to proceed further.
To provide you some more detailed help we need more information about the different reports you used for making the reconciliation.
Can you provide us some screenprints and additional information how the reconciliation was made and the difference identified?
Ideally in a 'step-by-step' summary so that we can replicate the issue.
Did you run the Potential conflicts – work in process and general ledger?
In the Production control parameters, Ledger posting field what option is selected for the level of ledger posting for production processes.?
Reconciliation boils down to:
• Analyze the postings to the GL account(s) to find any postings that don’t belong.
• Analyze the postings in other GL account(s) to find stray postings that should’ve gone into the account you are reconciling.
Typically the key filters to use are journal prefix, and Posting types.
Have you been able to resolve the issue in the meantime?
Would be great if you could keep us updated.
Been working with it.
once done, sure will update
Thanks for the concern
Business Applications communities