Check out the latest Business Central updates!Learn about the key capabilities and features of Dynamics 365 Business Central and experience some of the new features.
Download overview guide | Watch Business Central video
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 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 | Upcoming TechTalks
Please could someone advise how to find transactions that have been directly posted to the G/L control account instead of via the Vendor or Customer Ledger Account.
The problem seems to have stemmed from the migration process as it seems after the migration of data the Direct Posting to both control accounts was not switched off.
As I understand the issue here, seems direct postings done to the summary accounts of vendor and customer after migration since 'do not allow manual entry' for these accounts is not marked. To find the transactions that got posted, in D365 F&O (since you have not mentioned the version, assuming you are using D365 F&O), you need to run the Trail balance for specified time period having financial dimension set as 'Main account'. It will retrieve the ledger accounts that got posted in the given time period. There you can find the summary accounts of vendor / customer as well. Need to click on 'Transactions' to check the required information. In AX2012, posted transactions can be seen from ledger accounts itself.
Hope this helps you.
Note: This post is my own opinion and does not necessarily reflect the opinion of my company.
Hi - thank you for your reply, we are using Dynamics 365 Business Central.
I think that may be different to F&O? I cannot see a filter on the trail balance report for financial dimension & main account. I also cannot see 'transactions' to click on to?
My apologies that I overlooked the case and thought it belongs to Dynamics.
In General Ledger Entries there is a field called "System-Created".
If you used the G/L account directly then this field (which is not shown by default) is set to false.
If it is used indirectly, through a customer/vendor ..., then it shoudl be set to true.
Next indicator could be the "Source Type" & "Source No.".
These fields shoul not be filled if you created the G/L Entry directly.
Business Applications communities