Solved:Initial Balance for acc. 3510 Historical Balance not showing in Trial Balance

[MacPhotoBiker]

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!

[phil]

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 :-(

[MacPhotoBiker]

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

[phil]

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!

[MacPhotoBiker]

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.

[phil]

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.

[MacPhotoBiker]

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.

[phil]

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]

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?

[MacPhotoBiker]

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?

---

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.