General ledger credit/debit problem

bverburg 2007-07-25 19:20:29 UTC #1

Hi,
I installed the latest version on Monday. Thanks for keeping things current!

I may have found a problem on the main page of the General Ledger. After
entering a transaction of say a debit $500 and a credit of $500, the
main page shows the debit and credit reversed. If you click the
transaction number to view the transaction detail, that page shows them
correct. They have been saved to the database correctly so there are no
problems there. I’ve attached a screen shot so that you can see what I
mean (if you can’t see it let me know and I’ll post it on the web). Is
it possible that my currency settings could be affecting this? My US
Dollar preference is set to “-1,200.03 [red].” This was happening before
I upgraded to the new version as well.

Helpful Hint: In my perp preferences I didn’t have a report output
format selected so it was throwing a bunch of errors at me in the
downloaded file. Once I selected OpenOffice.org everything worked fine.
Hopefully this will help someone in the future. (Nathan, I upgraded to
php 5.2.3 with zip enabled and that cured the ZipArchive problem. Thanks!)

Another question…When I click on “Trial Balance” in the left menu it
takes me to Home. I believe I have all the permissions setup to view the
trial balance. Any reason why the link might not work? The link is
supposed to go to: index.php?menuaction=perp_ledger.uireport.trial_balance

Ok, one more question/suggestion…are you all thinking about getting a
forum? Personally, I find the wiki and sourceforge hard to navigate. I’d
be happy to help set one up in my spare time. Just let me know!

Thanks in advance for your help!

Have a great day,
Barb

Nathan_Gray-2 2007-07-25 20:10:22 UTC #2

Hi,
I installed the latest version on Monday. Thanks for keeping things
current!

I may have found a problem on the main page of the General Ledger.
After entering a transaction of say a debit $500 and a credit of
$500, the main page shows the debit and credit reversed. If you
click the transaction number to view the transaction detail, that
page shows them correct. They have been saved to the database
correctly so there are no problems there. I’ve attached a screen
shot so that you can see what I mean

Ok, I see a few problems with that. Thanks for reporting it, I’ll
dig into it. That issue has been a thorn in my side for a long time…
I’d appreciate knowing the settings for the general ledger account
groups that those accounts are in. (Increase / Decrease)

Is it possible that my currency settings could be affecting this?
My US Dollar preference is set to “-1,200.03 [red].” This was
happening before I upgraded to the new version as well.

No, it’s not the currency. That just changes how they’re shown.

Helpful Hint: In my perp preferences I didn’t have a report output
format selected so it was throwing a bunch of errors at me in the
downloaded file. Once I selected OpenOffice.org everything worked
fine. Hopefully this will help someone in the future. (Nathan, I
upgraded to php 5.2.3 with zip enabled and that cured the
ZipArchive problem. Thanks!)

I’ve added those tips to the FAQ to help those in the future.

Another question…When I click on “Trial Balance” in the left menu
it takes me to Home. I believe I have all the permissions setup to
view the trial balance. Any reason why the link might not work? The
link is supposed to go to: index.php?
menuaction=perp_ledger.uireport.trial_balance

Whoops. I removed that file a long time ago. I’ve removed the link.
I could re-direct it to the new trial balance report and add the
other reports, but I have no way of knowing how long the list of
reports could get.

Ok, one more question/suggestion…are you all thinking about
getting a forum? Personally, I find the wiki and sourceforge hard
to navigate. I’d be happy to help set one up in my spare time. Just
let me know!

I appreciate the offer. The majority of the wiki was written by me,
so I welcome suggestions for improvement (or people improving it
directly). The main page could sure use some help.

Most of what gets discussed is here on the developer’s mailing list.
I don’t think there’s enough discussion going on yet to make a
separate forum worth the effort and duplication.
Nabble provides a nice forum-like interface to the mailing list if
you prefer:
http://www.nabble.com/Project-ERP-(pERP)---Developers-f21421.html
but it doesn’t have the full archive.

Nathan Gray
nathan at goarctic dot com

This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

bverburg 2007-07-25 20:42:10 UTC #3

Nathan Gray wrote:

Hi,
I installed the latest version on Monday. Thanks for keeping things
current!

I may have found a problem on the main page of the General Ledger.
After entering a transaction of say a debit $500 and a credit of
$500, the main page shows the debit and credit reversed. If you click
the transaction number to view the transaction detail, that page
shows them correct. They have been saved to the database correctly so
there are no problems there. I’ve attached a screen shot so that you
can see what I mean

Ok, I see a few problems with that. Thanks for reporting it, I’ll dig
into it. That issue has been a thorn in my side for a long time…
I’d appreciate knowing the settings for the general ledger account
groups that those accounts are in. (Increase / Decrease)

They’re both “Credit Decreases.” I hope that helps. I have no idea what
that means. I’m definitely not an accountant!

Is it possible that my currency settings could be affecting this? My
US Dollar preference is set to “-1,200.03 [red].” This was happening
before I upgraded to the new version as well.

No, it’s not the currency. That just changes how they’re shown.

Helpful Hint: In my perp preferences I didn’t have a report output
format selected so it was throwing a bunch of errors at me in the
downloaded file. Once I selected OpenOffice.org everything worked
fine. Hopefully this will help someone in the future. (Nathan, I
upgraded to php 5.2.3 with zip enabled and that cured the ZipArchive
problem. Thanks!)

