Home Page link  

One of my customer balances is royally screwed up

 

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
One of my customer balances is royally screwed up Frank Santoro 08-04-2007
Posted by Frank Santoro on August 4, 2007, 9:29 pm
Please log in for more thread options
Using QB Pro 2005 for Windows...

I made some changes in a couple of credit memos that had already been
applied to invoices (basically changed the items on those credit memos
but not the amounts). Now the balance for the customer who had those
credit memos is messed up.

The balance is correct in the customer job list and his A/R register,
but if I run an Open Balance report it shows the two credit memos with
negative open balances and two invoices (probably the invoices to which
the credits were applied) also with negative open balances.

Plus, when I open the Receive Payments box and call up the customer, it
shows a different balance and if I open the Discounts and Credits box it
shows all kinds of wacky stuff, like trying to apply a negative amount
from the credit to the invoice.

What's the best course of action here? Delete the credit memos and
re-enter them? Ignore the problem? I welcome any suggestions. I've
already done a data verify and data rebuild.

Frank
---
The return address is not monitored; send offline responses to
santoroATyahooDOTcom

Posted by hatesspam on August 7, 2007, 10:08 am
Please log in for more thread options
> Using QB Pro 2005 for Windows...
>
> I made some changes in a couple of credit memos that had already been
> applied to invoices (basically changed the items on those credit memos but
> not the amounts). Now the balance for the customer who had those credit
> memos is messed up.
>
> The balance is correct in the customer job list and his A/R register, but
> if I run an Open Balance report it shows the two credit memos with
> negative open balances and two invoices (probably the invoices to which
> the credits were applied) also with negative open balances.
>
> Plus, when I open the Receive Payments box and call up the customer, it
> shows a different balance and if I open the Discounts and Credits box it
> shows all kinds of wacky stuff, like trying to apply a negative amount
> from the credit to the invoice.
>
> What's the best course of action here? Delete the credit memos and
> re-enter them? Ignore the problem? I welcome any suggestions. I've
> already done a data verify and data rebuild.
>

The customer balance and the A/R register are correct... that's a good
thing. If the problem is in the application of the credits to the invoices,
then your best bet is probably deleting the credits and re-creating (with
the same number and date).



Posted by Frank Santoro on August 7, 2007, 10:02 pm
Please log in for more thread options
hatesspam wrote:
> The customer balance and the A/R register are correct... that's a good
> thing. If the problem is in the application of the credits to the invoices,
> then your best bet is probably deleting the credits and re-creating (with
> the same number and date).
>
>

I had to go a step further and delete the invoices the credits were
applied to and then recreate those as well. The open balance report
still looked funky, but once I applied the credits to the invoices,
everything appears to have worked out fine. Thanks.

Similar ThreadsPosted
Zero Balances on A/R Ageing Summary October 2, 2006, 5:18 am
Customer PO November 10, 2007, 5:25 pm
Re: Customer just vanished June 21, 2006, 10:20 pm
Re: Customer just vanished June 22, 2006, 12:53 am
Customer fees October 16, 2006, 1:59 pm
customer that is also a supplier March 13, 2007, 5:00 pm
Customer Job Balance February 22, 2007, 9:45 am
Customer Payments October 15, 2007, 8:58 am
How do I print a customer payment? July 26, 2006, 8:17 am
Customer Inventory Management September 22, 2006, 11:54 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap