Dynamics F/SCM
Dynamics F/SCM
Organizer:
- JOSE Organized by
-
-
Accounting Source Explorer error in D365 F&O
-
Accounting Source Explorer error in D365 F&O
Error: “Cannot insert multiple records in Source document accounting event reference identity (SourceDocumentAcctEventReferenceIdentity). Accounting event: 0, 0. A time-out occurred in the database while the query was executing.”
When i Go to Modules –> General ledger –> Inquiries and reports –> Accounting Source Explorer Click on the Drop-down of Financial Dimension Set and Select ‘All’ or any set from the list
In D365F&O -
1 Reply
-
This usually points to a data volume / query timeout issue in Accounting Source Explorer, especially when selecting āAllā financial dimension sets.
A few things to check:
Try filtering instead of selecting All. The query becomes very heavy with large datasets
Check if thereās data inconsistency or duplicate references in SourceDocumentAcctEventReferenceIdentity
Review batch jobs / cleanup jobs. Sometimes old accounting event data causes issues
Make sure your environment isnāt hitting SQL timeout limits (common in large production DBs)
If it started recently, check for customizations or recent data imports
If it persists, running a database consistency check and reviewing telemetry in LCS can help identify the exact query causing the timeout
In most cases, itās not a functional issue. Itās performance + data volume combined with that āAllā selection
Log in to reply.