I’ve added those tips to the FAQ to help those in the future.

Cool.

Another question…When I click on “Trial Balance” in the left menu it
takes me to Home. I believe I have all the permissions setup to view
the trial balance. Any reason why the link might not work? The link
is supposed to go to:
index.php?menuaction=perp_ledger.uireport.trial_balance

Whoops. I removed that file a long time ago. I’ve removed the link.
I could re-direct it to the new trial balance report and add the other
reports, but I have no way of knowing how long the list of reports
could get.
I think it’d probably be easier to get rid of it. Or you could put a
link to each of the report pages where the user could select their
report options. It doesn’t matter to me.

Ok, one more question/suggestion…are you all thinking about getting
a forum? Personally, I find the wiki and sourceforge hard to
navigate. I’d be happy to help set one up in my spare time. Just let
me know!

I appreciate the offer. The majority of the wiki was written by me,
so I welcome suggestions for improvement (or people improving it
directly). The main page could sure use some help.

Most of what gets discussed is here on the developer’s mailing list.
I don’t think there’s enough discussion going on yet to make a
separate forum worth the effort and duplication.
Nabble provides a nice forum-like interface to the mailing list if you
prefer:
http://www.nabble.com/Project-ERP-(pERP)---Developers-f21421.html
but it doesn’t have the full archive.
I might take you up on the offer to improve the wiki… it may just need
a little reorganization. I’ll think it through and email you. Did you
write all the PDF documentation? Those are so helpful! It’s one of the
reasons we switched from going with Ledger-SMB to Project ERP.

We’re starting our accounting entries from January 1, 2007. Is there a
way to set up the beginning balance? I am told that this balance effects
about 20 accounts. Our accountant was trying to enter the beginning
balance via the General Ledger Journal Entry, but he couldn’t get this
to work because (I believe) you need to enter a balanced transaction.
Please let me know if you need more information.

Thanks,
Barb

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Nathan_Gray-2 2007-07-25 21:21:33 UTC #4

They’re both “Credit Decreases.” I hope that helps. I have no idea
what that means. I’m definitely not an accountant!

Accountants do a strange thing. To a math person, we tend to
associate credit = +, debit = -. Or the other way, depending on
which side of the banking industry you’re on.
It turns out that’s the way it works, most of the time. Asset
accounts are the opposite: credit = -, debit = +. Meaning if you
start with a balance of 0, and credit $100, you may have a balance of
+/- $100, depending on the type of account. It makes things
interesting when you’re trying to map credit and debit to math,
because the functions change!
This is the reason behind the credits & debits being in the wrong
column.

I might take you up on the offer to improve the wiki… it may just
need a little reorganization. I’ll think it through and email you.

I agree, and look forward to it.

Did you write all the PDF documentation? Those are so helpful! It’s
one of the reasons we switched from going with Ledger-SMB to
Project ERP.

I can’t take credit for those. Our communications officer wrote &
maintains them, so I passed your praise along.

We’re starting our accounting entries from January 1, 2007. Is
there a way to set up the beginning balance? I am told that this
balance effects about 20 accounts. Our accountant was trying to
enter the beginning balance via the General Ledger Journal Entry,
but he couldn’t get this to work because (I believe) you need to
enter a balanced transaction. Please let me know if you need more
information.

Hm. That’s interesting, nobody’s asked that before. Our accountant
always said transactions must be balanced…
I may need to add something of the sort.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Nathan_Gray-2 2007-07-26 21:59:20 UTC #5

Ok, that transaction list was quite broken, and a lot more
complicated than it needed to be.
Should be fixed up now.

Also, when entering a new general ledger account, you can set the
opening balance for it.

Thanks for finding and reporting those.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

bverburg 2007-08-01 19:49:26 UTC #6

Hey Nathan,
Hope all is going well. Have you had a chance to work on the
credit/debit display in the General Ledger? I know you’re probably busy
but I just wanted to check. Thanks!

Have a great day,
Barb

They’re both “Credit Decreases.” I hope that helps. I have no idea
what that means. I’m definitely not an accountant!

Accountants do a strange thing. To a math person, we tend to
associate credit = +, debit = -. Or the other way, depending on which
side of the banking industry you’re on.
It turns out that’s the way it works, most of the time. Asset
accounts are the opposite: credit = -, debit = +. Meaning if you
start with a balance of 0, and credit $100, you may have a balance of
+/- $100, depending on the type of account. It makes things
interesting when you’re trying to map credit and debit to math,
because the functions change!
This is the reason behind the credits & debits being in the wrong column.

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Nathan_Gray-2 2007-08-01 20:10:33 UTC #7

Hey Nathan,
Hope all is going well. Have you had a chance to work on the credit/
debit display in the General Ledger? I know you’re probably busy
but I just wanted to check. Thanks!

Have a great day,
Barb

Yes, it’s been fixed. SVN Revision #1139.
If you’re using a package release instead of SVN, you’ll need to wait
until the next release.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

bverburg 2007-08-01 20:18:45 UTC #8

Wonderful! Thanks! When might the next version be released?

Barb

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers

Nathan_Gray-2 2007-08-02 17:05:28 UTC #9

Wonderful! Thanks! When might the next version be released?

It might be released some time this month, maybe toward the end of
the month.

Nathan Gray
nathan at goarctic dot com

Perp-developers mailing list
Perp-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/perp-developers