web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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 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 on at

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

  • Dirk Profile Picture
    Dirk 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 414 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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,066

#2
YUN ZHU Profile Picture

YUN ZHU 658 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 595

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans