Integrity Summary - Need Help in Solving

 Hello,  Could someone please help me solve this problem: 

 

Integrity Summary:

Total Debits    317,268.89                                 Total Credits    317,268.89

A/P Balance    3,412.60                                     Unpaid invoice/prepayments        3,390.00

A/R Balance   17,074.30                                    Unpaid invoiced/deposits            17,074.30

Advances + Loans    0.00                                   Advances + Loans Paid               0.00

Vac. Pay  Balance    0.00                                    Vac. Pay  Owed                           0.00

Account Reconcilation    Matched

Data inconsistencies have been detected

Historical Information

Vendors                                          not balanced

Clients                                            balanced

Employees                                     balanced

Inventory + Services                      balanced

  • 0
    My guess is that you are still in History Mode and you can not get out of History Mode until the inconsistency is resolved. If this is the case then verify that all of the outstanding invoices at start up were properly entered and agreed with the amount entered in A/D account at start up. It would appear that a $22.60 invoice was not entered from History. Or it might be a $22.60 payment was entered yet it had not adjusted the A?P Balance. This $22.60 may be a combination of one or more invoices and/or payments. Also, if there is an amount in the Prepayment Account it will affect this balance.
  • 0
    Hi Stewart

    A/P Balance 3,412.60 Unpaid invoice/prepayments 3,390.00

    Left hand side is the Link Account's Chart of Account value (general ledger value, GL), right have side is outstanding invoice value (Sub ledger value, SL)

    2 way of fixing this depends on which is correct, GL or SL

    If GL is correct, that means there is missing historical invoice, you can go the correct vendor's historical tab, create one or more historical invoice value that total up 22.60

    If SL is correct, that means need fix account's payable value, you can go to Chart of account find account's payable, edit opening balance down by 22.60, (sage will ask to allocate the offsetting account) or, if you do not use foreign currency, you can unlink A/P in Setup, settings, Accounts payable and Link account, then post correction journal entry, and then link Accounts payable back.