AP invoice and the AP Trial Balance Report compared to the GL

SOLVED

Hello,

I ran the AP trial balance report for January and compared it to the January GL.  I discovered it didn't match.  I found out that someone had entered a January invoice into February.  Then to correct it, they adjusted the invoice to 0 in February, and adjusted January to the amount of the invoice.   The GL is correct, but the AP trial balance report is still off by the amount of the invoice. 

I noticed in Vendor Inquiry, on the 'Invoices' tab, the invoice detail shows that the invoice transaction date is still February.  I'm guessing this is why the report does not match the GL.

Is there another way to correct an AP  invoice after it is posted in the wrong future month?    I suppose we could zero out the invoice in February, and then post a dummy invoice in January, but I don't want to start posting dummy invoices just to correct this issue.

Thanks.

Parents
  • +1
    verified answer

    And yet - that is actually what you have to do (even if you read Sage's documentation on fixing such an issue).  The problem isn't really your data, which technically is correct at this point - it's how Sage gathers the data for the report.  Basically you can move things forward, but not backward.  Just bite the bullet and adjust off, then adjust back on with the same invoice number with a period at the end, or "A", or something.

  • 0 in reply to bethbowers

    Thanks.  I was hoping there may be some other way that I didn't know about.  I'll keep adjusting then.  I appreciate your help.

Reply Children
No Data