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...
Answered

Apply Customer Entries historically? - "You cannot apply and post an entry to an entry with an earlier posting date"

(0) ShareShare
ReportReport
Posted on by 470

So when applying customer entries sometimes the payment is taken into the bank before the goods are shipped (i.e. someone orders late afternoon and item is shipped/invoiced the following day)

So the posting date when we receive the money into the bank is in the past but the Invoice date is in the future - however the "apply customer entries" doesn't seem to be able to handle that?

2860.jpg

Anyone having the same issues?

I have the same question (0)
  • Mohamed El Ghazaly Profile Picture
    132 on at

    You can post invoice without apply then apply from customer ledger entry 

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,306 Super User 2026 Season 1 on at

    You can only apply to past transaction when you are using journal. However, this restriction is not applied when you do it from Customer Ledger Entry.

    So, post the journal without applying, go to Customer Ledger Entry and use Application Worksheet to apply.

  • Verified answer
    Dirk Profile Picture
    Microsoft Employee on at

    Hi,

    Regards the “Posting Date” of a payment / applying entry being before the Posting Date of the invoice / entry to be applied …
    This has been blocked on purpose to avoid differences between the General Ledger /Receivables Account / Payables Account) and the Sub Ledger (Customer or Vendor).

    If you apply afterwards from the Entry pages (instead of the journal), the Date at which the application will be posted is always the later date, never the earleir date of the (pre)payment.

    Without the block the following can happen.

    You have a currency invoice.
    You have a payment date in December and an invoice in January … each with different currency exchange rates.
    With the application of the invoice by the payment you post the realized gain or loss (reflected on G/L Accounts and in Detailed Customer/Vendor Ledger Entries).
    Problem is that in this situation you will most probably have G/L Entries with the Posting Date of the Payment (in December) and corresponding Detailed Customer/Vendor Ledger Entries with the Posting Date of the Invoice (January) … still all with the same Transaction No..

    If you now run the Trial Balance / Balance to Date report in G/L and in Customer Ledger / Vendor Ledger with the Ending Date = 31.12.x you do not get the same total amount.
    This is not good and will most probably show up in fiscal year ending activities and external audits.
    And the way to “solve” this was to block the direct application with the “earlier” Posting Date.

    Of course you can change the code / remove the check / work around it individually … but that will most probably take you back into the outlined situations with the “differences” in G/L and Subledger.

    Another example, maybe not applicable for all countries, but for UK and mainly for AT, CH, DE (and No) is the use “Adjust VAT for Paym. Disc." feature.
    In this case on posting the payment with payment discount a VAT correction for the applied invoice is posted.
    Here the VAT posting in G/L would again go with the Payment Date but the Posting Date of the VAT Entry would go with the Invoice Date … that is also bad … it is actually worse that the temp. differences in G/L and Subledger.

    That’s why there is this blocking code ... on purpose.

    Hope this clarifies the background for this check,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April 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,012 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 986 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 659 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans