ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Reverse the application of customer Credits
http://www.istechforum.com/YaBB.pl?num=1294166385

Message started by kevind on 01/04/11 at 11:39:44

Title: Reverse the application of customer Credits
Post by kevind on 01/04/11 at 11:39:44

I applied a customer credit to an invoice using AR-C.
I meant to apply only the merchandise total so that the invoice would still be open for the Freight.

Is there anyway to reverse this?

BTW: The credit I was trying to apply was actually a Deposit that printed on the Invoice, but when I posted,
It gave me that error message that says the invoice printed with a deposit, but the balance of the deposit was
zero or negative (it was not though).

So at this point, I have a printed invoice that correctly shows the merchandise deposit, with only freight remaining.
If I reprint the invoice, it prints an invoice with no deposit (because it complained about the deposit when I posted the invoice).
In the customer's A/R, the invoice is shown as completely paid. :'(

Title: Re: Reverse the application of customer Credits
Post by Lynn_Pantic on 01/04/11 at 18:34:20

If the deposit was only enough to cover the merchandise then how was it able to pay off the entire invoice?

Title: Re: Reverse the application of customer Credits
Post by kevind on 01/07/11 at 15:19:32

The deposit was a large deposit that prepaid 4 different invoices.

The first one I did correctly.

The second one, I applied the entire invoice balance instead of just the Merchandise.

Title: Re: Reverse the application of customer Credits
Post by Lynn_Pantic on 01/09/11 at 09:21:44

You will need to use Maintain Database and do the following:

BKARINVT, find the invoice. Change BKAR.INVT.AMTRM to the open balance (freight amount), zero out the Closed date (BKAR.INVT.CLOSD). Based on the transaction number (BKAR.INVT.TXN) find the payment record in BKART and change the amount to the correct amount. Also change the payment amount in BKARCHKF and the payment record in BKARINVT. Change the remaining balance in BKARDEP and make a Journal entry between AR and Customer Deposits.

Or, when the customer pays for the freight (which they will because they were sent the original invoice with the balance for freight.) enter that payment in AR-C and save as deposit and then go to AR-N and attach it to the last order that the original deposit was supposed to cover.