I have never figured out why it never display correctly.
WHen I pull for 1 month, eg Feburary 2012 to Feburary, it will be correct, but if I pull 1 year, Jan 2011 to Dec 2012, it does not show everything.
I just narrow down to a few lines, my office rental is 1000 a month, I see this line for every month of I pull monthly, but if I pull the annual report, it shows only 2000. It should be 12000.
how long has it beenn out?
Have you tried a repost all from the first period of the year?
It happens to me from time to time, but could not find the exact reason. When balance or P&L or bank statements get crazy numbers, we repost all transactions from Z_index.php (as Phil suggested) and always fixes the problem.
I think (only think, I have no hard facts proof) it has to do with accounting transactions not being an SQL transaction. So if something goes bad, it is only half done, but not rolled back as it should be. My point is: Tx is posted at gltrans but not at the other tables related.
where is and what does the repost all transaction do?
Hi, Rong,
You can try this scripts: Z_RePostGLFromPeriod.php
Best regards!
Exson
HI, what exactly does repost do? Will it mess up anything, or just a reporting table only?
Hi, Rong,
It just correct those wrong data in a table. Usually, it'll not mess anything up. You can backup your data before doing this.
Best regards!
Exson
(03-27-2012 09:11 AM)Exsonqu_Qu Wrote: [ -> ]Hi, Rong,
It just correct those wrong data in a table. Usually, it'll not mess anything up. You can backup your data before doing this.
Best regards!
Exson
It seems to work and have corrected all the wrong numbers I see all along.