Sage 100

I have a customer on 4.50 PU 1 when I look in AP Vendor Maintenance and at the total aging that displays at the bottom -- it doesn't tie to the detail displayed above. Rebuild sorts does nothing. Is there a way to rebuild these totals that I'm overlooking?

Anyone know what file holds this summary aging? I haven't been able to find the file --- the data isn't in the AP_Vendor

Well, I was going to say there is a setting in AP set up that controls the recalc, but I can't find it. There is one in AR set up. Silly me for thinking the two modules might even be close to consistent!!!!! Hopefully, someone sees the magic switch.

Isn't there a gears icon (recalc) to the right of those Aging buckets? Although if the Aging setting in A/R is set to Always calc, this shouldn't be needed.

I take that back. I mixed up AP and AR.

Odd - yeah I thought similarly - figured it had to be a sort but rebuild didn't do anything

Does it change if you run an aging?

No - the wrong fields include the 90 day and retention column. Very odd. I'm not sure where MAS is sourcing this data from. My guess is it might be some type of work or sort file.

I think the history and aging is compiled by the program from AP Invoice History Header and Detail or AP_TransactionPaymentHistory. You might try rebuilding those files.

When I move from vendor to vendor it seems like the balances change too quickly to be pulling from detail files. I'm thinking there's some location that information is stored like sort file but maybe it's computing on the fly.

And the aging buckets don't dynamically recalculate based on using any type of date restriction on the Vendor Maintenance Invoices screen. The total remain the same.

Can you process a voucher to see in the buckets recalc when you open. There are no fields in the AP_Vendor table so they are probably calculated during some update. Again, a missed opportunity to have a consistent feature set through out the modules. Sigh!

Did you say they have Job Cost? It might have something to do with the AP_JobDistributionDetail file. I remember there being something with that back in legacy. Has to do maybe with the retention amount in that file. I don't remember the details right now but will think more about it and see if I can remember.

Thanks - I am still stumped where this total is drawn from. Have not been able to spot a data file and the number is displayed instantly so I think it's coming from a work or other summary file as opposed to being computed in real time.

That is the file - it is the retention amount on the records in that file. I just changed one of the records through dfdm to add a retention amount and it shows up in the retention total at the bottom of the screen but no where in the detail.

Thank you very much @RobertaFerguson !

I just tested making a change to field# 8 RetentionAmount within a record that also had a balance and there was no impact on what I was able to view at the AP - Main - Vendor Maintenance - Invoices tab. Again to be specific I am view the SUMMARY totals aging at the very bottom which appears to be static and somehow computed by a work file or other temporary file. Running Aged Invoice Report does NOT recompute anything Making changes to the file noted above. Exiting MAS. Re-entering. Does not recompute or change anything. Am I using a different field number? I continue to believe there must be a summary file located somewhere that pulls this information because in my opinion it is too fast to recompute as you page through vendors.

I am on the invoices tab and I see that my total at the bottom of the screen changed to include the amount I entered on a record for that vendor in the AP_JobDistributionDetail file in the retention field amount. Not sure why you wouldn't be seeing that. Maybe try it in EEC. See my screen shot.

@roberta your screen shot looks like exactly what I'm seeing with the customer - -a ""phantom"" amount in the 90 day column and a resulting retention balance. Both not supported by the detail above. I only made changes on the retention field for the vendor -- do you remember if you used a different field? Maybe I'll have to take a closer look because this does appear to duplicate the issue almost exactly.

Here's a screen shot of dfdm. I did change the balance amount to see if that did anything but it didn't. You can see my amount in the retention field which is what showed in vendor maint.

Thanks I'll look at this again.

I tried this fix again and i am unable to duplicate any change. I did a Crystal to export out the AP_JobDistributionDetail and there were no values for retainage for the customer in question. Still not able to duplicate or see where this AP screen pulls summary aging from. Re-running aged invoice report in AP doesn't appear to have any affect.

Wayne - just for fun, rename and manually reinitialize the AP_JobDistributionDetail file so it is empty and see if that makes a difference in what you see. That way at least we eliminate that file as even being a possibility.

Ok I am now able to partly duplicate and verify that the AP Vendor Maintenance - Invoices tab does appear to compute this info on-the-fly. Making changes in the data file you mentioned appear to also change the retention total. Need to see why my customer's account didn't change when I tested this morning

Update: Clearing the AP Job Distribution Detail does in fact clear out the wrong balance. I can see that the balance existed since before the customer upgraded. I'm not entirely sure how to locate the wrong amount since if I run a Crystal against it there's zero retainage amounts showing.

Update: Still digging but this appears to be an issue when within AP_JobDistributionDetail: Field Distribution Amount is >0 and the Balance Field is <0 There may be other factors at play but as of now this appears to produce a list of amounts which show as ""retainage"". I believe that the way this is supposed to work is that when the Balance field is >0 and the Retainage is <>0 the retainage amount shows at the bottom of tab #6 (invoices) in vendor maintenance in the aging as retainage. This is mostly a WAG but I'm posting here in case someone else runs into this same issue in hopes that it gets you a little farther.