Notes and doubts about GL

[PCS-Lists]

Nathan,

I observed some things about GL and would like to confirm if they are correct/true. Beyond this, I have some doubts to clear.

1) Is not possible to add two GL account_groups with the same name, despite belong to different sessions of accounts; (Can you change it?Is it complicated?)

2) The bank account number can't be composed by nothing beyond numbers, is it correct?

3) When add an entry (GL>>Journal Entry or Bank Transaction) the decimal separator is dot, but in Brazil we use comma. How can I change it?(In preferences>>perp_api the currency format is set "1200,03")

4)How can I view the current balance of a bank account or GL account. Is there a way to show it when adding new transactions?

Thank you so much for help.

Regards

[Nathan Gray]

On 11-Mar-09, at 7:54 AM, PCS-Lists wrote:

> 1) Is not possible to add two GL accounts with the same name,  
> despite belong
> to different groups of accounts; (Can you change it?Is it  
> complicated?)

It is possible to add two GL accounts with the same name, even in the  
same group, as long as the GL account number is different.  It does  
become hard to tell the difference between them though.

> 2) The bank account number can't be composed by nothing beyond  
> numbers, is
> it correct?

No.  The bank account number (not GL account number) is alphanumeric.

> 3) When add an entry (GL>>Journal Entry or Bank Transaction) the  
> decimal
> separator is dot, but in Brazil we use comma. How can I change it?(In
> preferences>>perp_api the currency format is set "1200,03")

Where exactly?
When I changed my currency format (CAD) to 1200,03, the debit& credit  
columns, as well as debit & credit total, and transaction balance were  
all changed to match.

> 4)How can I view the current balance of a bank account or GL account.

Side menu -> chart of accounts

> Is
> there a way to show it when adding new transactions?

Not implemented, but possible.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>It is possible to add two GL accounts with the same name, even in the  
>same group, as long as the GL account number is different.  It does  
>become hard to tell the difference between them though.

I tried to add two groups of accounts with the name TEST ACCOUNT with different numbers and the message "settings saved" appeared, but not the groups of accounts.

 
>No.  The bank account number (not GL account number) is alphanumeric

I tried to add bank accounts with the number 12345-X and 12345X and the message "settings saved" appeared, but not the bank accounts


>When I changed my currency format (CAD) to 1200,03, the debit& credit  
>columns, as well as debit & credit total, and transaction balance were  
>all changed to match.

In any place where I write numbers with decimal using comma the decimal places are not recorded.
Example: if I write 250,85 appear only 250,00, but if I write 250.85 it works!


mores doubts:

5) How can I make transfers from a bank account to another? In GL>>bank transactions>>add new line>>account#, the list of accounts showed not contains the GL accounts related to bank accounts.

6) When I add new transactions in GL>>Journal Entry and click in Post Transaction, nothing happens. No erros on apache log or messages on screen.
In another test base of perp, making the same thing appear the message below:

Fatal error: Call to a member function set_transaction_type() on a non-object in /home/perp/public_html/egroupware/perp_ledger/inc/class.ui_perp_ledger.inc.php on line 184

Can you help me?

[Nathan Gray]

On 11-Mar-09, at 11:18 AM, PCS-Lists wrote:

>
>> It is possible to add two GL accounts with the same name, even in the
>> same group, as long as the GL account number is different.  It does
>> become hard to tell the difference between them though.
>
> I tried to add groups of accounts

You asked about adding two GL accounts with the same name, not adding  
groups of accounts.
You cannot have two groups of accounts with the same name, even if  
they are in different sections.

> In any place where I write numbers with decimal using comma the  
> decimal
> places are not recorded.
> Example: if I write 250,85 appear only 250,00, but if I write 250.85  
> it
> works!

Please file a bug report with all the information, and some specific  
examples.  There are several systems to be investigated.

> One more thing: When I add new transactions in GL>>Journal Entry and  
> click
> in Post Transaction, nothng happens. No erros on apache log or  
> messages on
> screen.

Someone will look into this soon.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

Notes and doubts about GL
Click to flag this post


>You asked about adding two GL accounts with the same name, not adding  
>groups of accounts.

by PCS-Lists Mar 11, 2009; 10:54am
1) Is not possible to add two GL account_groups with the same name, despite belong to different sessions of accounts; (Can you change it?Is it complicated?)


