Problem with unapplying Cust. Ledger Entries

res

Hello

I got a problem with unapplying Cust. Ledger Entries in Navision 4.0.

I applied two entries: Payment and Invoice. After that I tried to unapply these entries and got this error: Unapplied must be No in Detailed Cust Ledg. Entry Entry No.='94'.

Debugger stops in the codeunit 12, procedure UnapplyCustLedgEntry, inside the repeat loop at "DtldCustLedgEntry2.TESTFIELD(Unapplied,FALSE);". There is actually no entry where the Entry No.='94' in Detailed Cust Ledg. Entry table.

Also, noticed that no G/L Entries are created when I applied Cust. Ledg. Entries. Which made me think that maybe there's some conflict with Transaction No. because last value in G/L Entry table is smaller than last value in Detailed Cust Ledg. Entry table. But im not sure...

So, I'd like to know if I did something wrong myself or is it a bug in Navision. Has anyone else encountered this problem?

Thanks in advance

radianis

Hi Res,

As far as I know there are no problem with this unapply functionality. Perhaps you should explain how you process invoice and payment in navision.

If everything okay then..

From the error message, the detail cust ledger is already unapply. So the transaction is already unapply so please check your transaction if there is another unapply transaction.

Or you directly change the status in detailed cust ledger...

res

Thanks for your reply! I'll give a more detailed description how I get this error.

1. In "Receivables/Invoices" I post an invoice.

2. In "Receivables/Cash Recipient Journals" I post a payment where "Account Type"="Customer" and "Bal. Account Type"="Bank Account". "Applies-to Doc Type" and "Applies-to Doc No." remains empty.

3. On customer card, I click the little arrow in Balance field and apply the entries there.

4. Now, when I try to unapply them I get the error message.

radianis

Hi Res,

I think you are doing the wrong process. Step 1 and 3 is okay, but step 2 is wrong plus step 4. You need to do this :

Step 1 (OK). Post Invoice, let say invoice A amount USD100 (Your Receivables will increase)

Step 2. Post Payment In "Receivables/Cash Receipt Journals" where "Account Type"="Customer" and "Bal. Account Type"="Bank Account". "Applies-to Doc No." SHOULD BE invoice A (You must select this to decrease your receivables), let say USD80. So your Receivables is USD20.

Step 3. (OK) Then you think you make mistake, so you need to un-apply. On customer card, click the little arrow in Balance field and un-apply the entries there.

Step 4. Last step is, you need to reverse the journal entry. and finito.....

res

Hello

Just wanted to say, that the problem got solved!

Problem was that in "Apply Customer Entries" screen, if you set applying entry, you must set the Invoice, not the Payment. Maybe this affects only Estonian localisation, I'm not sure. Dumb thing here is, that either way you get this message: "The application was successfully posted", which is not really true when you set the Payment for the applying entry.

Cheers