Messing with the DB

[Peter McKenna <..hidden..>]

Hi All,
After I upgraded to 1.2.9 AP Transaction invoice numbers started to always come up as 1. This appears to have been fixed in 1.2.16. I cleaned up the old transactions by manually editing the transaction invnumber in the ap table so they sequentially increase with date and updated the default AP Transaction number in System Defaults. This appears to work fine. It appears that invnumber is just a number and is not relied apon elsewhere. Is that correct or can I expect problems with what I've done?
Also the Tax Paid report still did not show Amounts for the transactions that where showing a 1 for the invoice number but simply turning off auditing and re-posting these transactions fixed that.
Is anyone able to explain why this is? where in the DB is the Tax Paid report getting the Amount column data from?
Regards,
Peter