Bad Bad Customer!

system · March 31, 2011, 12:02pm

Thanks, Val and Ed, your ideas definitely help me!

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Val Buige
Sent: Thursday, March 31, 2011 10:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Bad Bad Customer!

I have not been able to find a way to re-open the invoice. I finally
settled on handling this issue by creating a new miscellaneous invoice
or a new invoice from the order for the full amount of what was owed
plus fees using a miscellaneous charge. The comment section would
contain my notes as to the returned check, invoice, etc.

Val Buige

Controller
Delmarva Millwork Corporation
1275 Manheim Pike
PO Box 4068
Lancaster, PA 17604
Phone (717) 299-2361 x 123
Fax (717) 295-4598

valb@... <mailto:valb%40d-m-c.com>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Edward F. Fox, Jr.
Sent: Thursday, March 31, 2011 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Bad Bad Customer!

No great way to handle this. Options include, but not limited to:

1. Use Bank Adjustment Entry and debit an "other receivables" account
and carry outside of the a/r aging report. This can be done for both the
original invoice and the charge. These amounts can then be cleared
during
reconciliation. If charges are done via analysis, you may want to
consider
this when using this method for the bank change portion.
2. Use ODBC and up date the invoice open flag on the invoice. Use A/R
Adjustments to increase the amount of the invoice. You are going to need
to
clear this through a clearing account and use "Bank Adjustment Entry" to
handle the cash portion so it shows up in the bank statement
reconciliation.
Create a new invoice for the bank charges as that is a new transaction.
This method will work, BUT THERE IS ALWAYS A RISK USING ODBC TO
MANIPULATE
THE DB.

If you would like a more detailed explanation of the above let me know.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 . Fax 401-596-1050
<http://www.maxsonautomatic.com> www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Thursday, March 31, 2011 11:23 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Bad Bad Customer!

I received a returned check from my bank for this bad customer. Since
the invoice has been closed for payment, how does one go back and show
that the invoice has not really been paid AND how do I add the fees to
the invoice as well?

TIA!

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

constant innovation

www.weldcoa.com <http://www.weldcoa.com/>

[Non-text portions of this message have been removed]

__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 6002 (20110331) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · March 31, 2011, 11:22am

I received a returned check from my bank for this bad customer. Since
the invoice has been closed for payment, how does one go back and show
that the invoice has not really been paid AND how do I add the fees to
the invoice as well?

TIA!

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa@...>

800.852.2325

630.806.2000 ofc

630.806.2001 fax

constant innovation

www.weldcoa.com <http://www.weldcoa.com/>

[Non-text portions of this message have been removed]

system · March 31, 2011, 11:38am

No great way to handle this. Options include, but not limited to:

1. Use Bank Adjustment Entry and debit an "other receivables" account
and carry outside of the a/r aging report. This can be done for both the
original invoice and the charge. These amounts can then be cleared during
reconciliation. If charges are done via analysis, you may want to consider
this when using this method for the bank change portion.
2. Use ODBC and up date the invoice open flag on the invoice. Use A/R
Adjustments to increase the amount of the invoice. You are going to need to
clear this through a clearing account and use "Bank Adjustment Entry" to
handle the cash portion so it shows up in the bank statement reconciliation.
Create a new invoice for the bank charges as that is a new transaction.
This method will work, BUT THERE IS ALWAYS A RISK USING ODBC TO MANIPULATE
THE DB.

If you would like a more detailed explanation of the above let me know.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 . Fax 401-596-1050
<http://www.maxsonautomatic.com> www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Thursday, March 31, 2011 11:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Bad Bad Customer!

I received a returned check from my bank for this bad customer. Since
the invoice has been closed for payment, how does one go back and show
that the invoice has not really been paid AND how do I add the fees to
the invoice as well?

TIA!

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

constant innovation

www.weldcoa.com <http://www.weldcoa.com/>

[Non-text portions of this message have been removed]

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 6002 (20110331) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

[Non-text portions of this message have been removed]

system · March 31, 2011, 11:45am

I have not been able to find a way to re-open the invoice. I finally
settled on handling this issue by creating a new miscellaneous invoice
or a new invoice from the order for the full amount of what was owed
plus fees using a miscellaneous charge. The comment section would
contain my notes as to the returned check, invoice, etc.

Val Buige

Controller
Delmarva Millwork Corporation
1275 Manheim Pike
PO Box 4068
Lancaster, PA 17604
Phone (717) 299-2361 x 123
Fax (717) 295-4598

valb@...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Edward F. Fox, Jr.
Sent: Thursday, March 31, 2011 11:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Bad Bad Customer!

No great way to handle this. Options include, but not limited to:

1. Use Bank Adjustment Entry and debit an "other receivables" account
and carry outside of the a/r aging report. This can be done for both the
original invoice and the charge. These amounts can then be cleared
during
reconciliation. If charges are done via analysis, you may want to
consider
this when using this method for the bank change portion.
2. Use ODBC and up date the invoice open flag on the invoice. Use A/R
Adjustments to increase the amount of the invoice. You are going to need
to
clear this through a clearing account and use "Bank Adjustment Entry" to
handle the cash portion so it shows up in the bank statement
reconciliation.
Create a new invoice for the bank charges as that is a new transaction.
This method will work, BUT THERE IS ALWAYS A RISK USING ODBC TO
MANIPULATE
THE DB.

If you would like a more detailed explanation of the above let me know.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone 401-596-0162 . Fax 401-596-1050
<http://www.maxsonautomatic.com> www.maxsonautomatic.com

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Thursday, March 31, 2011 11:23 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Bad Bad Customer!

I received a returned check from my bank for this bad customer. Since
the invoice has been closed for payment, how does one go back and show
that the invoice has not really been paid AND how do I add the fees to
the invoice as well?

TIA!

M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa@...
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> >

800.852.2325

630.806.2000 ofc

630.806.2001 fax

constant innovation

www.weldcoa.com <http://www.weldcoa.com/>

[Non-text portions of this message have been removed]

__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 6002 (20110331) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]