Sage 100

I am having an issue my general ledger payables number is different to my aged invoice detailed report it is off by 150,000 what is the cause of this

  • 0

    More than likely, someone "unlinked" the accounts payable, made a general journal entry and then relinked the account again.  This often happens when people post year end entries from the accountants and it is incorrect.  

    To fix it, determine the date that the inconsistency starts/occurs. Hopefully it is just one entry. Look at the transactions by account in Accounts Payable and determine the offending lines. Identify what vendor those entries belong to. Make a backup! Then unlink the AP, delete the entries. Relink AP. Make the entries through the vendor module.

    It that's not it, then there is a database corruption, but that's rare.

  • 0 in reply to AmyGurl

    How do I figure out when this was done and what date how can I go back and research this

  • 0 in reply to queen

    If you were using Sage 50, I would say you can't figure out when it was done unless the Ledger has the wrong numbers.  Then you can look down the ledger report by date and determine which entry is not posted by the payables module by double-clicking it to get the data entry screen.  AmyGurl's answer is an ok solution to fix it (though it can cause problems with foreign currency valuations if you use foreign currencies).

    However, it might be better for the mods to move this message to the Sage 100 forum so you can get some more help from users of your program.  There may be some users/consultants here who use your program, but there would be more on the Sage 100 forum.

  • 0 in reply to Richard S. Ridings

    I must be tired today.  Of course you can back date the Accounts Payable aging and compare the numbers to the Accounts Payable ledger on the same day to see if the numbers match.  Keep changing the dates until they don't match.  This assumes you have never cleared the paid historical invoices, do not use filters and include inactive vendors.

  • 0 in reply to Richard S. Ridings

    You should be aware that in Sage 100, the AP and AR aging reports are not intended to agree to the GL.  Transactions are listed in the aging reports by invoice date, but they post to the GL by transaction date (aka accounting date).  The Trial Balance reports in the modules should agree to the general ledger.  The only way to keep the aged invoice reports and the trial balance reports is to make sure that all the invoices in the batch are dated in the same month/period as the date that the

    Now, if you have had an unlink-relink situation such as what Richard describes, this would throw that relationship off as well.  Or one or more journal entries has been made directly to AP.  The best way to check for these situations is to determine the last date that the 2 were in sync.  Then print or export the General Ledger Detail Report for your Accounts Payable account beginning on that date and look for transactions where the source is not the AP module (usually AP, CD and MC).  

    Sage 50 and Sage 100/ Mas90 are two entirely different beasts.  Any similarities are purely coincidental.

  • 0

    What did your reseller say when you asked them?  Note that the Aged Invoice report is NOT meant to tie to the GL BY DESIGN. The TRIAL BALANCE is what you should be using.

    And some of these responses OMG!Sad  First see what the Trial Balance says. Note that the Aged Invoice report takes into consideration future dated transactions which will cause it not to tie to the GL.

  • 0
    Is your Trial Balance report off too? You should be using the Trial Balance not the Aged Invoice report to reconcile