section id 0 possible

View: New views
4 Messages — Rating Filter:   Alert me  

section id 0 possible

by Manuel Ohnemus :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Nathan,

me and my wife are just trying to get german accouting into perp. My wife says standard german accounting doesn't start at 1 but at 0. So she would need the possibility to create something like this in account_section:

section id = 0, section name = Anlagevermögen

Perp only allows id's starting from 1 but I could inset 0 directly into the database and this seems to work so far.

This would also apply to account_groups and accounts. Do you think this is possible?

Re: section id 0 possible

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 14-May-08, at 3:31 PM, Manuel Ohnemus wrote:

>
> Hi Nathan,
>
> me and my wife are just trying to get german accouting into perp. My  
> wife
> says standard german accounting doesn't start at 1 but at 0. So she  
> would
> need the possibility to create something like this in account_section:
>
> section id = 0, section name = Anlagevermögen
>
> Perp only allows id's starting from 1 but I could inset 0 directly  
> into the
> database and this seems to work so far.
>
> This would also apply to account_groups and accounts. Do you think  
> this is
> possible?

Ug.  In PHP empty() returns true for 0 and null, so an account ID of 0  
would fail many of the checks with errors like "Missing GL account".
Sections & groups might work, I think the worst for them would be that  
filters using the 0 records wouldn't work, so if you tried to show all  
the accounts in group 0, you would get all the accounts instead.

You should be able to use any other integer, but that doesn't help.
I guess, I advise against it, but you can give it a shot and let us  
know what happens.

Nathan Gray
nathan at goarctic dot com


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers

Re: section id 0 possible

by Manuel Ohnemus :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

>Ug.  In PHP empty() returns true for 0 and null, so an account ID of 0  
>would fail many of the checks with errors like "Missing GL account".
>Sections & groups might work, I think the worst for them would be that  
>filters using the 0 records wouldn't work, so if you tried to show all  
>the accounts in group 0, you would get all the accounts instead.

>You should be able to use any other integer, but that doesn't help.
>I guess, I advise against it, but you can give it a shot and let us  
>know what happens.

O.K. In order not to run into any unneccesary trouble we replaced 0 by 10 and created accounts like 0110 as 110. I think 0110 won't be possible anyway. We can have a look at this if we understand more of perp.

BTW: It is quite hard to talk my wife into having a look at anything different than $MOST_FAMOUS_GERMAN_ACCOUTING_BLOATWARE_RUNNING_ONLY_ON_WINDOWS. And even harder if anything doesn't look as expected. But she likes egw and she likes the integration of perp into it so she is testing the accounting part wich I have no idea of.

Re: section id 0 possible

by Nathan Gray :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 17-May-08, at 2:34 PM, Manuel Ohnemus wrote:

> O.K. In order not to run into any unneccesary trouble we replaced 0  
> by 10
> and created accounts like 0110 as 110. I think 0110 won't be possible
> anyway. We can have a look at this if we understand more of perp.


You are correct, it will be stored as 110, not 0110.

I look forward to hearing about if you can get pERP to pass the "wife  
test".

Nathan Gray
nathan at goarctic dot com


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers
LightInTheBox - Buy quality products at wholesale price