Author Topic: Error #7 - Validate client balances  (Read 84 times)

0 Members and 1 Guest are viewing this topic.

Offline DebAmstutz

  • Scalliwag
  • ******
  • Posts: 4158
  • Karma: +467/-8
  • It's never too late, until it's really too late...
Error #7 - Validate client balances
« on: June 03, 2019, 03:11:42 pm »
Since I can't find info on an Error 7 on a Validate Balances Report other than it appearing on the report, I would need to call Applied for help, or am I missing a way to fix it myself?  The end of the report on the client says "The sum of credits applied does not equal the sum of debits applied!"  The Difference is $50.00  It then gives the totals and there are no other errors.  This one account has been screwed up since 2006 and I'm trying to figure out if they owe us or we owe them (it's all agency bill) and the amount needs to be either returned to the client or billed and collected.

So the end question is can I fix an error 7 myself?

Thanks!
Deb Amstutz
Back in the TAM saddle again

Offline Jan Regnier

  • Scalliwag
  • ******
  • Posts: 4008
  • Karma: +479/-4
  • Users Helping Users
    • Regnier Insurance Services
Re: Error #7 - Validate client balances
« Reply #1 on: June 03, 2019, 04:07:45 pm »
I found this:
Article Number 000009143
Description
Go into Clients, Invoices, Options, Account views, View a payment. Select the payment and receive the above listed error.

Cause

This message can be received for several reasons:

    Payment has been misapplied.
    Two deposits exist on the customer with the same deposit number but different cash journals.An error #7 exists for the client.
    A payment has been applied against another payment.  Agency may have used a net zero cash receipt to back a PAY off a client, or may be using negative cash receipts for Direct Bill Sweeps.
    Bogus deposit number filed due to a cash crash. 

Solution

Set The Environment Variable For Error 7s And Validate Client Balances.

        V7.0.0 and Higher:
            Access Utilities Manager.
            Expand the Accounting option.
            Expand the Receivables option.
            Highlight Validate/Repair Client Balances and press the arrow to run the utility.
            Place the radio button on Validate Balances Report and click Next.
            Place a checkmark in the Include Error 7 checkbox and click Run.
Jan Regnier
Regnier Insurance Services, Highland, IN 6 Users
TAM V2017 HF3, MS 2012 R2 Server, Windows 10 PRO WS; MSOffice 2016

Offline DebAmstutz

  • Scalliwag
  • ******
  • Posts: 4158
  • Karma: +467/-8
  • It's never too late, until it's really too late...
Re: Error #7 - Validate client balances
« Reply #2 on: June 03, 2019, 04:47:59 pm »
Jan - that's how I found out I had an error 7.  It doesn't fix it, just tells me I have it.  I was hoping there was a place to go to fix it without having to ask Applied, but I can make time to call them if necessary.

Thanks!
Deb Amstutz
Back in the TAM saddle again

Offline Jan Regnier

  • Scalliwag
  • ******
  • Posts: 4008
  • Karma: +479/-4
  • Users Helping Users
    • Regnier Insurance Services
Re: Error #7 - Validate client balances
« Reply #3 on: June 03, 2019, 04:58:34 pm »
It looks like it said to give Applied a call with an error 7..... That's probably why it's not listed on the "how to fix" sheet with the other error codes..
Jan Regnier
Regnier Insurance Services, Highland, IN 6 Users
TAM V2017 HF3, MS 2012 R2 Server, Windows 10 PRO WS; MSOffice 2016

Offline DebAmstutz

  • Scalliwag
  • ******
  • Posts: 4158
  • Karma: +467/-8
  • It's never too late, until it's really too late...
Re: Error #7 - Validate client balances
« Reply #4 on: June 04, 2019, 11:53:50 am »
Gotcha - I'll spend some quality time on the phone with Applied accounting then....
Deb Amstutz
Back in the TAM saddle again