02-13-2012, 08:36 PM,
|
|
ronwong
Member
|
Posts: 32
Threads: 17
Joined: Jan 2012
|
|
General Ledger Profit and Loss Statement not correct
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.
|
|
02-14-2012, 10:45 AM,
|
|
PakRicard
Senior Member
|
Posts: 252
Threads: 81
Joined: Jan 2012
|
|
RE: General Ledger Profit and Loss Statement not correct
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.
Regards,
Pak Ricard
|
|
03-15-2012, 10:11 AM,
|
|
ronwong
Member
|
Posts: 32
Threads: 17
Joined: Jan 2012
|
|
RE: General Ledger Profit and Loss Statement not correct
where is and what does the repost all transaction do?
|
|
03-27-2012, 02:45 AM,
|
|
ronwong
Member
|
Posts: 32
Threads: 17
Joined: Jan 2012
|
|
RE: General Ledger Profit and Loss Statement not correct
HI, what exactly does repost do? Will it mess up anything, or just a reporting table only?
|
|
04-18-2012, 01:24 PM,
|
|
ronwong
Member
|
Posts: 32
Threads: 17
Joined: Jan 2012
|
|
RE: General Ledger Profit and Loss Statement not correct
(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.
|
|
|