Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved:Initial Balance for acc. 3510 Historical Balance not showing in Trial Balance
04-23-2013, 01:05 AM (This post was last modified: 04-25-2013 08:39 PM by MacPhotoBiker.)
Post: #1
Solved:Initial Balance for acc. 3510 Historical Balance not showing in Trial Balance
Hi,
I´m not sure if this issue is a bug, or if it´s just my lack of knowledge...

For a customer I set up a new installation of webERP. We posted all opening balances, and they show correctly in the Trial Balance.

For "3510 Historical Balance" we posted an opening balance at "1/1/2013". When I run the trial balance from January to January, it shows correctly in "Month Actual". When I run it from January to February, it shows correctly in "Current Period.

But when I run the Trial Balance from January to March (or any later period), this account only shows "0".

To me (and my customer) this just looks wrong, but again, maybe I´m just missing something.

Could somebody please help me out?

Thanks a lot!

MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
Find all posts by this user
Quote this message in a reply
04-23-2013, 07:50 PM
Post: #2
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
So the year to date balances are not showing correctly??

Run Z_RePostGLFromPeriod.php and see if that fixes it?

There is a bug somewhere there but never been able to find it :-(

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-23-2013, 11:24 PM
Post: #3
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
Hi Phil,
thanks for your answer. I ran Run Z_RePostGLFromPeriod.php (for every month January to April), and indeed it fixed the problem.

That´s great, and I do appreciate it. But of course, this leaves quite of a concern to know that there is a bug somewhere in the Trial Balance. It was quite easy now for me to spot the problem, since it was only a handful of postings anyway, and my customer is an accountant, so he was very particular with the balance sheet to begin with.

I´m not a PHP programmer, but if there´s something I could do to find the bug, please just let me know, I´d gladly help. I´d really be more comfortable if we could eliminate that bug

Thanks again Phil

MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
Find all posts by this user
Quote this message in a reply
04-24-2013, 06:34 AM (This post was last modified: 04-24-2013 06:35 AM by phil.)
Post: #4
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
All I need to know is how to repeat this problem consistently and I will be able to figure out how to prevent it... if you could spell out the steps I will fix it today!

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-24-2013, 06:55 AM (This post was last modified: 04-24-2013 03:47 PM by MacPhotoBiker.)
Post: #5
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
OK, I will try to reproduce the error. I will actually make a couple of clean webERP installations on my server, and try to narrow down the transactions that may have led to that problem. Don´t expect it today, but during the week I´ll certainly work on it.
Thanks for being so responsive, I appreciate that.

MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
Find all posts by this user
Quote this message in a reply
04-24-2013, 07:02 AM
Post: #6
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
Although I have tried, I have never yet been able to reproduce this - so if you can show me that would be really great :-)
Thanks for your help to improve webERP.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-24-2013, 03:47 PM (This post was last modified: 04-25-2013 06:09 AM by MacPhotoBiker.)
Post: #7
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
Hi Phil,
actually I believe I found a way how to reproduce the error. This is what I did:

- New webERP installation
- Created a new "Financed" account "3510 - Whatever"
- Posted an amount with date 1/1/2013 to this account as "credit" and another random account in "debit"
- Run Trial Balance January - January: Amount shows correctly in "Month Actual" and "Period Actual"
- Run Trial Balance January - February: Amount shows correctly in "Period Actual" and correctly not in "Month Actual"
- !!! Run Trial Balance from January - March/April: Account shows "0"

Then, I posted again on the same account 3510 with date 1/1/2013, and the amount of the second posting would always show correctly, but still the first posting is missing when the Trial Balance is run from January to March/ April.

Then, I created another account and posted an amount, but with current date. This amount would always show correctly.

Or in a nutshell: I believe the problem is related to the first posting of a newly created account when the posting date lies before the current date (or period).

I tried several times, and it´s consistently behaving the same way.

I hope this helps.

MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
Find all posts by this user
Quote this message in a reply
04-25-2013, 12:30 PM
Post: #8
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
Well I just tried this and it works for me ... what version of the code are you running??

I will try again - posting back to 1990 or something silly - maybe it is when we post back to a period before which currenly periods don't exist for.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-25-2013, 01:04 PM
Post: #9
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
Well you can't post back before the date in the configuration parameter "prohibit GL postings before" so maybe this parameter is not set on a new install - is it happening on only a new install?

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
04-25-2013, 01:04 PM (This post was last modified: 04-25-2013 01:13 PM by MacPhotoBiker.)
Post: #10
RE: Initial Balance for acct. 3510 Historical Balance not showing in Trial Balance
I tried several times as well, and it's absolutely consistent on my end. This is my environment:

webERP: 4.10.1 (My real version was updated from former version, but yesterday's demo installation was a clean new installation).
LAMP:
OS: CENTOS 6.4 x86_64 kvm (VPS Server)
WebServer: Apache 2.2.24
MySQL: 5.5
PHP: 5.3.24

Would you like access to my demo installation, so you could try yourself?

Maybe somebody else in the forum could share some experiences, too?
(04-25-2013 01:04 PM)phil Wrote:  Well you can't post back before the date in the configuration parameter "prohibit GL postings before" so maybe this parameter is not set on a new install - is it happening on only a new install?

Well, so far I only tried on new installations. If I do an immediate second posting, the second one will show correctly, but the first one doesn't.

Where exactly could I verify the parameter you mentioned?

The situation is that I want to set up webERP for a customer that has some real world transactions already. Now it's April, but we wanted to post opening balances as per 1st of January. The date, I just picked from the calender in the date field.



Just double and triple checked. First posting will not show, but second does.

MacPhotoBiker
Just Core Business Inc.
[url]http://www.justcorebusiness.com[/url]
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)