Skip to main content

Fixing 'There is no Cust. Ledger Entry within the filter' when posting Sales Credit Memos and Invoices

If you have tried to post a sales credit memo or sales invoice and been stopped by the message below. It is one of the posting errors due to data issue on the document itself, not a system fault.

There is no Cust. Ledger Entry within the filter.
Filters: Customer No.: xxx, Document Type: Credit Memo / Invoice, Document No.: xxx, Open: Yes

What Business Central is actually telling you

When a sales document has Applies-to Doc. Type and Applies-to Doc. No. filled in, Business Central tries to apply the new entry against that existing customer ledger entry as part of posting. To do that, it searches Customer Ledger Entries using the filters shown in the error. If no entry matches every filter, posting stops.

So if you are posting a credit memo and the error says Document Type: Credit Memo, your credit memo is set to apply against another credit memo. That is almost always a sign the application fields are wrong.

Common causes

The target entry is already closed. The invoice was paid, or applied to another payment or credit memo, after the application was set on your document. This happens a lot when a credit memo is created with Copy Document from a posted invoice and then left for a while before posting.

Wrong number or wrong type. A typo in Applies-to Doc. No., or the type is set to Credit Memo when it should be Invoice (or the other way round).

Different customer. The entry exists, but under another customer, or the Bill-to Customer on the document was changed after the application was set.

A value written by an integration or import. If the Document No. in the error looks like {0974C466-D875-47CC-, that is not a document number at all. It is a system ID (GUID) cut off at 20 characters, the maximum length of the field. Something outside normal data entry, such as an API integration, a data import or an add-on extension, wrote it into Applies-to Doc. No. No ledger entry will ever match it.

How to fix it, step by step

  1. Read the filters in the error. Note the Document Type and Document No. These tell you exactly what Business Central was looking for.
  2. Open the document and find the application fields. Look for Applies-to Doc. Type and Applies-to Doc. No. in the document header. On some pages they are hidden until you choose Show more. If the document is Released and the fields cannot be edited, choose Reopen first.
  3. Check the target in Customer Ledger Entries. Filter on the customer and search for the Document No. Confirm that the entry exists, that its Document Type matches, and that it is still Open with a Remaining Amount.
  4. Correct the application.
    • If the right entry exists and is open, clear both Applies-to fields, then use Apply Entries (Shift+F11) on the document to select the correct entry.
    • If the target entry is already closed, clear both fields and post without an application. The credit memo stays open on the customer's account, and you can apply it later to another invoice or refund it.
    • Release and post again.

Preventing it next time

After using Copy Document to create a credit memo, check the Applies-to fields before posting, especially if a few days have passed and the invoice may have been paid in the meantime.

If you are unsure what to apply to, leave the application blank. Posting does not require one, and you can apply the entries afterwards from Customer Ledger Entries.

Still stuck? Take a screenshot of the error and the document header showing the Applies-to fields, and send it to your support contact. Those two pieces are usually enough to pinpoint the problem quickly.

Location: Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

Comments

Post a Comment

Popular posts from this blog

Start Here

Something in Business Central not behaving? Work down this page. Most things are answered here already — and if they aren't, the last section tells you exactly what to send me so we can skip three rounds of questions. The sixty-second checks These four clear most of what reaches me. Try them before anything else. Hard refresh the page. Hold Ctrl and press F5. A normal refresh reloads the cached copy; this one doesn't. Check which company you are in. The name is at the top of the screen. Posting into the wrong entity is easier than it sounds. Open it in a private window. If it works there, the problem is cache or a browser extension, not Business Central. Try a different browser. If Edge fails and Chrome works, that alone narrows it down enormously. Part 1 — Something on screen isn't working A page won't load, a button does nothing, something has gone missing, or an error stops you posting. Start here if Business Central itself is misbehaving. A...
Post a Comment
Read more

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...
Post a Comment
Read more

Exchange Rate Adjustment in Dynamics 365 Business Central: Unrealized Forex Gain/Loss

Overview Business Central's Exchange Rate Adjustment revalues your open foreign-currency documents and bank balances at month-end and posts the unrealized foreign exchange gain or loss for you. You enter the month-end rate once, run one batch job, and BC handles every customer, vendor and bank account in that currency. Why it matters: under MFRS 121, foreign-currency monetary items such as receivables, payables and bank balances must be translated at the closing rate at each reporting date. The difference from the amount originally booked is an unrealized gain or loss that belongs in that period's P&L. Which version are you on? In newer versions of BC the batch job is called Exch. Rate Adjustment and includes Preview Posting, Adjust per entry and the Exch. Rate Adjmt. Ledger Entries page. Older versions use the Adjust Exchange Rates report, which works the same way but without those options. Search for "exchange rate" in Tell Me to see which one your co...
Post a Comment
Read more