Reverse an Invoice Payment

Yahoo Archive
1
We set up a product group that hits cash to handle returned checks. If a customer's check is returned, we create a misc invoice using that product group. The invoice credits cash, which balances our gl and shows up on the customer's ar file, so we don't lose track of it.

Christy J. Morris
Controller
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA

+1 513-716-6370
+1 513-576-8986 (fax)
www.coldjet.com<http://www.coldjet.com>

[cid:image001.jpg@01CAF8D0.310704B0]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of plamen21
Sent: Thursday, May 20, 2010 4:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reverse an Invoice Payment



Just curious, how do you post an invoice to cash?
our system does not allow us to specify GL on the Invoice.

I think they are going to
1. create a misc invoice in plase of the one that got paid
2. create a cash receipt for the amount that was applied incorrectly, and put it on a deposit to the account that was supposed to get it.
3. make a journal entry to move the same amount from the GL that the misc invoice hit to cash.

At least this is my non-accounting interpretation of the ordeal.

Plamen

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Christy Morris <cmorris@...> wrote:
>
> We follow the steps below, with a couple of changes. The new invoice is posted to cash, with ample comments to understand what happened. We then create a cash receipt for the correct customer, which allows for a proper paper trail. The credit to cash from the new invoice offsets the debit to cash from the cash receipt, so the gl is correct.
>
> Christy J. Morris
> Controller
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
>
> +1 513-716-6370
> +1 513-576-8986 (fax)
> www.coldjet.com<http://www.coldjet.com>
>
> [cid:image001.jpg@...]
> Setting industry standards in dry ice technology and solutions for over 20 years.
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Virginia
> Sent: Friday, May 07, 2010 11:32 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Reverse an Invoice Payment
>
>
>
> Unfortunately, you cannot reverse cash receipts.
>
> I would create a new invoice for the customer who actually still owes money (it will have to be a different invoice number than the one that was erroneously paid). For it to correctly show on your G/L and your aging, be sure that the fiscal period of the invoice group is the current fiscal period, however, the date on the invoice needs to be the date of the origianl invoice. Note which G/L accout is used.
>
> I would then use an AR Adjustment to reduce to $0.00 the value of the invoice that should have been paid. Enter information in the adjustment screen so that you have it documented that this truly isn't an adjustment but the adjustment is being made to account for an incorrectly applied payment. The adjustment will require a G/L account. Use the G/L account used when the new invoice was created so that the net effect on your G/L will be $0.00.
>
> I believe that the functionality to reverse cash payments is finally available in E9.
>
> Virginia Joseph
> Deep Hole Specialists, LLC
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, "plamen21" <plamen21@> wrote:
> >
> > Vantage 803.407c:
> >
> > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> >
> > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Plamen
> > Systems Administrator
> > Art Display Co.
> >
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
2
Vantage 803.407c:

A payment was applied to the wrong customer invoice, resulting in paying the invoice off.

I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.

Any ideas?

Thanks,

Plamen
Systems Administrator
Art Display Co.
3
You can't bring back the originals. You will need to create a Miscellaneous Invoice - do not use Debit Memo (it does not do what you may think it does). You could use their Original PO to "link" the documents together. You will then need to create an AR Credit Memo and apply that to the correct Invoice. I am guessing this happened within the same customer, otherwise your work doubles.  I would suggest using the Internal Memo or adding Comments depending on if you want this verbiage to appear on the customer document explaining the purpose of each and referring them to each other - this will help during audit time, because you just know they will pull these in their sample. I would normally not send either of these new documents to the customer(s).
 Sincerely,


Stephen

[Non-text portions of this message have been removed]
4
Hi Plamen,

Officially you can't bring back the originals - as Stephen says.

However you can "cheat". We do the following for bounced customer cheques:

We use SQL commands to change the InvcHead.OpenInvoice field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.

Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.

We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.


If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.


HTH,
Nigel.

--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> Vantage 803.407c:
>
> A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
>
> I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
>
> Any ideas?
>
> Thanks,
>
> Plamen
> Systems Administrator
> Art Display Co.
>
5
I should have included this info in the original question:
We are using a Progress database, not SQL.
There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]

Plamen


--- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@...> wrote:
>
> Hi Plamen,
>
> Officially you can't bring back the originals - as Stephen says.
>
> However you can "cheat". We do the following for bounced customer cheques:
>
> We use SQL commands to change the InvcHead.OpenInvoice field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
>
> Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
>
> We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
>
>
> If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
>
>
> HTH,
> Nigel.
>
> --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> >
> > Vantage 803.407c:
> >
> > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> >
> > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Plamen
> > Systems Administrator
> > Art Display Co.
> >
>
6
Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.Â