>Please file a bug report with all the information, and some specific  
>examples.  There are several systems to be investigated.

Bug report created: http://www.projecterp.org/cgi-bin/trac.cgi/ticket/412


>Someone will look into this soon.

ok. I will wait.


Thanks for explanations. You, as always, helped so much.
Regards.

[Nathan Gray]

On 12-Mar-09, at 9:28 AM, PCS-Lists wrote:

>> You asked about adding two GL accounts with the same name, not adding
>> groups of accounts.
>
> by PCS-Lists Mar 11, 2009; 10:54am
> 1) Is not possible to add two GL account_groups with the same name,  
> despite
> belong to different sessions of accounts; (Can you change it?Is it
> complicated?)


Something's going very strange here.

Your email, according to sourceforge archive, and as delivered to me:
http://sourceforge.net/mailarchive/message.php?msg_name=22455595.post%40talk.nabble.com

Your email, according to nabble.com:
http://www.nabble.com/Notes-and-doubts-about-GL-td22455595.html#a22478285

I have filed a support ticket with sourceforge.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

I believe it don't mind. The important is that you helped me to understand.
Thanks once more.

Regards.

Nathan Gray wrote:

On 12-Mar-09, at 9:28 AM, PCS-Lists wrote:

>> You asked about adding two GL accounts with the same name, not adding
>> groups of accounts.
>
> by PCS-Lists Mar 11, 2009; 10:54am
> 1) Is not possible to add two GL account_groups with the same name,  
> despite
> belong to different sessions of accounts; (Can you change it?Is it
> complicated?)


Something's going very strange here.

Your email, according to sourceforge archive, and as delivered to me:
http://sourceforge.net/mailarchive/message.php?msg_name=22455595.post%40talk.nabble.com

Your email, according to nabble.com:
http://www.nabble.com/Notes-and-doubts-about-GL-td22455595.html#a22478285

I have filed a support ticket with sourceforge.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

Nathan,

This doubt I still have?

 How can I make transfers from a bank account to another? In GL>>bank transactions>>add new line>>account#, the list of accounts showed not contains the GL accounts related to bank accounts.



Can you help me?

[Nathan Gray]

On 16-Mar-09, at 12:34 PM, PCS-Lists wrote:

> How can I make transfers from a bank account to another?

I'm not sure.
Try a regular journal entry, that might do it.
Double check in the table perp_bank_ledger to make sure both ledgers  
are updated correctly.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>Try a regular journal entry, that might do it.

Journal entry is unable to make a withdraw from a bank account to deposit on another. Does it mean that will be necessary to make this in 2 steps: first a withdraw and after a deposit?
Don't it be unproductive?
Is really it?
Thanks


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Nathan Gray]

On 18-Mar-09, at 8:49 AM, PCS-Lists wrote:

>
>> Try a regular journal entry, that might do it.
>
> Journal entry is unable to make a withdraw from a bank account to  
> deposit on
> another.

?
Worked fine for me.
It even correctly calculated the CAD -> EUR exchange in the bank  
ledger (1.603 gives 31.19 Euro).

Date 2009/03/18
Account # Debit Credit Narrative
104000 - Bank- Montreal 50,00 Credit 50
105500 - Bank of Montreal - Euros 50,00 Debit 50
Transaction Balance: ~ Balanced ~ 50,00 50,00

57 104000 1.000 0 -50.00 CAD 0
57 105500 1.603 0 31.19 EUR 1

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[Nathan Gray]

On 11-Mar-09, at 11:31 AM, Nathan Gray wrote:

>> In any place where I write numbers with decimal using comma the
>> decimal
>> places are not recorded.
>> Example: if I write 250,85 appear only 250,00, but if I write 250.85
>> it
>> works!
>
> Please file a bug report with all the information, and some specific
> examples.  There are several systems to be investigated.

I'm not sure if the ticket system sends emails, but this should be  
fixed.
It will happen again in other places, please report them as you find  
them.

>> One more thing: When I add new transactions in GL>>Journal Entry and
>> click
>> in Post Transaction, nothng happens. No erros on apache log or
>> messages on
>> screen.
>
> Someone will look into this soon.

