Sage 100

Does anyone know where the Aging Summary numbers shown at the bottom of the AP Vendor Maintenance/Inquiry Statistics and Invoices tabs come from? Are they stored somewhere like in AR or are they just computed when you open Vendor Maintenance/Inquiry. We have a client on 4.5 with a vendor that has two open invoices, one in the current column and another in the 30 days column. The summary shows the current invoice properly. The 30 day column contains a higher amount. The 60 day column show another positive amount and the Retention (client has job cost) column that shows a negative amount. The additional amount from the 30 day column, the 60 day column and the Retention net to zero with no detail to support it. It appears adjustments were made to one of the invoices but the bogus amounts don't seem to match anything.

It may work the way it used to - only gets recalculated when you run an AGING

There is a setting in AP options to set this to recalc always so that when you inquiry, they display properly.. I agree with Beth that it should get reset when you run the aging. Also, rebuild your sort files for AP. There is a prompt to recalculate vendor balances there.

@JeffSchwenk , Jeff, Jeff. There you go again, thinking that Sage would make AR and AP mirror images. NOT. There is no option in AP.

Damn that half heimers disease............. sigh!!! Sorry, my left brain wasn't talking to my right brain....

Thanks to you both. @BethBowers, we did the aging thing thinking it was like AR. @JeffSchenwk, will try sorts, should have thought of that.