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 / Small and medium business | Business Central, N... / How to find Direct Pos...
Small and medium business | Business Central, N...
Suggested Answer

How to find Direct Posting in the Customer & Vendor G/L Control Accounts

(0) ShareShare
ReportReport
Posted on by Sophie Stephenson 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 

Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    SREEPRIYA KOLAGANI Profile Picture
    SREEPRIYA KOLAGANI Microsoft Employee on at

    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.

  • Sophie Stephenson Profile Picture
    Sophie Stephenson 5 on at

    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

  • SREEPRIYA KOLAGANI Profile Picture
    SREEPRIYA KOLAGANI Microsoft Employee on at

    My apologies that I overlooked the case and thought it belongs to Dynamics.

  • Dirk Profile Picture
    Dirk Microsoft Employee on at

    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.

  • Bilal Haider Profile Picture
    Bilal Haider 485 on at

    Extremely helpful. Thanks Dirk.

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 June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 707 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 481 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans