|
From: Gordon H. <gha...@ma...> - 2001-09-16 23:12:46
|
I guess the concensus is I'm an idiot. Fine, lets move on. Entering all this old billing I have yet again, somehow I ended up with 2 vendor invoices on the same date with the same invoice number for the same amount. I would bet the only thing different between the 2 entries was the PostgreSQL OID. So, I deleted on of these duplicate vendor invoices, and everything seems okay. Everything balances anyway. Next, I have run into a situation where my cost on purchasing something from a vendor has gone down (it turns out quite a bit, but I don't think the size of the decrement is involved). If I update the "parts" entry for the new price on the day I go to invoice the part, it invoices the part at the old price. If I move the day that the part price decrease took effect a day or a month, it still uses the old (higher) price. I can manually over-ride the price. Gord |