________________________________
From: plamen21 <plamen21@...>
To: vantage@yahoogroups.com
Sent: Fri, May 7, 2010 9:17:37 AM
Subject: [Vantage] Re: Reverse an Invoice Payment

Â
I should have included this info in the original question:
We are using a Progress database, not SQL.
There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]

Plamen

--- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
>
> Hi Plamen,
>
> Officially you can't bring back the originals - as Stephen says.
>
> However you can "cheat". We do the following for bounced customer cheques:
>
> We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
>
> Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
>
> We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
>
>
> If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
>
>
> HTH,
> Nigel.
>
> --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> >
> > Vantage 803.407c:
> >
> > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> >
> > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Plamen
> > Systems Administrator
> > Art Display Co.
> >
>







[Non-text portions of this message have been removed]
7
Unfortunately, you cannot reverse cash receipts.

I would create a new invoice for the customer who actually still owes money (it will have to be a different invoice number than the one that was erroneously paid). For it to correctly show on your G/L and your aging, be sure that the fiscal period of the invoice group is the current fiscal period, however, the date on the invoice needs to be the date of the origianl invoice. Note which G/L accout is used.

I would then use an AR Adjustment to reduce to $0.00 the value of the invoice that should have been paid. Enter information in the adjustment screen so that you have it documented that this truly isn't an adjustment but the adjustment is being made to account for an incorrectly applied payment. The adjustment will require a G/L account. Use the G/L account used when the new invoice was created so that the net effect on your G/L will be $0.00.

I believe that the functionality to reverse cash payments is finally available in E9.

Virginia Joseph
Deep Hole Specialists, LLC



--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> Vantage 803.407c:
>
> A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
>
> I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
>
> Any ideas?
>
> Thanks,
>
> Plamen
> Systems Administrator
> Art Display Co.
>
8
We follow the steps below, with a couple of changes. The new invoice is posted to cash, with ample comments to understand what happened. We then create a cash receipt for the correct customer, which allows for a proper paper trail. The credit to cash from the new invoice offsets the debit to cash from the cash receipt, so the gl is correct.

Christy J. Morris
Controller
Cold Jet, LLC
455 Wards Corner Road
Loveland, Ohio 45140
USA

+1 513-716-6370
+1 513-576-8986 (fax)
www.coldjet.com<http://www.coldjet.com>

[cid:image001.jpg@01CAEDDC.3DC020F0]
Setting industry standards in dry ice technology and solutions for over 20 years.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Virginia
Sent: Friday, May 07, 2010 11:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reverse an Invoice Payment



Unfortunately, you cannot reverse cash receipts.

I would create a new invoice for the customer who actually still owes money (it will have to be a different invoice number than the one that was erroneously paid). For it to correctly show on your G/L and your aging, be sure that the fiscal period of the invoice group is the current fiscal period, however, the date on the invoice needs to be the date of the origianl invoice. Note which G/L accout is used.

I would then use an AR Adjustment to reduce to $0.00 the value of the invoice that should have been paid. Enter information in the adjustment screen so that you have it documented that this truly isn't an adjustment but the adjustment is being made to account for an incorrectly applied payment. The adjustment will require a G/L account. Use the G/L account used when the new invoice was created so that the net effect on your G/L will be $0.00.

I believe that the functionality to reverse cash payments is finally available in E9.

Virginia Joseph
Deep Hole Specialists, LLC

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "plamen21" <plamen21@...> wrote:
>
> Vantage 803.407c:
>
> A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
>
> I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
>
> Any ideas?
>
> Thanks,
>
> Plamen
> Systems Administrator
> Art Display Co.
>



[Non-text portions of this message have been removed]
9
And the original Invoice numbers still appear on the Statements and the Aging is all still correct. So both the customer and your own Credit Controller should be happy.


