Sage 100

Last call for this issue which I believe is likely a data corruption issue. Customer reports that in vendor maintenance - invoice tab - the aging total at the bottom of the screen reports an incorrect total for retainage. I think we've previously determined - and I've verified - that the retainage $ is at least partly pulled from AP_JobDistributionDetail. If I add an amount to a ""retainage bal"" in the AP_JobDistributionDetail the retainage total does indeed change. The problem is that when I run a crystal report (before making any changes to the balance) against AP_JobDistributionDetail the field for retainage bal returns all zero in every record. So I'm baffled as to whether there's another file that plays into this one line aging summary shown on the vendor master file -- or whether this is a bug and/or pure data corruption. The customer has asked about zeroing out AP_JobDistributionDetail (which I did in a test company and the balance in vendor maintenance worked fine). However I'm paranoid that I'll mess up some little used reporting by zeroing this file. Anyone have any other insights? My tentative proposed solution is to manually change one fo their AP_JobDistributionDetail records' retainage bal totals so that the vendor maintenance aging for that record is properly reflected and that gets me out of having to wipe the whole file. Interested if anyone has run into this before I propose the above

That file is what is used for job cost postings. It is what controls the amount paid over in job cost. Some people don't care about showing that but if you wipe it out just be aware of that.

I think that I'm going to do is keep the file but ""plug"" a balance to zero out retainage. I am waiting for the customer to tell me how many of their vendors are affected.

Other thing about wiping it out is when it sees a job number in the open invoice file and you have to reverse a check, it might cause problems because it will look for that record in the job distribution file.