AR Status Date vs Accounting Date, when should they be different?

We noticed our GL Outstanding Balances did not match up with Open Invoices available that were open in AR for a given vendor. Since I wrote these reports in SQL, I wondered if I'd made a mistake. When I looked at the table data to see if my reports were off, I noticed that the Status Date and Accounting Date for two transactions were the same date but had different years. This accounted for the variance.

I've tried searching for more info on the status date to understand why these fields are different but am not finding much. I don't think for our use, there should ever be a difference between these two fields and I'm not sure how it happened. What is the difference between the AR status date and accounting date and how are each changed? 

Thanks!

Parents Reply Children
  • 0 in reply to Rhonda V

    Thanks. We have a few examples for an Invoice (not cash receipt) that has different status and accounting dates. So it's hitting the GL in one year and AR in another year. The GL and AR module is off by that amount until the later date passes. I've seen this with Voids, somebody voids something with the wrong date. But I've never seen it with an Open Invoice before (no adjustments on the invoice). The Accounting date is 1/31/2022 and the Status date is 1/31/2021. There is nothing in the adjustment register. Is there a way I can fix this? Maybe I need to Void the Invoices using the accounting date and re-enter them since I'm not sure I can adjust a Status date on them. 

  • 0 in reply to WarrenH

    According to the link, the status date is set by the invoice date.  I think you are right that the only solution is to void and start over.  I ran across something in knowledgebase about voiding older invoices that you should review.  Use knowledgebase at:  Sage Knowledgebase and type in the search box "void ar invoice".  It will affect older periods and may be something you should consider first.  Good Luck!