--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.ÂÂ
>
>
>
> ________________________________
> From: plamen21 <plamen21@...>
> To: vantage@yahoogroups.com
> Sent: Fri, May 7, 2010 9:17:37 AM
> Subject: [Vantage] Re: Reverse an Invoice Payment
>
> ÂÂ
> I should have included this info in the original question:
> We are using a Progress database, not SQL.
> There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]
>
> Plamen
>
> --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> >
> > Hi Plamen,
> >
> > Officially you can't bring back the originals - as Stephen says.
> >
> > However you can "cheat". We do the following for bounced customer cheques:
> >
> > We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> >
> > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> >
> > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> >
> >
> > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> >
> >
> > HTH,
> > Nigel.
> >
> > --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> > >
> > > Vantage 803.407c:
> > >
> > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > >
> > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Plamen
> > > Systems Administrator
> > > Art Display Co.
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
10
How would this ODBC or 4 GL programming work. Is this something that is run through Vantage? Any suggestions how it is done, or resources to learn ODBC or 4GL programming for the purpose of reopening a certain record in a progress database.

Thanks,

Plamen

--- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@...> wrote:
>
> And the original Invoice numbers still appear on the Statements and the Aging is all still correct. So both the customer and your own Credit Controller should be happy.
>
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.ÂÂ
> >
> >
> >
> > ________________________________
> > From: plamen21 <plamen21@>
> > To: vantage@yahoogroups.com
> > Sent: Fri, May 7, 2010 9:17:37 AM
> > Subject: [Vantage] Re: Reverse an Invoice Payment
> >
> > ÂÂ
> > I should have included this info in the original question:
> > We are using a Progress database, not SQL.
> > There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]
> >
> > Plamen
> >
> > --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> > >
> > > Hi Plamen,
> > >
> > > Officially you can't bring back the originals - as Stephen says.
> > >
> > > However you can "cheat". We do the following for bounced customer cheques:
> > >
> > > We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> > >
> > > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> > >
> > > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> > >
> > >
> > > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> > >
> > >
> > > HTH,
> > > Nigel.
> > >
> > > --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> > > >
> > > > Vantage 803.407c:
> > > >
> > > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > > >
> > > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks,
> > > >
> > > > Plamen
> > > > Systems Administrator
> > > > Art Display Co.
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
11
It sounds like ODBC may be your best bet. Ask Epicor support to send you the ODBC kit. It contains instructions on how to install the Progress ODBC driver. After it is installed, you can use Access, Excel, or any other program that can utilize ODBC to change the open flag on the invoice header.




________________________________
From: plamen21 <plamen21@...>
To: vantage@yahoogroups.com
Sent: Mon, May 10, 2010 3:41:03 PM
Subject: [Vantage] Re: Reverse an Invoice Payment

Â
How would this ODBC or 4 GL programming work. Is this something that is run through Vantage? Any suggestions how it is done, or resources to learn ODBC or 4GL programming for the purpose of reopening a certain record in a progress database.

Thanks,

Plamen

--- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
>
> And the original Invoice numbers still appear on the Statements and the Aging is all still correct. So both the customer and your own Credit Controller should be happy.
>
>
> --- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ > wrote:
> >
> > Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.ÂÂ
> >
> >
> >
> > ____________ _________ _________ __
> > From: plamen21 <plamen21@>
> > To: vantage@yahoogroups .com
> > Sent: Fri, May 7, 2010 9:17:37 AM
> > Subject: [Vantage] Re: Reverse an Invoice Payment
> >
> > ÂÂ
> > I should have included this info in the original question:
> > We are using a Progress database, not SQL.
> > There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]
> >
> > Plamen
> >
> > --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> > >
> > > Hi Plamen,
> > >
> > > Officially you can't bring back the originals - as Stephen says.
> > >
> > > However you can "cheat". We do the following for bounced customer cheques:
> > >
> > > We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> > >
> > > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> > >
> > > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> > >
> > >
> > > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> > >
> > >
> > > HTH,
> > > Nigel.
> > >
> > > --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> > > >
> > > > Vantage 803.407c:
> > > >
> > > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > > >
> > > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks,
> > > >
> > > > Plamen
> > > > Systems Administrator
> > > > Art Display Co.
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>







[Non-text portions of this message have been removed]
12
Good news. I found an old doc from Admin Training on how to set up ODBC Progress driver on a workstation. It works I just didi a Test Connect.

Now The only question remaining is how to change InvcHead.OpenInvoice
to True using this ODBC driver.

Any tips?

Plamen


