You’re offline. This is a read only version of the page.
5
Hi All,
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.
Thanks
Extremely helpful. Thanks Dirk.
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.
My apologies that I overlooked the case and thought it belongs to Dynamics.
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?
Thanks
Hi Sophie,
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.
#1
Sohail Ahmed
813
#2
YUN ZHU
771
Super User 2025 Season 1
#3
Mansi Soni
529
Share
Report
All responses (
Answers (
