3.0 AP Aging with History Flag

Softbase has released a new version of the AP Aging that utilizes the History Flag of AP Invoices.  

This report mimics the AP Aging History report in the original Microsoft Access Reports that were provided in the past.  

The AP Aging will exclude any records where the History Flag has been set to True and the Effective Date of the AP Invoice is before the date selected when running the report.  This can produce a point in time report in regards to when AP Invoices were opened but as it excludes AP Invoices with the History flag set to True it isn't a true point in time report.  For those looking to see the state of the AP at a given time, we recommend to continue to use the AP Aging Report if that is needed as that only looks at Apply to AP Invoices that don't sum to 0 to include on the report and ignores the History flag.  

Being that the  Apply to AP Invoice concept wasn't always around until 3.0 we have found cases where it wasn't used or explained correctly, resulting in users possibly using the History Flag via the database to remove AP Invoices from the AP Aging/AP Inquiry.

The Apply to AP Invoice concept is intended and recommended to be used when a credit is given from an AP Vendor that will be applied against an AP Invoice that hasn't been paid.  In our latest Softbase 3.0 releases the Apply to AP Invoice can't be an AP Invoice Number for the same Vendor that has already been paid and moved to history.  We only recommend setting it to a valid AP Invoice Number that is still open to be paid for the Vendor.  

In addition to the above and issues that have been fixed in recent Softbase 3.0 release AP Invoices may not have been cleared off the AP Aging or AP Inquiry correctly by an AP Check or AP Invoice Credit.  This could have also led to AP Detail vs. GL Detail out of Balances.  

At this time if you run across a Vendor or Vendors that don't tie out as you expect and if you would like to clean those up please reach out to Softbase Support who is  able to run a script to set all the AP Detail back to an open state, move those back to history where the Apply to AP Invoices sums to 0, leaving the rest in an open state and allow you to update the Apply to AP Invoice in AP Inquiry where needed to move those AP Invoices back to History which would cleanup the AP Aging in Softbase and not have to depend on the History Flag.