--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> It sounds like ODBC may be your best bet. Ask Epicor support to send you the ODBC kit. It contains instructions on how to install the Progress ODBC driver. After it is installed, you can use Access, Excel, or any other program that can utilize ODBC to change the open flag on the invoice header.
>
>
>
>
> ________________________________
> From: plamen21 <plamen21@...>
> To: vantage@yahoogroups.com
> Sent: Mon, May 10, 2010 3:41:03 PM
> Subject: [Vantage] Re: Reverse an Invoice Payment
>
> ÂÂ
> How would this ODBC or 4 GL programming work. Is this something that is run through Vantage? Any suggestions how it is done, or resources to learn ODBC or 4GL programming for the purpose of reopening a certain record in a progress database.
>
> Thanks,
>
> Plamen
>
> --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> >
> > And the original Invoice numbers still appear on the Statements and the Aging is all still correct. So both the customer and your own Credit Controller should be happy.
> >
> >
> > --- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ > wrote:
> > >
> > > Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.ÂÂÂ
> > >
> > >
> > >
> > > ____________ _________ _________ __
> > > From: plamen21 <plamen21@>
> > > To: vantage@yahoogroups .com
> > > Sent: Fri, May 7, 2010 9:17:37 AM
> > > Subject: [Vantage] Re: Reverse an Invoice Payment
> > >
> > > ÂÂÂ
> > > I should have included this info in the original question:
> > > We are using a Progress database, not SQL.
> > > There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]
> > >
> > > Plamen
> > >
> > > --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> > > >
> > > > Hi Plamen,
> > > >
> > > > Officially you can't bring back the originals - as Stephen says.
> > > >
> > > > However you can "cheat". We do the following for bounced customer cheques:
> > > >
> > > > We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> > > >
> > > > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> > > >
> > > > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> > > >
> > > >
> > > > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> > > >
> > > >
> > > > HTH,
> > > > Nigel.
> > > >
> > > > --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> > > > >
> > > > > Vantage 803.407c:
> > > > >
> > > > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > > > >
> > > > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Plamen
> > > > > Systems Administrator
> > > > > Art Display Co.
> > > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
13
Nigel,
What are these SQL Commands, and do you send them?
I already got the ODBC driver set up and the appserver is set up for SQL client.
Also it turns out that we don't have two invoices, but rather a payment that was supposed to be a deposit for a job we are starting to build for one client, and an invoice that accidentaly got paid off for another client (plus a little bit in an Overpayment account, but that part we know how to move around). I don't know if this changes anything in the solution accounting-wise.

Plamen


--- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@...> wrote:
>
> Hi Plamen,
>
> Officially you can't bring back the originals - as Stephen says.
>
> However you can "cheat". We do the following for bounced customer cheques:
>
> We use SQL commands to change the InvcHead.OpenInvoice field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
>
> Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
>
> We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
>
>
> If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
>
>
> HTH,
> Nigel.
>
> --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> >
> > Vantage 803.407c:
> >
> > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> >
> > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Plamen
> > Systems Administrator
> > Art Display Co.
> >
>
14
Ok. Got connected using the SQL_Connect.bat as described in the V803400_Instructions.rtf
When I try to do a SELECT query and hit Enter I only get
1>
prompt
Then
2> , etc.
Another Enter gives me a
SQLExplorer>
prompt.
How do you make it actually execute the queries, and what are these 1>, 2>, 3> prompts?
What am I missing?
Once I get it going I am guessing I need to run something like:

UPDATE InvcHead SET OpenInvoice = True [meaning 'assign' not sure what is the correct assignment operator yet]
WHERE InvcHead.InvoiceNum = 53064 [equals]

Does this look anywhere close to right?

Plamen

