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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Possibility of enter customer ledger entry for Customer and Receivable account.

(0) ShareShare
ReportReport
Posted on by 10

Is it possible to enter customer ledger entry for a customer and Receivable account? 

Example.

There is a customer =

Customer Number: C00001

Customer Name: Customer A  

Customer posting group balancing receivable account of the above customer is "Trade Debtors - Local"

Account No: 221010

Account Name: Trade Debtors - Local

But there is a customer ledger entry like that. 

Posting Date Document No. G/L Account No. G/L Account Name Description  Debit Amount   Credit Amount  Bal. Account Type Bal. Account No.
22-Jan-19 CUSTOB-1 221010 Trade Debtors - Local Customer A                   1,000.00                                   -   G/L Account 221010
22-Jan-19 CUSTOB-1 221010 Trade Debtors - Local Customer A                                -                        1,000.00 Customer C00001

I felt that this is something erroneous accounting practice. Because this kind of transaction will not affect the balance of the "221010 Trade Debtors - Local" account since there is a link between Customer A & Trade debtors Local account (Customer posting group receivable account). 

I need your kind expert knowledge on this. Thank You

  • LuHao Profile Picture
    40,892 on at

    Hi partner,

    Which app are you using?

  • Nilanga Profile Picture
    10 on at

    Hi,

    I'm using Dynamics 365 Business central online version.

    Thanks.

  • Dirk Profile Picture
    Microsoft Employee on at

    Hi,

    What do you want to achieve?

    Do you want to take over historical data from an old system?

    If so …

    If you registered an invoice in the old system you have accurate values in the sales account (income statement) and the receivables account (balance, 221010 in your case) in GL and you have the corresponding customer ledger entry in the subledger (for customer C00001), right?

    If you then want to take over data into BC now and you have registered the values in GL (including 221010), but not in the subledger yet … then the transaction you mentioned here is correct because you would want the customer ledger entry to be created for C00001 and at the same time you want the values / the balances on the GL accounts (221010 in your case) to remain unchanged.

    After taking over old data this way … make sure you set “Direct Posting” to false on the G/L Accounts you use in the customer and vendor posting groups (actually, it would be good to set “Direct Posting” to false in all G/L Accounts which are used in Posting Groups / Posting Setup)

  • Nilanga Profile Picture
    10 on at

    Dear Dirk Reeps,

    Thank you for your answer.  

    I have another question regarding Dynamic 365 Business central.

    Need your kind expert knowledge on this.

    community.dynamics.com/.../does-dynamic-nav-records-failure-longing-attempts-in-the-log-report

    Thank You

    Nilanga

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 645 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 432 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 248 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans