Sage 100

I have a client on MAS 90 2014 PU 4. They are entering AP checks that have a check date of 1/31/2015 but a posting date of 4/30/2015. (We are entering history in a new company is the reason for the dates). I noticed that the AP Aged Invoice Report will show invoices dated January or before that were paid with a check dated 1/2/2015 as open if the Excluded Future Dated Transactions box is checked. In other words, the invoice date controls if the invoice appears on the report but the check date is controlled by the transaction date. Maybe it was like this all along and I have just misunderstood or did something change recently? TIA Cooper

The AP Aging and the AP TB are both a little shaky when it comes to dates. If, God forbid, you have a payment entered before an invoice date, you can just kiss that whole thing goodbye. The issue is their logic used to create the work file, not really the data itself. It is always looking for the invoice to be the first activity, chronologically. And none of this really answers your question, but I had to get it off my chest.

Is that the cart before the horse?? Thanks Beth

Cooper, Your statements are correct - until the report is run for a date after 1/02/2015, the Invoices will not reflect as paid if the Exclude Future Dated Transactions box is selected, and the payments (dated prior to 4/30/15) for the Invoices posted on 4/30/15 won't appear on the report until the Invoices do. Curious, Is the transaction date and posting date for the Invoices the same? Just wondering if you may get better results by running the report by the other option. However, this will not solve the above issue, when the check transaction is dated prior to the invoice transaction.