Welcome, Guest. Please Login.
06/07/25 at 23:33:10
News:
Home Help Search Login


Pages: 1
Send Topic Print
Reverse the application of customer Credits (Read 760 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Reverse the application of customer Credits
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.   cry
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Reverse the application of customer Credits
Reply #1 - 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?
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Reverse the application of customer Credits
Reply #2 - 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.
 
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Reverse the application of customer Credits
Reply #3 - 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.  
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Pages: 1
Send Topic Print