Reversing NSF Cheque

headley27

Good Day,

We are trying to reverse a transaction in NAV 5.0.

First we are Navigating to the Customer Ledger Entry (Payment) in question and then we are selecting Functions > Reverse Transaction.

On Form 179 (Reverse Entries) we then choose Reversing > Reverse and Print, accepting the confirmation message.

We are then presented with the error message 'You cannot reverse Cust. Ledger Entry No. xxxxxxx because the entry is either applied to an entry or has been changed by a batch job.'.

This error occurs in this function Table 179 (Reversal Entry):

CheckDtldCustLedgEntry(CustLedgEntry)
DtldCustLedgEntry.SETCURRENTKEY("Cust. Ledger Entry No.");
DtldCustLedgEntry.SETRANGE("Cust. Ledger Entry No.",CustLedgEntry."Entry No.");
IF DtldCustLedgEntry.FIND('-') THEN
  REPEAT
    IF (DtldCustLedgEntry."Entry Type" <> DtldCustLedgEntry."Entry Type"::"Initial Entry") AND
       (NOT DtldCustLedgEntry.Unapplied)
    THEN
      ERROR(
        Text000,CustLedgEntry.TABLECAPTION,CustLedgEntry."Entry No."); //< ERROR OCCURS HERE
  UNTIL DtldCustLedgEntry.NEXT = 0;

There are 3 Detailed Customer Entries, one is the Initial Entry and 2 are Application Entries. The error is presented during the second loop since the Detailed Customer Ledger Entry Type is Application and not Initial Entry.

So how do I reverse the NSF Payment?

Can anyone suggest what we may be doing wrong?

Thank you very much.

Alex_Chow

You have to unappy the entry first before reversing it.

headley27

Thanks Alex.

I looked at the code line (NOT DtldCustLedgEntry.Unapplied) and thought that might be the case.

Unapplying created 2 more Detailed Customer Ledger Entries and now the message I get is 'You cannot reverse Bank Account Ledger Entry No. xxxxxx because the entry is closed'.

It took awhile for us to get the NSF cheque back from the bank. Our accounting department reconciles the bank account weekly and I assume that this is what closes the entry.

Can anything be done?

This is all in a test database. We want to get it right before trying this in our production database.

Thanks again.

Alex_Chow

You're getting that error because the check has already been reconciled in the Bank Reconciliation.

If it's cleared by the bank, how can you reverse it?

headley27

The problem here is that the cheque went into 'bank limbo'.
Typically we are notified in 2 to 3 days, this took 2 to 3 weeks.

We have a workaround for this, a little painful, but it will work.

Thank you Alex for helping us answer a number of our questions.

Alex_Chow

Sure, no problem.