--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> Good news. I found an old doc from Admin Training on how to set up ODBC Progress driver on a workstation. It works I just didi a Test Connect.
>
> Now The only question remaining is how to change InvcHead.OpenInvoice
> to True using this ODBC driver.
>
> Any tips?
>
> Plamen
>
>
> --- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@> wrote:
> >
> > It sounds like ODBC may be your best bet. Ask Epicor support to send you the ODBC kit. It contains instructions on how to install the Progress ODBC driver. After it is installed, you can use Access, Excel, or any other program that can utilize ODBC to change the open flag on the invoice header.
> >
> >
> >
> >
> > ________________________________
> > From: plamen21 <plamen21@>
> > To: vantage@yahoogroups.com
> > Sent: Mon, May 10, 2010 3:41:03 PM
> > Subject: [Vantage] Re: Reverse an Invoice Payment
> >
> > ÂÂ
> > How would this ODBC or 4 GL programming work. Is this something that is run through Vantage? Any suggestions how it is done, or resources to learn ODBC or 4GL programming for the purpose of reopening a certain record in a progress database.
> >
> > Thanks,
> >
> > Plamen
> >
> > --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> > >
> > > And the original Invoice numbers still appear on the Statements and the Aging is all still correct. So both the customer and your own Credit Controller should be happy.
> > >
> > >
> > > --- In vantage@yahoogroups .com, Steven Gotschall <sgotschall@ > wrote:
> > > >
> > > > Nigel's suggestion should still work on Progress. You would have to open the Invoice(s) through ODBC or 4GL programming. If I follow this process correctly, the end result should be that the wrong invoice is open and has a balance due and the payment can now be applied to the right invoice.ÂÂÂ
> > > >
> > > >
> > > >
> > > > ____________ _________ _________ __
> > > > From: plamen21 <plamen21@>
> > > > To: vantage@yahoogroups .com
> > > > Sent: Fri, May 7, 2010 9:17:37 AM
> > > > Subject: [Vantage] Re: Reverse an Invoice Payment
> > > >
> > > > ÂÂÂ
> > > > I should have included this info in the original question:
> > > > We are using a Progress database, not SQL.
> > > > There are two customers involved [I will call the one that got invoiced and wasn't supposed to Wrong Customer, and the one that was supposed to get invoiced but didn't - Right Customer]
> > > >
> > > > Plamen
> > > >
> > > > --- In vantage@yahoogroups .com, "NigelK" <nigel.kerley@ ...> wrote:
> > > > >
> > > > > Hi Plamen,
> > > > >
> > > > > Officially you can't bring back the originals - as Stephen says.
> > > > >
> > > > > However you can "cheat". We do the following for bounced customer cheques:
> > > > >
> > > > > We use SQL commands to change the InvcHead.OpenInvoic e field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> > > > >
> > > > > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> > > > >
> > > > > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> > > > >
> > > > >
> > > > > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> > > > >
> > > > >
> > > > > HTH,
> > > > > Nigel.
> > > > >
> > > > > --- In vantage@yahoogroups .com, "plamen21" <plamen21@> wrote:
> > > > > >
> > > > > > Vantage 803.407c:
> > > > > >
> > > > > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > > > > >
> > > > > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > > > > >
> > > > > > Any ideas?
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Plamen
> > > > > > Systems Administrator
> > > > > > Art Display Co.
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
15
Hi Plamen,

Sorry for the delay replying - I've been out of the office for a few days.

First a word of caution: sending SQL commands to the database can be *extremely dangerous*!!!

If you get the "where" clause wrong on your command, you could seriously damage the data in your database. Also, you are bypassing Vantage completely and so no error-checking or integrity-checking is carried out.

There isn't really any "undo" command. You may be able to "rollback" the command, but that may not be of much use if you don't spot your error immediately.

For these reasons, I normally run a "select/where" statement to see what rows are returned before updating. That way I can make sure I have the correct filter set.


Anyway...

To run your commands you can use the OpenEdge tools - there's some details with the ODBC Kit - but there's no SQL GUI any more so I don't find them of much use.

I believe you can also use Access or even MS-SQL Server Management Tool. A number of people in this group have recommended SQuirreL - it's a free SQL tool. I use a similar SQL tool that came with a development package I have.

The commands you're looking for would be:

First run the select command to make sure you have the correct invoice - and are only selecting ONE invoice:
"select invoicenum, custid, openinvoice from pub.invchead where company=XXX and invoicenum=###"

Then to update it:
"update pub.invchead set openinvoice=true where company=XXX and invoicenum=###"

I'd advise you copy your live DB over to your test system and run them on that first...just to be sure everything works as intended!

HTH,
Nigel.

