Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
General Ledger Profit and Loss Statement not correct
02-13-2012, 08:36 PM,
#1
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.
Reply
02-14-2012, 05:53 AM,
#2
RE: General Ledger Profit and Loss Statement not correct
how long has it beenn out?
Have you tried a repost all from the first period of the year?
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
02-14-2012, 10:45 AM,
#3
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
Reply
03-15-2012, 10:11 AM,
#4
RE: General Ledger Profit and Loss Statement not correct
where is and what does the repost all transaction do?
Reply
03-15-2012, 10:37 AM,
#5
RE: General Ledger Profit and Loss Statement not correct
Hi, Rong,

You can try this scripts: Z_RePostGLFromPeriod.php

Best regards!

Exson
Reply
03-27-2012, 02:45 AM,
#6
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?
Reply
03-27-2012, 09:11 AM,
#7
RE: General Ledger Profit and Loss Statement not correct
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
Reply
04-18-2012, 01:24 PM,
#8
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)