Should be fixed.  Also, you can't even try to post an unbalanced  
transaction anymore.

Nathan Gray
nathan at goarctic dot com


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

[PCS-Lists]

Hi Nathan,

All working.

Thanks and regards

[PCS-Lists]

Nathan,

I would like to return to talk about bank transactions / journal entries.
What's the essential difference between both functions of this applications?
In wich cases should I to use one or another?
Doesn't should be the bank transactions (like explains the name) be able to do transfers between two bank accounts?

Can you help me about this?
Thanks and regards.

[Nathan Gray]

On 6-May-09, at 7:29 AM, PCS-Lists wrote:

> I would like to return to talk about bank transactions / journal  
> entries.
> What's the essential difference between both functions of this  
> applications?
>

It's been a while , but I think the main difference is desired purpose.
The timeline went something like:

- A regular journal entry can involve any GL account, that doesn't  
involve a sub-ledger (Bank Account, AP, AR, Payroll).
- A special bank transaction function was requested to be able to do  
transactions involving a (one) bank account.
- Journal entries were extended to be able to handle bank accounts  
automatically, but still can't handle AP, AR, Payroll.

Bank transactions are a little simpler, in that they automatically  
balance, and they specify the currency conversion, but they've been  
largely replaced by transparently adding the functionality into the  
journal entry.

> In wich cases should I to use one or another?

Use the Bank Transaction if you like the interface, and are working  
with a single bank account.
Use the journal entry for everything.

> Doesn't should be the bank transactions (like explains the name) be  
> able to
> do transfers between two bank accounts?

Possibly.  That wasn't in my original specifications, so it didn't get  
coded.  It's probably easier to make the Bank Transactions part go  
away, because journal entries should be able to do everything, and  
more, that Bank Transactions can.

If you're feeling adventurous, you can remove perp_ledger/inc/
class.ui_perp_ledger.inc.php line 400, and test Bank Transactions with  
multiple bank accounts.

I hope that answers your questions, but if not, please continue to ask.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

Nathan Gray wrote:

On 11-Mar-09, at 11:31 AM, Nathan Gray wrote:

>> In any place where I write numbers with decimal using comma the
>> decimal
>> places are not recorded.
>> Example: if I write 250,85 appear only 250,00, but if I write 250.85
>> it
>> works!
>

I'm not sure if the ticket system sends emails, but this should be  
fixed.
It will happen again in other places, please report them as you find  
them.

Nathan,

in perp_ap>>payments,when I write decimal places using comma, the decimal places are not recorded. The same problem related above for General Ledger.
Can you help me?Thanks
Can you help me?Thanks

[Nathan Gray]

On 12-May-09, at 6:47 AM, PCS-Lists wrote:

> in perp_ap>>payments,when I write decimal places using comma, the  
> decimal
> places are not recorded. The same problem related above for General  
> Ledger.

Referenced change is SVN rev. 3253

Similar changes made in rev. 3477, please try them out.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>Referenced change is SVN rev. 3253
>Similar changes made in rev. 3477, please try them out.

pERP rev 3480

perp_ledger>>journal entry works fine with comma
perp_ledger>>bank_transactions is not working with comma. If I write 250,30 , only 250,00 is showed, but with dot works!
perp_ap>>payments not working with comma. If I write 250,30 the valeu showed in "total payment" is 0,00 , but with dot it works!

[Nathan Gray]

On 14-May-09, at 7:25 AM, PCS-Lists wrote:
> perp_ledger>>journal entry works fine with comma
> perp_ledger>>bank_transactions is not working with comma.

Done

> perp_ap>>payments not working with comma. If I write 250,30 the  
> valeu showed
> in "total payment" is 0,00 , but with dot it works!

I don't have a javascript parser.
Please file a ticket, I'll see what I can do.
Until then, you'll have to total manually.

Nathan Gray
nathan at goarctic dot com


------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image
processing features enabled. http://p.sf.net/sfu/kodak-com
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

[PCS-Lists]

>I don't have a javascript parser.
>Please file a ticket, I'll see what I can do.
>Until then, you'll have to total manually.

I created tickets for this on AR an on AP:

http://www.projecterp.org/cgi-bin/trac.cgi/ticket/417
http://www.projecterp.org/cgi-bin/trac.cgi/ticket/418