--- In vantage@yahoogroups.com, "plamen21" <plamen21@...> wrote:
>
> Nigel,
> What are these SQL Commands, and do you send them?
> I already got the ODBC driver set up and the appserver is set up for SQL client.
> Also it turns out that we don't have two invoices, but rather a payment that was supposed to be a deposit for a job we are starting to build for one client, and an invoice that accidentaly got paid off for another client (plus a little bit in an Overpayment account, but that part we know how to move around). I don't know if this changes anything in the solution accounting-wise.
>
> Plamen
>
>
> --- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@> wrote:
> >
> > Hi Plamen,
> >
> > Officially you can't bring back the originals - as Stephen says.
> >
> > However you can "cheat". We do the following for bounced customer cheques:
> >
> > We use SQL commands to change the InvcHead.OpenInvoice field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> >
> > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> >
> > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> >
> >
> > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> >
> >
> > HTH,
> > Nigel.
> >
> > --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> > >
> > > Vantage 803.407c:
> > >
> > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > >
> > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Plamen
> > > Systems Administrator
> > > Art Display Co.
> > >
> >
>
16
Thank you very much. I have a copy of a backup that I am trying it on on the test server. Are the appservers supposed to be stopped and everyone out, in order for me to write to the db [Update]?
I am still having trouble with the SQL Explorer not showing the result of my SELECT statements [I don't care that it is text based]
This is what I get:

'\\tactile\epicor\v803'
CMD.EXE was started with the above path as the current directory.
UNC paths are not supported. Defaulting to Windows directory.

C:\WINDOWS>set dlc=d:\epicor\oe101b

C:\WINDOWS>d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprog
ress -password sysprogress
OpenEdge Release 10.1B0309 as of Wed Feb 13 16:39:20 EST 2008
Connecting user "sysprogress" to URL "jdbc:datadirect:openedge://localhost:8350;
databaseName=mfgsys"... (8920)
SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
ny=ADC and invoicenum=53064
1> commit //no result but a 1> prompt, so I try 'commit'
2> exec //still nothing
3> //Enter key on a new line, but still no result
SQLExplorer>
SQLExplorer>
SQLExplorer>
SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
ny=ADC and invoicenum=53064
4>
SQLExplorer>

If I can't figure it out I will try the SQuirreL or something else.

Thanks,
Plamen

--- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@...> wrote:
>
> Hi Plamen,
>
> Sorry for the delay replying - I've been out of the office for a few days.
>
> First a word of caution: sending SQL commands to the database can be *extremely dangerous*!!!
>
> If you get the "where" clause wrong on your command, you could seriously damage the data in your database. Also, you are bypassing Vantage completely and so no error-checking or integrity-checking is carried out.
>
> There isn't really any "undo" command. You may be able to "rollback" the command, but that may not be of much use if you don't spot your error immediately.
>
> For these reasons, I normally run a "select/where" statement to see what rows are returned before updating. That way I can make sure I have the correct filter set.
>
>
> Anyway...
>
> To run your commands you can use the OpenEdge tools - there's some details with the ODBC Kit - but there's no SQL GUI any more so I don't find them of much use.
>
> I believe you can also use Access or even MS-SQL Server Management Tool. A number of people in this group have recommended SQuirreL - it's a free SQL tool. I use a similar SQL tool that came with a development package I have.
>
> The commands you're looking for would be:
>
> First run the select command to make sure you have the correct invoice - and are only selecting ONE invoice:
> "select invoicenum, custid, openinvoice from pub.invchead where company=XXX and invoicenum=###"
>
> Then to update it:
> "update pub.invchead set openinvoice=true where company=XXX and invoicenum=###"
>
> I'd advise you copy your live DB over to your test system and run them on that first...just to be sure everything works as intended!
>
> HTH,
> Nigel.
>
> --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> >
> > Nigel,
> > What are these SQL Commands, and do you send them?
> > I already got the ODBC driver set up and the appserver is set up for SQL client.
> > Also it turns out that we don't have two invoices, but rather a payment that was supposed to be a deposit for a job we are starting to build for one client, and an invoice that accidentaly got paid off for another client (plus a little bit in an Overpayment account, but that part we know how to move around). I don't know if this changes anything in the solution accounting-wise.
> >
> > Plamen
> >
> >
> > --- In vantage@yahoogroups.com, "NigelK" <nigel.kerley@> wrote:
> > >
> > > Hi Plamen,
> > >
> > > Officially you can't bring back the originals - as Stephen says.
> > >
> > > However you can "cheat". We do the following for bounced customer cheques:
> > >
> > > We use SQL commands to change the InvcHead.OpenInvoice field from False to True on all invoices that the payment was put against. This re-opens the invoices but leaves them paid in full.
> > >
> > > Then we use Accounts Receivable | General Operations | Adjustment to adjust the balance due on the invoices back up to their pre-payment values. We post the entries to a GL Contra account.
> > >
> > > We then post a Misc Payment through the Bank Account also going to Contra which cancels out the invoice adjustments posting.
> > >
> > >
> > > If you don't mind doing the SQL commands, you should be able to amend the above to suit your needs.
> > >
> > >
> > > HTH,
> > > Nigel.
> > >
> > > --- In vantage@yahoogroups.com, "plamen21" <plamen21@> wrote:
> > > >
> > > > Vantage 803.407c:
> > > >
> > > > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> > > >
> > > > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks,
> > > >
> > > > Plamen
> > > > Systems Administrator
> > > > Art Display Co.
> > > >
> > >
> >
>
17
Hi Plamen,

No, you can leave the appservers running and users can be logged on.

However, in the ODBC setup you must set the "Default Isolation Level" to "READ COMMITTED" (for the update command). Epicor advise against using ODBC for making updates because of this setting - they say it can cause locking issues but I've never come across any.

I don't know if SQLExplorer can be used interactively in the way you're trying to. The only way I know to use it is by means of batch files:

The first batch file "commands.txt" contains the command(s) that you want to run:
select invoicenum, custid, openinvoice from pub.invchead where company='ADC' and invoicenum=53064;

Note that each command should ends with a ;. Also, within the command, company (or any text filter) must be enclosed in single quotes.

The second batch file contains:
set dlc=d:\epicor\oe101b
call d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprogress -password sysprogress -infile <full path>\command.txt -outfile <full path>\odbcresults.txt -sqlverbose
pause

If you restored the DB onto your test server as either Test or Train, you'll need to amend the port: 8350 is for the Live DB, 8370 for Test and 8360 for Train.

Nigel.

________________________________

From: vantage@yahoogroups.com on behalf of plamen21
Sent: Mon 17/05/2010 17:40
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Reverse an Invoice Payment




Thank you very much. I have a copy of a backup that I am trying it on on the test server. Are the appservers supposed to be stopped and everyone out, in order for me to write to the db [Update]?
I am still having trouble with the SQL Explorer not showing the result of my SELECT statements [I don't care that it is text based]
This is what I get:

'\\tactile\epicor\v803'
CMD.EXE was started with the above path as the current directory.
UNC paths are not supported. Defaulting to Windows directory.

C:\WINDOWS>set dlc=d:\epicor\oe101b

C:\WINDOWS>d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprog
ress -password sysprogress
OpenEdge Release 10.1B0309 as of Wed Feb 13 16:39:20 EST 2008
Connecting user "sysprogress" to URL "jdbc:datadirect:openedge://localhost:8350;
databaseName=mfgsys"... (8920)
SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
ny=ADC and invoicenum=53064
1> commit //no result but a 1> prompt, so I try 'commit'
2> exec //still nothing
3> //Enter key on a new line, but still no result
SQLExplorer>
SQLExplorer>
SQLExplorer>
SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
ny=ADC and invoicenum=53064
4>
SQLExplorer>

If I can't figure it out I will try the SQuirreL or something else.

Thanks,
Plamen



Web Bug from http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msgId=90347/stime=1274114487/nc1=1/nc2=2/nc3=3



--
ExchangeDefender Message Security: Click below to verify authenticity
http://www.exchangedefender.com/verify.asp?id=o4HHNm9L025398&from=nigel.kerley@...



[Non-text portions of this message have been removed]
18
Thanks,
It finally worked.
I was able to change the open flag from 0 to 1 on a test machine:

SQLExplorer>update pub.invchead set openinvoice=1 where company='ADC' and invoic
enum='53064';
Update count = 1.
SQLExplorer>select invoicenum, openinvoice from pub.invchead where company='ADC'
and invoicenum='53064';
InvoiceNum OpenInvoice
----------- -----------
53064 1
SQLExplorer>


Plamen

--- In vantage@yahoogroups.com, "Nigel Kerley" <nigel.kerley@...> wrote:
>
> Hi Plamen,
>
> No, you can leave the appservers running and users can be logged on.
>
> However, in the ODBC setup you must set the "Default Isolation Level" to "READ COMMITTED" (for the update command). Epicor advise against using ODBC for making updates because of this setting - they say it can cause locking issues but I've never come across any.
>
> I don't know if SQLExplorer can be used interactively in the way you're trying to. The only way I know to use it is by means of batch files:
>
> The first batch file "commands.txt" contains the command(s) that you want to run:
> select invoicenum, custid, openinvoice from pub.invchead where company='ADC' and invoicenum=53064;
>
> Note that each command should ends with a ;. Also, within the command, company (or any text filter) must be enclosed in single quotes.
>
> The second batch file contains:
> set dlc=d:\epicor\oe101b
> call d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprogress -password sysprogress -infile <full path>\command.txt -outfile <full path>\odbcresults.txt -sqlverbose
> pause
>
> If you restored the DB onto your test server as either Test or Train, you'll need to amend the port: 8350 is for the Live DB, 8370 for Test and 8360 for Train.
>
> Nigel.
>
> ________________________________
>
> From: vantage@yahoogroups.com on behalf of plamen21
> Sent: Mon 17/05/2010 17:40
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Reverse an Invoice Payment
>
>
>
>
> Thank you very much. I have a copy of a backup that I am trying it on on the test server. Are the appservers supposed to be stopped and everyone out, in order for me to write to the db [Update]?
> I am still having trouble with the SQL Explorer not showing the result of my SELECT statements [I don't care that it is text based]
> This is what I get:
>
> '\\tactile\epicor\v803'
> CMD.EXE was started with the above path as the current directory.
> UNC paths are not supported. Defaulting to Windows directory.
>
> C:\WINDOWS>set dlc=d:\epicor\oe101b
>
> C:\WINDOWS>d:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 8350 -user sysprog
> ress -password sysprogress
> OpenEdge Release 10.1B0309 as of Wed Feb 13 16:39:20 EST 2008
> Connecting user "sysprogress" to URL "jdbc:datadirect:openedge://localhost:8350;
> databaseName=mfgsys"... (8920)
> SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
> ny=ADC and invoicenum=53064
> 1> commit //no result but a 1> prompt, so I try 'commit'
> 2> exec //still nothing
> 3> //Enter key on a new line, but still no result
> SQLExplorer>
> SQLExplorer>
> SQLExplorer>
> SQLExplorer>select invoicenum, custid, openinvoice from pub.invchead where compa
> ny=ADC and invoicenum=53064
> 4>
> SQLExplorer>
>
> If I can't figure it out I will try the SQuirreL or something else.
>
> Thanks,
> Plamen
>
>
>
> Web Bug from http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msgId=90347/stime=1274114487/nc1=1/nc2=2/nc3=3
>
>
>
> --
> ExchangeDefender Message Security: Click below to verify authenticity
> http://www.exchangedefender.com/verify.asp?id=o4HHNm9L025398&from=nigel.kerley@...
>
>
>
> [Non-text portions of this message have been removed]
>
19
Just curious, how do you post an invoice to cash?
our system does not allow us to specify GL on the Invoice.

I think they are going to
1. create a misc invoice in plase of the one that got paid
2. create a cash receipt for the amount that was applied incorrectly, and put it on a deposit to the account that was supposed to get it.
3. make a journal entry to move the same amount from the GL that the misc invoice hit to cash.

At least this is my non-accounting interpretation of the ordeal.

Plamen


--- In vantage@yahoogroups.com, Christy Morris <cmorris@...> wrote:
>
> We follow the steps below, with a couple of changes. The new invoice is posted to cash, with ample comments to understand what happened. We then create a cash receipt for the correct customer, which allows for a proper paper trail. The credit to cash from the new invoice offsets the debit to cash from the cash receipt, so the gl is correct.
>
> Christy J. Morris
> Controller
> Cold Jet, LLC
> 455 Wards Corner Road
> Loveland, Ohio 45140
> USA
>
> +1 513-716-6370
> +1 513-576-8986 (fax)
> www.coldjet.com<http://www.coldjet.com>
>
> [cid:image001.jpg@...]
> Setting industry standards in dry ice technology and solutions for over 20 years.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Virginia
> Sent: Friday, May 07, 2010 11:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Reverse an Invoice Payment
>
>
>
> Unfortunately, you cannot reverse cash receipts.
>
> I would create a new invoice for the customer who actually still owes money (it will have to be a different invoice number than the one that was erroneously paid). For it to correctly show on your G/L and your aging, be sure that the fiscal period of the invoice group is the current fiscal period, however, the date on the invoice needs to be the date of the origianl invoice. Note which G/L accout is used.
>
> I would then use an AR Adjustment to reduce to $0.00 the value of the invoice that should have been paid. Enter information in the adjustment screen so that you have it documented that this truly isn't an adjustment but the adjustment is being made to account for an incorrectly applied payment. The adjustment will require a G/L account. Use the G/L account used when the new invoice was created so that the net effect on your G/L will be $0.00.
>
> I believe that the functionality to reverse cash payments is finally available in E9.
>
> Virginia Joseph
> Deep Hole Specialists, LLC
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "plamen21" <plamen21@> wrote:
> >
> > Vantage 803.407c:
> >
> > A payment was applied to the wrong customer invoice, resulting in paying the invoice off.
> >
> > I need to find out how to remove the wrong payment from the paid off invoice. Bring that invoice back onto the customer account with the correct balance. And then take the payment and apply it where it should have gone in the first place.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Plamen
> > Systems Administrator
> > Art Display Co.
> >
>
>
>
> [Non-text portions of this message have been removed]
>