Results 1 to 3 of 3

Thread: Data Integrity - Verify Balance & Transactions OUT of balance

  1. #1
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post

    Question Data Integrity - Verify Balance & Transactions OUT of balance

    Hi all,

    Long story short.
    On the customer age analysis, a customer account shows an amount outstanding which differs from the statement each month.
    The account was queried and I decided to take the matter in my own hands and to open a new account and just journal the outstanding invoices into the new account and out of the old account.
    That balanced beautifully onto the new account and the old account now shows R0.00 (except on the age analysis but |I'm not going to worry about that now).

    I did a Customer journal, where I debited and credited contra account 1000. The Sales account. I thought I did it correctly, as everything balanced, statement and age analysis is perfect.

    However, when the customer paid the account via Point of Sale, I was able to allocate the payment to the outstanding invoices, but now that exact amount now shows up errors in the data integrity report.

    There's a difference on Customer balances / Customer Control, Open Item out of balance. Was I suppose to also debit and credit the Customer Control account ?

    What did I do wrong? How do I fix it?

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    It's a pity that you decided to take matters into your own hands, because the original problem that you tried to fix is a data corruption problem which cannot be fixed with journals - they simply muddy the waters even more, as you've discovered.

    The data corruption can only be fixed with the right tools, which I have, so you are welcome to drop me an email with your details and we can arrange a TeamViewer session. But don't try to process any further journals - it will complicate it even more!
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Email problem
    Join Date
    May 2014
    Location
    South Africa
    Posts
    32
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks Neville, I'll get back to you soon!

Similar Threads

  1. [Question] PASTEL-CASHBOOK BALANCE AND BANK STATEMENT BALANCE INCORRECT
    By Marley29 in forum Accounting Forum
    Replies: 13
    Last Post: 22-Jan-21, 09:16 AM
  2. [Question] Partner v18 - Data Integrity - Verify History
    By kevvie in forum Accounting Forum
    Replies: 0
    Last Post: 24-Apr-18, 04:04 PM
  3. Replies: 1
    Last Post: 28-Apr-17, 04:14 PM
  4. [Question] Transactions out of balance Partner v14
    By lushern1309 in forum Accounting Forum
    Replies: 4
    Last Post: 27-Oct-16, 01:49 PM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •