Incorrect credit records in ap table (v1.2.12 with some individual ar/ap updates)

["Gerald Chudyk" <..hidden..>]

Hi all,

While researching issues in the ar/ap reports, I have discovered
records in the ap table which appear to be incorrect. One example:

ap.amount = -4919.89
ap.netamount = 5198.36 (should be -4641.42)
The AP transaction report gets real excited about this and reports
tax= (2 * netamount) + (netamount - amount).

We are using gst tax.
The Edit AP Transaction screen gets it right. I wonder if it ignores
the ap table?

I also notice that different ap record with a similar problem shows
netamount = 237 instead of 237.00 .

The strange thing is that some credit records with the same date seem
fine. We have been using lsmb since January. These errors seem
scattered throughout January to May.  I haven't looked for a pattern.

I can manually change each record that appears wrong. Better would be
to create an audit routine that recalculates the fields based on the
source records (not sure I can accomplish this).

Am I alone with this problem? Did I miss a patch?

Inquiring minds want to know.

Regards,
Gerald.