web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] Replicating slashes problem - escaping special chars for database insertion or HTML

[Tim S. <tim...@gm...>]

Hi Jo,

I thought we had caught and dealt with these. Can you give some
examples of where it is still happening?

Thanks
Tim

On 27 November 2013 06:57, iced lava <ice...@gm...> wrote:
> Currently we have sessions.inc processing all session, post and get vars in
> the same way.
>
> We make a big assumption here with DB_escape_string at line 59 and 66 (for
> single var and slightly different for arrays):
>
> $_POST[$PostVariableName] = DB_escape_string($PostVariableValue);
>
> This assumes that we know what a function will do with the post/get/sessions
> vars and that they are going to be inserted/updated to a database. They are
> passed to the DB_escape_string function which returns (for mysqli):
>
> mysqli_real_escape_string($db, htmlspecialchars($String, ENT_COMPAT,'utf-8',
> false));
>
> This is causing exponential slash addition to variables which are not
> entered to a database but instead posted to a HTML field value. Each time
> the field is updated the value is saved in the database with extra slashes
> when escaping a special char like a single quote.
>
> If we do actually need to do this variable processing in sessions.inc then
> perhaps we could  decide what is more common  displaying the var or
> insert/updating to a db.
>
> If we chose for example that displaying the var on the page is more common
> then we should change sessions inc for example on this line:
>
> $_POST[$PostVariableName] = DB_escape_string($PostVariableValue)
>
> to
> $_POST[$PostVariableName]= htmlspecialchars($PostArrayValue,
> ENT_QUOTES,'UTF-8');
>
> and for this case in DB_escape_string from:
>
> return mysqli_real_escape_string($db, htmlspecialchars($String,
> ENT_COMPAT,'utf-8', false));
> to
>
> return mysqli_real_escape_string($db, htmlspecialchars_decode($String,
> ENT_COMPAT));
>
>
> Then we need to call DB_escape_string on vars before we send to any insert
> or edit for database.
>
> On the other hand - we need to do the opposite if we assume it is more
> likely to post to the database.
>
> Perhaps there is another 3rd way to handle it?
>
> Thanks to all in advance for any feedback!!
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T   +256 (0) 312 314 418
M +256 (0) 752 963 325
www.weberpafrica.com
Twitter: @TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk/

Re: [WebERP-developers] Replicating slashes problem - escaping special chars for database insertion or HTML

[Phil D. <ph...@lo...>]

Looks like you are onto this one!! Yes this makes sense... I think you 
have identified the source of the problem... BUT where a $_POST is used 
as a criteria to some SQL we need the mysqli_escape_string to avoid any 
shenanigans with clever sods messing with the SQL to return stuff they 
shouldn't be looking at.
This function is a bit of a sledge hammer approach. Maybe we need to 
identify the variables where it is going wrong - I don't see it much.... 
although I have seen it before in descriptions I think - and perhaps we 
could strip slashes or similar.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 19:57, iced lava wrote:
> Currently we have sessions.inc processing all session, post and get 
> vars in the same way.
>
> We make a big assumption here with DB_escape_string at line 59 and 66 
> (for single var and slightly different for arrays):
>
> $_POST[$PostVariableName] = DB_escape_string($PostVariableValue);
>
> This assumes that we know what a function will do with the 
> post/get/sessions vars and that they are going to be inserted/updated 
> to a database. They are passed to the DB_escape_string function which 
> returns (for mysqli):
>
> mysqli_real_escape_string($db, htmlspecialchars($String, 
> ENT_COMPAT,'utf-8', false));
>
> This is causing exponential slash addition to variables which are not 
> entered to a database but instead posted to a HTML field value. Each 
> time the field is updated the value is saved in the database with 
> extra slashes when escaping a special char like a single quote.
>
> If we do actually need to do this variable processing in sessions.inc 
> then perhaps we could  decide what is more common  displaying the var 
> or insert/updating to a db.
>
> If we chose for example that displaying the var on the page is more 
> common then we should change sessions inc for example on this line:
>
> $_POST[$PostVariableName] = DB_escape_string($PostVariableValue)
>
> to
> $_POST[$PostVariableName]= htmlspecialchars($PostArrayValue, 
> ENT_QUOTES,'UTF-8');
>
> and for this case in DB_escape_string from:
>
> return mysqli_real_escape_string($db, htmlspecialchars($String, 
> ENT_COMPAT,'utf-8', false));
> to
>
> return mysqli_real_escape_string($db, htmlspecialchars_decode($String, 
> ENT_COMPAT));
>
>
> Then we need to call DB_escape_string on vars before we send to any 
> insert or edit for database.
>
> On the other hand - we need to do the opposite if we assume it is more 
> likely to post to the database.
>
> Perhaps there is another 3rd way to handle it?
>
> Thanks to all in advance for any feedback!!
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

[WebERP-developers] Replicating slashes problem - escaping special chars for database insertion or HTML

[iced l. <ice...@gm...>]

Currently we have sessions.inc processing all session, post and get vars in
the same way.

We make a big assumption here with DB_escape_string at line 59 and 66 (for
single var and slightly different for arrays):

$_POST[$PostVariableName] = DB_escape_string($PostVariableValue);

This assumes that we know what a function will do with the
post/get/sessions vars and that they are going to be inserted/updated to a
database. They are passed to the DB_escape_string function which returns
(for mysqli):

mysqli_real_escape_string($db, htmlspecialchars($String,
ENT_COMPAT,'utf-8', false));

This is causing exponential slash addition to variables which are not
entered to a database but instead posted to a HTML field value. Each time
the field is updated the value is saved in the database with extra slashes
when escaping a special char like a single quote.

If we do actually need to do this variable processing in sessions.inc then
perhaps we could  decide what is more common  displaying the var or
insert/updating to a db.

If we chose for example that displaying the var on the page is more common
then we should change sessions inc for example on this line:

$_POST[$PostVariableName] = DB_escape_string($PostVariableValue)

to
$_POST[$PostVariableName]= htmlspecialchars($PostArrayValue,
ENT_QUOTES,'UTF-8');

and for this case in DB_escape_string from:

return mysqli_real_escape_string($db, htmlspecialchars($String,
ENT_COMPAT,'utf-8', false));
to

return mysqli_real_escape_string($db, htmlspecialchars_decode($String,
ENT_COMPAT));


Then we need to call DB_escape_string on vars before we send to any insert
or edit for database.

On the other hand - we need to do the opposite if we assume it is more
likely to post to the database.

Perhaps there is another 3rd way to handle it?

Thanks to all in advance for any feedback!!

Re: [WebERP-developers] Closing balances - bank accounts

[Phil D. <ph...@lo...>]

I think the fix needs to be in the GLJournalInquiry.php so it shows the 
journals created correctly.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 19:52, iced lava wrote:
> > It is not necessary to modify the transaction type in the gltrans table.
>
> To see the bank transactions in the general journal enquiries we do.
>
> >Can you point me to where the manual said the integration should be 
> off when taking on GL balances?
> I will take another look and let you know - i know i found it 
> confusing when i first used webERP and went on a google hunt. It's 
> been some time since i looked at that part of the manual and i've 
> always turned on GL for bank transactions and off for everything else 
> added through the General Ledger menu.
>
> > Which listings are you not able to see the balances ... script names 
> ideally please
> GLJournalInquiry.php - will not display bank transaction journals.
>
> And yes, trial balance shows balances correctly :)
>
> Thanks for taking a look.
>
>
> On Wed, Nov 27, 2013 at 5:09 PM, Phil Daintree <ph...@lo... 
> <mailto:ph...@lo...>> wrote:
>
>     It is not necessary to modify the transaction type in the gltrans
>     table.
>     Can you point me to where the manual said the integration should
>     be off when taking on GL balances? I can see where it says this in
>     relation to setting up debtors and creditors balances i.e the open
>     items in the sub-ledgers.
>     Which listings are you not able to see the balances ... script
>     names ideally please. Maybe this is where the problem lies -
>     assuming the trial balance shows the balances correctly!
>
>
>     Phil
>
>     Phil Daintree
>     Logic Works Ltd -+64 (0)275 567890  <tel:%2B64%20%280%29275%20567890>
>     http://www.logicworks.co.nz
>
>     On 27/11/13 15:23, iced lava wrote:
>>     Provisos and issue remaining:
>>
>>     1. The opening balance transaction in the example with GL trans
>>     should occur with GL turned off (if instructions in manual are
>>     correct)
>>
>>     2. The behaviour cannot be applied generally to transactions
>>     through General Ledger unless the these transactions are
>>     displayed, such as bank fees, in the bank reconcilliation
>>     listings. They do not display when type is set to 0 (general
>>     journal) in the gltrans table and so fix should be determined for
>>     the reconcilliation functions.
>>
>>     Comments appreciated.
>>
>>     Thanks,
>>
>>
>>
>>     On Wed, Nov 27, 2013 at 12:44 PM, iced lava <ice...@gm...
>>     <mailto:ice...@gm...>> wrote:
>>
>>         As an example:
>>         I note that if I enter the bank balances at 30 June with GL
>>         on, I can change the Type of transaction in the gltrans table
>>         to 0 (general journal). Appropriate [next] incremented
>>         general journal numbers a can provided to these transactions
>>         by editing as well [and systype incremented accordingly and
>>         chart detail also adjusted].
>>
>>         If this is done then the year closing journals appear as
>>         required in the journal listings, on the trial balance and
>>         the bank listings and reports also seem correct (transactions
>>         are left untouched in banktrans table).
>>
>>
>>         This is as expected for the entry made through General Ledger
>>         bank receipts.
>>
>>
>>         Is this a bug?
>>         Should this behaviour also happen for other bank receipts and
>>         payments made through General Ledger option? I would think so.
>>
>>         I can fix if required.
>>
>>         Thanks.
>>
>>
>>
>>
>>         On Wed, Nov 27, 2013 at 12:04 PM, iced lava
>>         <ice...@gm... <mailto:ice...@gm...>> wrote:
>>
>>             Could I have confirmation on what should happen when bank
>>             account balances are entered in for end of year closing
>>             balances eg at 30 June.
>>
>>             Here is the current behaviour I see in latest webERP.
>>             Note that usually according to documentation year end
>>             balances should be done with GL integration off.
>>
>>             1. With GL integration turned off, the bank balances are
>>             taken on at 30 June by entering a receipt (General Ledger
>>             - Bank account receipt entry).
>>
>>               * This transaction only appears as a single entry in
>>                 the banktrans table - nowhere else
>>               * there is no corresponding balancing transaction - it
>>                 would have to be made manually
>>               * as such the bank account balances do not appear in
>>                 any 30 June trial balance
>>               * a listing of 30 June journal entries does not show
>>                 any 30 June entries for any bank accounts GL accounts
>>               * trial balance as a consequence does not have any
>>                 entries for these bank transactions
>>
>>
>>             2. With the GL integration turned on - if the bank
>>             balances are taken on at 30 June by entering a receipt
>>             (General Ledger - Bank account receipt entry)
>>
>>               * The transaction appears as an entry in the banktrans
>>                 table
>>               * there is a corresponding transaction in the gltrans
>>                 table and the balancing transaction(s)
>>               * the chartdetails table has entries for these transactions
>>               * trial balance shows an entry for these bank accounts
>>               * the listing of 30 June journal entries does not show
>>                 anything for the bank accounts
>>               * the type in the gltrans table is type 12 - bank
>>                 transaction, not 0 for general journal
>>
>>
>>             This is causing confusing with customer.
>>
>>             The behaviour I thought would happen is that any bank
>>             transactions entered through the General Ledger - Bank
>>             account [receipt/payment] should in fact have entries in
>>             gltrans table and subsequent entries in the chart
>>             details. They then should appear in journal reports.
>>
>>             This would be in contrast to payments/receipts made via
>>             the Payments and Receipts menus for debtors and creditors.
>>
>>             However, for bank fees and such which must be entered
>>             through General Ledger payment (not a creditor), this
>>             poses a problem as the  amounts will show in bank account
>>             transaction listings/reconcilliations - as they should.
>>             Howevrer they will never show as a general journal or
>>             reports as such (they are trans 12 not 0).
>>
>>             Thanks in advance for any advice.
>>
>>             Cheers,
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>     ------------------------------------------------------------------------------
>>     Rapidly troubleshoot problems before they affect your business. Most IT
>>     organizations don't have a clear picture of how application performance
>>     affects their revenue. With AppDynamics, you get 100% visibility into your
>>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
>>     http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>>
>>
>>     _______________________________________________
>>     Web-erp-developers mailing list
>>     Web...@li...  <mailto:Web...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>     ------------------------------------------------------------------------------
>     Rapidly troubleshoot problems before they affect your business.
>     Most IT
>     organizations don't have a clear picture of how application
>     performance
>     affects their revenue. With AppDynamics, you get 100% visibility
>     into your
>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>     AppDynamics Pro!
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>     _______________________________________________
>     Web-erp-developers mailing list
>     Web...@li...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Closing balances - bank accounts

[Phil D. <ph...@lo...>]

Where don't they show up?

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 19:47, iced lava wrote:
> This means that any General Ledger receipt or payments never show up 
> in the journal enquiries which is confusing customers and they cannot 
> get a full idea of for example, what may have gone into  a clearing 
> account at June 30 if bank accounts are involved - they don't display.

Re: [WebERP-developers] Closing balances - bank accounts

[Phil D. <ph...@lo...>]

Well I thought no journals are created in the GL if the debtors GL 
integration is off when entering receipts and no GL journals created 
when entering payments if the GL integration with creditors is turned off.

Type 0 is for GL journals

type 1 is for GL payments
type 2 is for GL receipts

type 12 is for customer receipts
type 22 for creditior/vendor payments

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 19:47, iced lava wrote:
> Hi Phil,
>
> Thanks for the reply, you confirmed what i thought and what I did when 
> I've had to enter bank balances at 30 June.
>
> The GL is off for all other 30 June balance entries which seems 
> perhaps inconsistent and confusing to the customer.
>
> However - given that - there is a problem I think.
>
> With the GL off, you can go into the General Ledger menu and make GL 
> journal entries.
> When adding the bank balance entries - the GL must be on for this even 
> though you still go through the General Ledger menu which implies you 
> are doing general journals (rather than through Payments or Receipts)
>
> The problem is  the bank balances are created with Type 12  bank 
> transaction type -  not type 0 for general journal. This means that 
> any General Ledger receipt or payments never show up in the journal 
> enquiries which is confusing customers and they cannot get a full idea 
> of for example, what may have gone into  a clearing account at June 30 
> if bank accounts are involved - they don't display.
>
> It seems that if the bank transaction is entered through the General 
> Ledger option then it should show up in the general ledger journal 
> listings - but won't.
>
> If I change the GL type to 0 for the bank transactions in the gltrans 
> table, as per my example, and leave the bank transactions as they are 
> in the banktrans table, then everything works as expected. Except of 
> course the bank transactions do not show up in the reconcilliation 
> functions. Everything else is good - correct reports, trial balances etc.
>
> My question is:
> 1. Can we change the code for bank transactions made through the 
> General Ledger option as a journal - to post into the gltrans table as 
> a journal (type 0) to get correct reporting?
> 2. Can we then change the bank reconciliation functions to display 
> journal bank transactions (like bank fees)  that will not display if 
> type 0?
>
> Is it safe to change the code to post bank transactions into the 
> gltrans table as type 0? and what fix then do we need for 
> reconciliation functions? Or - is there another way?
>
> Thanks in advance.
>
>
>
>
>
>
>
> On Wed, Nov 27, 2013 at 5:02 PM, Phil Daintree <ph...@lo... 
> <mailto:ph...@lo...>> wrote:
>
>
>     Phil
>
>     Phil Daintree
>     Logic Works Ltd -+64 (0)275 567890  <tel:%2B64%20%280%29275%20567890>
>     http://www.logicworks.co.nz
>
>     On 27/11/13 14:34, iced lava wrote:
>>     Could I have confirmation on what should happen when bank account
>>     balances are entered in  for end of year closing balances eg at
>>     30 June.
>>
>>     Here is the current behaviour I see in latest  webERP. Note that
>>     usually according to documentation year end balances should be
>>     done with GL integration off.
>>
>
>
>     Nope the GL integration should only be turned off when entering
>     debtors or creditors opening balances by entering open invoices.
>     To enter the GL opening balances the GL integration with debtors
>     needs to be enabled if entering a receipt (or creditors if
>     entering a payment).
>     The trial balance is of course a general ledger thing and
>     naturally you need to have general ledger journals created to have
>     any balances created in the general ledger.
>
>
>
>>     1. With GL integration turned off, the bank balances are taken on
>>     at 30 June by entering a receipt (General Ledger - Bank account
>>     receipt entry).
>>
>>       * This transaction only appears as a single entry in the
>>         banktrans table - nowhere else
>>       * there is no corresponding balancing transaction - it would
>>         have to be made manually
>>       * as such the bank account balances do not appear in any 30
>>         June trial balance
>>       * a listing of 30 June journal entries does not show any 30
>>         June entries for any bank accounts GL accounts
>>       * trial balance as a consequence does not have any entries for
>>         these bank transactions
>>
>>
>>     2. With the GL integration turned on - if the bank balances are
>>     taken on at 30 June by entering a receipt (General Ledger - Bank
>>     account receipt entry)
>>
>>       * The transaction appears as an entry in the banktrans table
>>       * there is a corresponding transaction in the gltrans table and
>>         the balancing transaction(s)
>>       * the chartdetails table has entries for these transactions
>>       * trial balance shows an entry for these bank accounts
>>       * the listing of 30 June journal entries does not show anything
>>         for the bank accounts
>>       * the type in the gltrans table is type 12 - bank transaction,
>>         not 0 for general journal
>>
>>
>     This should work with debtor integration turned on?
>     The balances created on 30 June should flow through to July? With
>     chartdetails showing the bfwd balances
>     The bank balance should reflect the receipt?
>
>     Any screen shots?
>
>>     This is causing confusing with customer.
>>
>>     The behaviour I thought would happen is that any bank
>>     transactions entered through the General Ledger - Bank account
>>     [receipt/payment] should in fact have entries in gltrans table
>>     and subsequent entries in the chart details. They then should
>>     appear in journal reports.
>>
>>     This would be in contrast to payments/receipts made via the
>>     Payments and Receipts menus for debtors and creditors.
>>
>>     However, for bank fees and such which must be entered through
>>     General Ledger payment (not a creditor), this poses a problem as
>>     the  amounts will show in bank account transaction
>>     listings/reconcilliations - as they should. Howevrer they will
>>     never show as a general journal or reports as such (they are
>>     trans 12 not 0).
>>
>>     Thanks in advance for any advice.
>>
>>     Cheers,
>>
>>
>>
>>
>>
>>
>>
>>     ------------------------------------------------------------------------------
>>     Rapidly troubleshoot problems before they affect your business. Most IT
>>     organizations don't have a clear picture of how application performance
>>     affects their revenue. With AppDynamics, you get 100% visibility into your
>>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
>>     http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>>
>>
>>     _______________________________________________
>>     Web-erp-developers mailing list
>>     Web...@li...  <mailto:Web...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>     ------------------------------------------------------------------------------
>     Rapidly troubleshoot problems before they affect your business.
>     Most IT
>     organizations don't have a clear picture of how application
>     performance
>     affects their revenue. With AppDynamics, you get 100% visibility
>     into your
>     Java,.NET, & PHP application. Start your 15-day FREE TRIAL of
>     AppDynamics Pro!
>     http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>     _______________________________________________
>     Web-erp-developers mailing list
>     Web...@li...
>     <mailto:Web...@li...>
>     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

> It is not necessary to modify the transaction type in the gltrans table.

To see the bank transactions in the general journal enquiries we do.

>Can you point me to where the manual said the integration should be off
when taking on GL balances?
I will take another look and let you know - i know i found it confusing
when i first used webERP and went on a google hunt. It's been some time
since i looked at that part of the manual and i've always turned on GL for
bank transactions and off for everything else added through the General
Ledger menu.

> Which listings are you not able to see the balances ... script names
ideally please
GLJournalInquiry.php - will not display bank transaction journals.

And yes, trial balance shows balances correctly :)

Thanks for taking a look.


On Wed, Nov 27, 2013 at 5:09 PM, Phil Daintree <ph...@lo...>wrote:

>  It is not necessary to modify the transaction type in the gltrans table.
> Can you point me to where the manual said the integration should be off
> when taking on GL balances? I can see where it says this in relation to
> setting up debtors and creditors balances i.e the open items in the
> sub-ledgers.
> Which listings are you not able to see the balances ... script names
> ideally please. Maybe this is where the problem lies - assuming the trial
> balance shows the balances correctly!
>
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 27/11/13 15:23, iced lava wrote:
>
>  Provisos and issue remaining:
>
>  1. The opening balance transaction in the example with GL trans should
> occur with GL turned off (if instructions in manual are correct)
>
>  2. The behaviour cannot be applied generally to transactions through
> General Ledger unless the these transactions are displayed, such as bank
> fees, in the bank reconcilliation listings. They do not display when type
> is set to 0 (general journal) in the gltrans table and so fix should be
> determined for the reconcilliation functions.
>
> Comments appreciated.
>
> Thanks,
>
>
>
> On Wed, Nov 27, 2013 at 12:44 PM, iced lava <ice...@gm...> wrote:
>
>>  As an example:
>> I note that if I enter the bank balances at 30 June with GL on, I can
>> change the Type of transaction in the gltrans table to 0 (general journal).
>> Appropriate [next] incremented general journal numbers a can provided to
>> these transactions by editing as well [and systype incremented accordingly
>> and chart detail also adjusted].
>>
>>  If this is done then the year closing journals appear as required in
>> the journal listings, on the trial balance and the bank listings and
>> reports also seem correct (transactions are left untouched in banktrans
>> table).
>>
>>
>>  This is as expected for the entry made through General Ledger bank
>> receipts.
>>
>>
>>  Is this a bug?
>>  Should this behaviour also happen for other bank receipts and payments
>> made through General Ledger option? I would think so.
>>
>>  I can fix if required.
>>
>> Thanks.
>>
>>
>>
>>
>> On Wed, Nov 27, 2013 at 12:04 PM, iced lava <ice...@gm...> wrote:
>>
>>>     Could I have confirmation on what should happen when bank account
>>> balances are entered in  for end of year closing balances eg at 30 June.
>>>
>>> Here is the current behaviour I see in latest  webERP. Note that usually
>>> according to documentation year end balances should be done with GL
>>> integration off.
>>>
>>>  1. With GL integration turned off, the bank balances are taken on at 30
>>> June by entering a receipt (General Ledger - Bank account receipt entry).
>>>
>>>    - This transaction only appears as a single entry in the banktrans
>>>    table - nowhere else
>>>    - there is no corresponding balancing transaction - it would have to
>>>    be made manually
>>>    - as such the bank account balances do not appear in any 30 June
>>>    trial balance
>>>    - a listing of 30 June journal entries does not show any 30 June
>>>    entries for any bank accounts GL accounts
>>>    - trial balance as a consequence does not have any entries for these
>>>    bank transactions
>>>
>>>
>>>  2. With the GL integration turned on - if the bank balances are taken
>>> on at 30 June by entering a receipt (General Ledger - Bank account receipt
>>> entry)
>>>
>>>
>>>    - The transaction appears as an entry in the banktrans table
>>>    - there is a corresponding transaction in the gltrans table and the
>>>    balancing transaction(s)
>>>    - the chartdetails table has entries for these transactions
>>>    - trial balance shows an entry for these bank accounts
>>>    - the listing of 30 June journal entries does not show anything for
>>>    the bank accounts
>>>    - the type in the gltrans table is type 12 - bank transaction, not 0
>>>    for general journal
>>>
>>>
>>>  This is causing confusing with customer.
>>>
>>> The behaviour I thought would happen is that any bank transactions
>>> entered through the General Ledger - Bank account [receipt/payment] should
>>> in fact have entries in gltrans table and subsequent entries in the chart
>>> details. They then should appear in journal reports.
>>>
>>> This would be in contrast to payments/receipts made via the Payments and
>>> Receipts menus for debtors and creditors.
>>>
>>> However, for bank fees and such which must be entered through General
>>> Ledger payment (not a creditor), this poses a problem as the  amounts will
>>> show in bank account transaction listings/reconcilliations - as they
>>> should. Howevrer they will never show as a general journal or reports as
>>> such (they are trans 12 not 0).
>>>
>>> Thanks in advance for any advice.
>>>
>>> Cheers,
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

Hi Phil,

Thanks for the reply, you confirmed what i thought and what I did when I've
had to enter bank balances at 30 June.

The GL is off for all other 30 June balance entries which seems perhaps
inconsistent and confusing to the customer.

However - given that - there is a problem I think.

With the GL off, you can go into the General Ledger menu and make GL
journal entries.
When adding the bank balance entries - the GL must be on for this even
though you still go through the General Ledger menu which implies you are
doing general journals (rather than through Payments or Receipts)

The problem is  the bank balances are created with Type 12  bank
transaction type -  not type 0 for general journal. This means that any
General Ledger receipt or payments never show up in the journal enquiries
which is confusing customers and they cannot get a full idea of for
example, what may have gone into  a clearing account at June 30 if bank
accounts are involved - they don't display.

It seems that if the bank transaction is entered through the General Ledger
option then it should show up in the general ledger journal listings - but
won't.

If I change the GL type to 0 for the bank transactions in the gltrans
table, as per my example, and leave the bank transactions as they are in
the banktrans table, then everything works as expected. Except of course
the bank transactions do not show up in the reconcilliation functions.
Everything else is good - correct reports, trial balances etc.

My question is:
1. Can we change the code for bank transactions made through the General
Ledger option as a journal - to post into the gltrans table as a journal
(type 0) to get correct reporting?
2. Can we then change the bank reconciliation functions to display journal
bank transactions (like bank fees)  that will not display if type 0?

Is it safe to change the code to post bank transactions into the gltrans
table as type 0? and what fix then do we need for reconciliation functions?
Or - is there another way?

Thanks in advance.







On Wed, Nov 27, 2013 at 5:02 PM, Phil Daintree <ph...@lo...>wrote:

>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 27/11/13 14:34, iced lava wrote:
>
>     Could I have confirmation on what should happen when bank account
> balances are entered in  for end of year closing balances eg at 30 June.
>
> Here is the current behaviour I see in latest  webERP. Note that usually
> according to documentation year end balances should be done with GL
> integration off.
>
>
>
> Nope the GL integration should only be turned off when entering debtors or
> creditors opening balances by entering open invoices.
> To enter the GL opening balances the GL integration with debtors needs to
> be enabled if entering a receipt (or creditors if entering a payment).
> The trial balance is of course a general ledger thing and naturally you
> need to have general ledger journals created to have any balances created
> in the general ledger.
>
>
>
>     1. With GL integration turned off, the bank balances are taken on at
> 30 June by entering a receipt (General Ledger - Bank account receipt entry).
>
>    - This transaction only appears as a single entry in the banktrans
>    table - nowhere else
>    - there is no corresponding balancing transaction - it would have to
>    be made manually
>    - as such the bank account balances do not appear in any 30 June trial
>    balance
>    - a listing of 30 June journal entries does not show any 30 June
>    entries for any bank accounts GL accounts
>    - trial balance as a consequence does not have any entries for these
>    bank transactions
>
>
>  2. With the GL integration turned on - if the bank balances are taken on
> at 30 June by entering a receipt (General Ledger - Bank account receipt
> entry)
>
>
>    - The transaction appears as an entry in the banktrans table
>    - there is a corresponding transaction in the gltrans table and the
>    balancing transaction(s)
>    - the chartdetails table has entries for these transactions
>    - trial balance shows an entry for these bank accounts
>    - the listing of 30 June journal entries does not show anything for
>    the bank accounts
>    - the type in the gltrans table is type 12 - bank transaction, not 0
>    for general journal
>
>
>   This should work with debtor integration turned on?
> The balances created on 30 June should flow through to July? With
> chartdetails showing the bfwd balances
> The bank balance should reflect the receipt?
>
> Any screen shots?
>
>  This is causing confusing with customer.
>
> The behaviour I thought would happen is that any bank transactions entered
> through the General Ledger - Bank account [receipt/payment] should in fact
> have entries in gltrans table and subsequent entries in the chart details.
> They then should appear in journal reports.
>
> This would be in contrast to payments/receipts made via the Payments and
> Receipts menus for debtors and creditors.
>
> However, for bank fees and such which must be entered through General
> Ledger payment (not a creditor), this poses a problem as the  amounts will
> show in bank account transaction listings/reconcilliations - as they
> should. Howevrer they will never show as a general journal or reports as
> such (they are trans 12 not 0).
>
> Thanks in advance for any advice.
>
> Cheers,
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics
> Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Closing balances - bank accounts

[Phil D. <ph...@lo...>]

It is not necessary to modify the transaction type in the gltrans table.
Can you point me to where the manual said the integration should be off 
when taking on GL balances? I can see where it says this in relation to 
setting up debtors and creditors balances i.e the open items in the 
sub-ledgers.
Which listings are you not able to see the balances ... script names 
ideally please. Maybe this is where the problem lies - assuming the 
trial balance shows the balances correctly!

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 15:23, iced lava wrote:
> Provisos and issue remaining:
>
> 1. The opening balance transaction in the example with GL trans should 
> occur with GL turned off (if instructions in manual are correct)
>
> 2. The behaviour cannot be applied generally to transactions through 
> General Ledger unless the these transactions are displayed, such as 
> bank fees, in the bank reconcilliation listings. They do not display 
> when type is set to 0 (general journal) in the gltrans table and so 
> fix should be determined for the reconcilliation functions.
>
> Comments appreciated.
>
> Thanks,
>
>
>
> On Wed, Nov 27, 2013 at 12:44 PM, iced lava <ice...@gm... 
> <mailto:ice...@gm...>> wrote:
>
>     As an example:
>     I note that if I enter the bank balances at 30 June with GL on, I
>     can change the Type of transaction in the gltrans table to 0
>     (general journal). Appropriate [next] incremented general journal
>     numbers a can provided to these transactions by editing as well
>     [and systype incremented accordingly and chart detail also adjusted].
>
>     If this is done then the year closing journals appear as required
>     in the journal listings, on the trial balance and the bank
>     listings and reports also seem correct (transactions are left
>     untouched in banktrans table).
>
>
>     This is as expected for the entry made through General Ledger bank
>     receipts.
>
>
>     Is this a bug?
>     Should this behaviour also happen for other bank receipts and
>     payments made through General Ledger option? I would think so.
>
>     I can fix if required.
>
>     Thanks.
>
>
>
>
>     On Wed, Nov 27, 2013 at 12:04 PM, iced lava <ice...@gm...
>     <mailto:ice...@gm...>> wrote:
>
>         Could I have confirmation on what should happen when bank
>         account balances are entered in for end of year closing
>         balances eg at 30 June.
>
>         Here is the current behaviour I see in latest  webERP. Note
>         that usually according to documentation year end balances
>         should be done with GL integration off.
>
>         1. With GL integration turned off, the bank balances are taken
>         on at 30 June by entering a receipt (General Ledger - Bank
>         account receipt entry).
>
>           * This transaction only appears as a single entry in the
>             banktrans table - nowhere else
>           * there is no corresponding balancing transaction - it would
>             have to be made manually
>           * as such the bank account balances do not appear in any 30
>             June trial balance
>           * a listing of 30 June journal entries does not show any 30
>             June entries for any bank accounts GL accounts
>           * trial balance as a consequence does not have any entries
>             for these bank transactions
>
>
>         2. With the GL integration turned on - if the bank balances
>         are taken on at 30 June by entering a receipt (General Ledger
>         - Bank account receipt entry)
>
>           * The transaction appears as an entry in the banktrans table
>           * there is a corresponding transaction in the gltrans table
>             and the balancing transaction(s)
>           * the chartdetails table has entries for these transactions
>           * trial balance shows an entry for these bank accounts
>           * the listing of 30 June journal entries does not show
>             anything for the bank accounts
>           * the type in the gltrans table is type 12 - bank
>             transaction, not 0 for general journal
>
>
>         This is causing confusing with customer.
>
>         The behaviour I thought would happen is that any bank
>         transactions entered through the General Ledger - Bank account
>         [receipt/payment] should in fact have entries in gltrans table
>         and subsequent entries in the chart details. They then should
>         appear in journal reports.
>
>         This would be in contrast to payments/receipts made via the
>         Payments and Receipts menus for debtors and creditors.
>
>         However, for bank fees and such which must be entered through
>         General Ledger payment (not a creditor), this poses a problem
>         as the  amounts will show in bank account transaction
>         listings/reconcilliations - as they should. Howevrer they will
>         never show as a general journal or reports as such (they are
>         trans 12 not 0).
>
>         Thanks in advance for any advice.
>
>         Cheers,
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Closing balances - bank accounts

[Phil D. <ph...@lo...>]

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 27/11/13 14:34, iced lava wrote:
> Could I have confirmation on what should happen when bank account 
> balances are entered in  for end of year closing balances eg at 30 June.
>
> Here is the current behaviour I see in latest webERP. Note that 
> usually according to documentation year end balances should be done 
> with GL integration off.
>


Nope the GL integration should only be turned off when entering debtors 
or creditors opening balances by entering open invoices.
To enter the GL opening balances the GL integration with debtors needs 
to be enabled if entering a receipt (or creditors if entering a payment).
The trial balance is of course a general ledger thing and naturally you 
need to have general ledger journals created to have any balances 
created in the general ledger.


> 1. With GL integration turned off, the bank balances are taken on at 
> 30 June by entering a receipt (General Ledger - Bank account receipt 
> entry).
>
>   * This transaction only appears as a single entry in the banktrans
>     table - nowhere else
>   * there is no corresponding balancing transaction - it would have to
>     be made manually
>   * as such the bank account balances do not appear in any 30 June
>     trial balance
>   * a listing of 30 June journal entries does not show any 30 June
>     entries for any bank accounts GL accounts
>   * trial balance as a consequence does not have any entries for these
>     bank transactions
>
>
> 2. With the GL integration turned on - if the bank balances are taken 
> on at 30 June by entering a receipt (General Ledger - Bank account 
> receipt entry)
>
>   * The transaction appears as an entry in the banktrans table
>   * there is a corresponding transaction in the gltrans table and the
>     balancing transaction(s)
>   * the chartdetails table has entries for these transactions
>   * trial balance shows an entry for these bank accounts
>   * the listing of 30 June journal entries does not show anything for
>     the bank accounts
>   * the type in the gltrans table is type 12 - bank transaction, not 0
>     for general journal
>
>
This should work with debtor integration turned on?
The balances created on 30 June should flow through to July? With 
chartdetails showing the bfwd balances
The bank balance should reflect the receipt?

Any screen shots?

> This is causing confusing with customer.
>
> The behaviour I thought would happen is that any bank transactions 
> entered through the General Ledger - Bank account [receipt/payment] 
> should in fact have entries in gltrans table and subsequent entries in 
> the chart details. They then should appear in journal reports.
>
> This would be in contrast to payments/receipts made via the Payments 
> and Receipts menus for debtors and creditors.
>
> However, for bank fees and such which must be entered through General 
> Ledger payment (not a creditor), this poses a problem as the  amounts 
> will show in bank account transaction listings/reconcilliations - as 
> they should. Howevrer they will never show as a general journal or 
> reports as such (they are trans 12 not 0).
>
> Thanks in advance for any advice.
>
> Cheers,
>
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Rapidly troubleshoot problems before they affect your business. Most IT
> organizations don't have a clear picture of how application performance
> affects their revenue. With AppDynamics, you get 100% visibility into your
> Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
> http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

Provisos and issue remaining:

1. The opening balance transaction in the example with GL trans should
occur with GL turned off (if instructions in manual are correct)

2. The behaviour cannot be applied generally to transactions through
General Ledger unless the these transactions are displayed, such as bank
fees, in the bank reconcilliation listings. They do not display when type
is set to 0 (general journal) in the gltrans table and so fix should be
determined for the reconcilliation functions.

Comments appreciated.

Thanks,



On Wed, Nov 27, 2013 at 12:44 PM, iced lava <ice...@gm...> wrote:

> As an example:
> I note that if I enter the bank balances at 30 June with GL on, I can
> change the Type of transaction in the gltrans table to 0 (general journal).
> Appropriate [next] incremented general journal numbers a can provided to
> these transactions by editing as well [and systype incremented accordingly
> and chart detail also adjusted].
>
> If this is done then the year closing journals appear as required in the
> journal listings, on the trial balance and the bank listings and reports
> also seem correct (transactions are left untouched in banktrans table).
>
>
> This is as expected for the entry made through General Ledger bank
> receipts.
>
>
> Is this a bug?
> Should this behaviour also happen for other bank receipts and payments
> made through General Ledger option? I would think so.
>
> I can fix if required.
>
> Thanks.
>
>
>
>
> On Wed, Nov 27, 2013 at 12:04 PM, iced lava <ice...@gm...> wrote:
>
>> Could I have confirmation on what should happen when bank account
>> balances are entered in  for end of year closing balances eg at 30 June.
>>
>> Here is the current behaviour I see in latest  webERP. Note that usually
>> according to documentation year end balances should be done with GL
>> integration off.
>>
>> 1. With GL integration turned off, the bank balances are taken on at 30
>> June by entering a receipt (General Ledger - Bank account receipt entry).
>>
>>    - This transaction only appears as a single entry in the banktrans
>>    table - nowhere else
>>    - there is no corresponding balancing transaction - it would have to
>>    be made manually
>>    - as such the bank account balances do not appear in any 30 June
>>    trial balance
>>    - a listing of 30 June journal entries does not show any 30 June
>>    entries for any bank accounts GL accounts
>>    - trial balance as a consequence does not have any entries for these
>>    bank transactions
>>
>>
>> 2. With the GL integration turned on - if the bank balances are taken on
>> at 30 June by entering a receipt (General Ledger - Bank account receipt
>> entry)
>>
>>
>>    - The transaction appears as an entry in the banktrans table
>>    - there is a corresponding transaction in the gltrans table and the
>>    balancing transaction(s)
>>    - the chartdetails table has entries for these transactions
>>    - trial balance shows an entry for these bank accounts
>>    - the listing of 30 June journal entries does not show anything for
>>    the bank accounts
>>    - the type in the gltrans table is type 12 - bank transaction, not 0
>>    for general journal
>>
>>
>> This is causing confusing with customer.
>>
>> The behaviour I thought would happen is that any bank transactions
>> entered through the General Ledger - Bank account [receipt/payment] should
>> in fact have entries in gltrans table and subsequent entries in the chart
>> details. They then should appear in journal reports.
>>
>> This would be in contrast to payments/receipts made via the Payments and
>> Receipts menus for debtors and creditors.
>>
>> However, for bank fees and such which must be entered through General
>> Ledger payment (not a creditor), this poses a problem as the  amounts will
>> show in bank account transaction listings/reconcilliations - as they
>> should. Howevrer they will never show as a general journal or reports as
>> such (they are trans 12 not 0).
>>
>> Thanks in advance for any advice.
>>
>> Cheers,
>>
>>
>>
>>
>>
>>
>

Re: [WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

As an example:
I note that if I enter the bank balances at 30 June with GL on, I can
change the Type of transaction in the gltrans table to 0 (general journal).
Appropriate [next] incremented general journal numbers a can provided to
these transactions by editing as well [and systype incremented accordingly
and chart detail also adjusted].

If this is done then the year closing journals appear as required in the
journal listings, on the trial balance and the bank listings and reports
also seem correct (transactions are left untouched in banktrans table).


This is as expected for the entry made through General Ledger bank receipts.


Is this a bug?
Should this behaviour also happen for other bank receipts and payments made
through General Ledger option? I would think so.

I can fix if required.

Thanks.




On Wed, Nov 27, 2013 at 12:04 PM, iced lava <ice...@gm...> wrote:

> Could I have confirmation on what should happen when bank account balances
> are entered in  for end of year closing balances eg at 30 June.
>
> Here is the current behaviour I see in latest  webERP. Note that usually
> according to documentation year end balances should be done with GL
> integration off.
>
> 1. With GL integration turned off, the bank balances are taken on at 30
> June by entering a receipt (General Ledger - Bank account receipt entry).
>
>    - This transaction only appears as a single entry in the banktrans
>    table - nowhere else
>    - there is no corresponding balancing transaction - it would have to
>    be made manually
>    - as such the bank account balances do not appear in any 30 June trial
>    balance
>    - a listing of 30 June journal entries does not show any 30 June
>    entries for any bank accounts GL accounts
>    - trial balance as a consequence does not have any entries for these
>    bank transactions
>
>
> 2. With the GL integration turned on - if the bank balances are taken on
> at 30 June by entering a receipt (General Ledger - Bank account receipt
> entry)
>
>
>    - The transaction appears as an entry in the banktrans table
>    - there is a corresponding transaction in the gltrans table and the
>    balancing transaction(s)
>    - the chartdetails table has entries for these transactions
>    - trial balance shows an entry for these bank accounts
>    - the listing of 30 June journal entries does not show anything for
>    the bank accounts
>    - the type in the gltrans table is type 12 - bank transaction, not 0
>    for general journal
>
>
> This is causing confusing with customer.
>
> The behaviour I thought would happen is that any bank transactions entered
> through the General Ledger - Bank account [receipt/payment] should in fact
> have entries in gltrans table and subsequent entries in the chart details.
> They then should appear in journal reports.
>
> This would be in contrast to payments/receipts made via the Payments and
> Receipts menus for debtors and creditors.
>
> However, for bank fees and such which must be entered through General
> Ledger payment (not a creditor), this poses a problem as the  amounts will
> show in bank account transaction listings/reconcilliations - as they
> should. Howevrer they will never show as a general journal or reports as
> such (they are trans 12 not 0).
>
> Thanks in advance for any advice.
>
> Cheers,
>
>
>
>
>
>

[WebERP-developers] Closing balances - bank accounts

[iced l. <ice...@gm...>]

Could I have confirmation on what should happen when bank account balances
are entered in  for end of year closing balances eg at 30 June.

Here is the current behaviour I see in latest  webERP. Note that usually
according to documentation year end balances should be done with GL
integration off.

1. With GL integration turned off, the bank balances are taken on at 30
June by entering a receipt (General Ledger - Bank account receipt entry).

   - This transaction only appears as a single entry in the banktrans table
   - nowhere else
   - there is no corresponding balancing transaction - it would have to be
   made manually
   - as such the bank account balances do not appear in any 30 June trial
   balance
   - a listing of 30 June journal entries does not show any 30 June entries
   for any bank accounts GL accounts
   - trial balance as a consequence does not have any entries for these
   bank transactions


2. With the GL integration turned on - if the bank balances are taken on at
30 June by entering a receipt (General Ledger - Bank account receipt entry)


   - The transaction appears as an entry in the banktrans table
   - there is a corresponding transaction in the gltrans table and the
   balancing transaction(s)
   - the chartdetails table has entries for these transactions
   - trial balance shows an entry for these bank accounts
   - the listing of 30 June journal entries does not show anything for the
   bank accounts
   - the type in the gltrans table is type 12 - bank transaction, not 0 for
   general journal


This is causing confusing with customer.

The behaviour I thought would happen is that any bank transactions entered
through the General Ledger - Bank account [receipt/payment] should in fact
have entries in gltrans table and subsequent entries in the chart details.
They then should appear in journal reports.

This would be in contrast to payments/receipts made via the Payments and
Receipts menus for debtors and creditors.

However, for bank fees and such which must be entered through General
Ledger payment (not a creditor), this poses a problem as the  amounts will
show in bank account transaction listings/reconcilliations - as they
should. Howevrer they will never show as a general journal or reports as
such (they are trans 12 not 0).

Thanks in advance for any advice.

Cheers,

Re: [WebERP-developers] FormDesigner.php

[Rafael C. <raf...@gm...>]

Exson Qu:

Thank you very much. I updated the Chinese translations for
FormDesigner.php with your help. Please review if I did correctly.

I will continue to work with the 3 reports configured by xml files
(PurchaseOrder, PickingList and GRN) for testing purposes. I hope it will
be better that we have now (in usability).

Best regards, Rafael.


2013/11/25 ExsonQu <hex...@gm...>

> *Hi, Rafael,
> *
>
> Please refer to following result:
> The first line is in simplified Chinese.
> The 2nd line is in traditional Chinese.
>
> - Enter the changes that you want in the form layout below.
> - 输入报表中你需要修改的部分。
> - 輸入報表中你需要修改的部分。
> - All measurements are in PostScript points (72 points = 25,4 mm).
> - 所用的计量单位为PostScript的点（72点 = 25.4 毫米)
> - 所用的計量單位爲PostScript的點 (72點 = 25.4 毫米)
> - All coordinates are measured from the lower left corner of the sheet to
> the top left corner of the element.
> - 所有的坐标值均从纸张的左下角开始到元素的左上角。
> - 所有的坐標值均從紙張的左下角開始到元素的左上角。
> - Distance from the left side of the sheet to the left side of the element
> in points
> - 从纸张左侧开始到元素左侧的距离以点数表示
> - 從紙張左側開始到元素左側的距離以點數表示
> - Distance from the lower side of the sheet to the top side of the element
> in points
> - 从纸张底部到元素顶部的距离以点数表示
> - 從紙張底部到元素頂部的距離以點數表示
> - Width of the element in points
> - 元素的宽度以点数表示
> - 元素的寬度以點數表示
>
> - Height of the element in points
> - 元素高度以点数表示
> - 元素高度以點數表示
> - Font size in points
> - 字体大小以点数表示
> -字體大小以點數表示
>
>
>
> --
> View this message in context:
> http://weberp-accounting.1478800.n4.nabble.com/FormDesigner-php-tp4656864p4656963.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up
> now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>

Re: [WebERP-developers] Language pull-down menu.

[Phil D. <ph...@lo...>]

The stable branch is too old and it would take a lot of work to bring it up to speed. It just needs deleting i think.
I will run build/make_release.sh to reextract new strings for all languages. Also need to reduce the number of periods  in the demo data

"Rafael Chacón" <raf...@gm...> wrote:
>Hi, Exson:
>
>I think we should update LanguagesArray.php in the stable branch in the
>svn. The modifications in this script do that each language in the list
>be
>read in their respective native language. In this way, the usability is
>improved.
>
>Is it possible to commit this code there before the final release?
>
>Thanks and best regards!
>
>Rafael.
>
>
>2013/11/21 Rafael Chacón <raf...@gm...>
>
>> Hi, Exson: Translations included.
>>
>> Hi, Phil: Thank you very much.
>>
>> Regards, Rafael.
>>
>>
>> 2013/11/21 Rafael Chacón <raf...@gm...>
>>
>>> Hi, Exson:
>>>
>>> Thank you very much for your translations. And it is a plaesure to
>help
>>> people with this project.
>>>
>>> Hi, Phil:
>>>
>>> Yes, I agree with you. But it is gratifying to see the results.
>>>
>>> For documentation purposes:
>>>
>>> * My sources are:
>>>     (1) Files .../locale/xx_XX.utf8/LC_MESSAGES/messages.po, the
>>> transation for the English term;
>>>     (2) http://en.wikipedia.org/wiki/Main_Page, code inside the left
>>> panel "Languages"; and
>>>     (3) if available, people who speak those languages.
>>>
>>> * Convention for language localisation ("language variant"):
>>>     ["Language family" in local language] + ' ' + ["National
>variety" in
>>> local language].
>>> That is, to group by Language-family and to subgroup by
>National-variety.
>>>
>>> The standard specifies between "code" (Language-family) and sub-code
>>> (National-variety) to link them "...with a hyphen, though in some
>contexts
>>> it's necessary to substitute this with an underscore", but I used a
>space.
>>> I prefer something more close to the natural speaking of each users,
>but if
>>> is wanted to keep the standard I can subtutute it by a '-' (hyphen)
>or a '
>>> - ' (space hyphen space).
>>>
>>> Best regards, Rafael.
>>>
>>>
>>> 2013/11/20 Phil Daintree <ph...@lo...>
>>>
>>>>  Yes tricky job this - and needs the bi-lingual guys to do it for
>their
>>>> language.
>>>>
>>>> Phil
>>>>
>>>> Phil Daintree
>>>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>>>
>>>> On 21/11/13 12:28, Rafael Chacón wrote:
>>>>
>>>>   Hi,
>>>>
>>>>  I need help to translate to local language:
>>>>
>>>> - Arabic Eygptian
>>>> - Chinese - Traditional Hongkong
>>>> - Chinese - Traditional Taiwan
>>>>
>>>>  Sorry, but files on .../locale/xx-XX.utf8 do not have translations
>for
>>>> language name.
>>>>
>>>>  Note: Please, native speakers review the correspondent local
>>>> translation.
>>>>
>>>>  Regards, Rafael.
>>>>
>>>>
>>>>
>>>>  2013/11/20 Rafael Chacón <raf...@gm...>
>>>>
>>>>>  Thank you.
>>>>>
>>>>>  I will translate the name of each language to the name in their
>>>>> respective language (as in Wikipedia).
>>>>>
>>>>> Please, native speakers review my translation to their respective
>>>>> language.
>>>>>
>>>>>  Best regards, Rafael.
>>>>>
>>>>>
>>>>> 2013/11/20 Phil Daintree <ph...@lo...>
>>>>>
>>>>>>  Yes this is a good idea Rafael
>>>>>> There really is no need to have these in any other language so
>the
>>>>>> gettext function is not necessary I think. Each country should be
>listed in
>>>>>> it's native language.
>>>>>>
>>>>>> Phil
>>>>>>
>>>>>> Phil Daintree
>>>>>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>>>>>
>>>>>>  On 20/11/13 03:30, Rafael Chacón wrote:
>>>>>>
>>>>>>   Hi All,
>>>>>>
>>>>>> What about if the language list has the name of each language in
>>>>>> their respective language (as in Wikipedia) instead of having a
>>>>>> localized name?
>>>>>>
>>>>>> I think:
>>>>>> 1. We can save the work of translating each name (more faster).
>>>>>> 2. For a user it is easier to find the name of their language in
>>>>>> their own language, rather than look for it in another.
>>>>>>
>>>>>>  Regards,
>>>>>>
>>>>>>  Rafael Chacon
>>>>>>
>>>>>>
>>>>>>  
>------------------------------------------------------------------------------
>>>>>> Shape the Mobile Experience: Free Subscription
>>>>>> Software experts and developers: Be at the forefront of tech
>innovation.
>>>>>> Intel(R) Software Adrenaline delivers strategic insight and
>game-changing
>>>>>> conversations that shape the rapidly evolving mobile landscape.
>Sign up now.
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Web-erp-developers mailing
>lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>------------------------------------------------------------------------------
>>>>>> Shape the Mobile Experience: Free Subscription
>>>>>> Software experts and developers: Be at the forefront of tech
>>>>>> innovation.
>>>>>> Intel(R) Software Adrenaline delivers strategic insight and
>>>>>> game-changing
>>>>>> conversations that shape the rapidly evolving mobile landscape.
>Sign
>>>>>> up now.
>>>>>>
>>>>>>
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>>> _______________________________________________
>>>>>> Web-erp-developers mailing list
>>>>>> Web...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>>
>------------------------------------------------------------------------------
>>>> Shape the Mobile Experience: Free Subscription
>>>> Software experts and developers: Be at the forefront of tech
>innovation.
>>>> Intel(R) Software Adrenaline delivers strategic insight and
>game-changing
>>>> conversations that shape the rapidly evolving mobile landscape.
>Sign up now.
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Web-erp-developers mailing
>lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>>
>>>>
>>>>
>------------------------------------------------------------------------------
>>>> Shape the Mobile Experience: Free Subscription
>>>> Software experts and developers: Be at the forefront of tech
>innovation.
>>>> Intel(R) Software Adrenaline delivers strategic insight and
>game-changing
>>>> conversations that shape the rapidly evolving mobile landscape.
>Sign up
>>>> now.
>>>>
>>>>
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> Web-erp-developers mailing list
>>>> Web...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>
>>
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>Shape the Mobile Experience: Free Subscription
>Software experts and developers: Be at the forefront of tech
>innovation.
>Intel(R) Software Adrenaline delivers strategic insight and
>game-changing 
>conversations that shape the rapidly evolving mobile landscape. Sign up
>now. 
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Web-erp-developers mailing list
>Web...@li...
>https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Phil Daintree
+64(0)275 567890
skype: daintree

Re: [WebERP-developers] FormDesigner.php

[ExsonQu <hex...@gm...>]

*Hi, Rafael,
*

Please refer to following result:
The first line is in simplified Chinese.
The 2nd line is in traditional Chinese.

- Enter the changes that you want in the form layout below.
- 输入报表中你需要修改的部分。
- 輸入報表中你需要修改的部分。
- All measurements are in PostScript points (72 points = 25,4 mm).
- 所用的计量单位为PostScript的点（72点 = 25.4 毫米)
- 所用的計量單位爲PostScript的點 (72點 = 25.4 毫米)
- All coordinates are measured from the lower left corner of the sheet to
the top left corner of the element.
- 所有的坐标值均从纸张的左下角开始到元素的左上角。
- 所有的坐標值均從紙張的左下角開始到元素的左上角。
- Distance from the left side of the sheet to the left side of the element
in points
- 从纸张左侧开始到元素左侧的距离以点数表示
- 從紙張左側開始到元素左側的距離以點數表示
- Distance from the lower side of the sheet to the top side of the element
in points
- 从纸张底部到元素顶部的距离以点数表示
- 從紙張底部到元素頂部的距離以點數表示
- Width of the element in points
- 元素的宽度以点数表示
- 元素的寬度以點數表示

- Height of the element in points
- 元素高度以点数表示
- 元素高度以點數表示
- Font size in points
- 字体大小以点数表示
-字體大小以點數表示



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/FormDesigner-php-tp4656864p4656963.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

Re: [WebERP-developers] FormDesigner.php

[Rafael C. <raf...@gm...>]

Hi Exson,

For testing purposes (FormDesigner.php), can you help me translating to
Chinese - Traditional Hong Kong this:

- Enter the changes that you want in the form layout below.
- All measurements are in PostScript points (72 points = 25,4 mm).
- All coordinates are measured from the lower left corner of the sheet to
the top left corner of the element.
- Distance from the left side of the sheet to the left side of the element
in points
- Distance from the lower side of the sheet to the top side of the element
in points
- Width of the element in points
- Height of the element in points
- Font size in points

Best regards, Rafael.


2013/11/24 Rafael Chacón <raf...@gm...>

> Hi,
>
> I upload a testing version of FormDesigner.php OUTSIDE the trunk. I will
> not commit this version until I am completely sure that it is that we are
> looking for as the short term solution.
>
> To download FormDesigner.php TESTING VERSION (and related files):
> http://www.verdoramas.biz/FormDesigner/webERP.zip version 2013-11-24
> 20:18.
>
> WARNING: This is NOT backward compatible. Changes in *.xml files are NOT
> compatible with previous versions:
>
>    - All *.xml files and report generators MUST have standardized
>    ('height' with 'Height'), ('Length' with 'Width'), ('radius' with
>    'Radius'), and ('width' with 'Width').
>    - Some elements were grouped. Now there are group of elements for:
>    form-heading, company-logo, company-info, form-narrative, Deliver-to (in
>    purchase-order), supplier (in purchase-order), column-header, column-data,
>    column-footer, table-header, table-data and table-footer.
>    - There are 3 turn on/off rectangles. These rectangles can have
>    rounded corners. For square rectangle use Radius = 0.
>
> To do:
>
> - 3 turn on/off images (additional to logo). These images can be used as
> watermarks, banners, etc.
>
> - Extra attributes to rectangles (select corners to round or not; to fill
> or not the rectangle; to select the rectangle filling).
>
> - To develop a routine to update old *.xml files to the new format.
>
>
> Please review and comment. Thanks.
>
> Best regards, Rafael.
>
>
> 2013/11/22 Rafael Chacón <raf...@gm...>
>
>> Hi Exson,
>>
>> Done.
>>
>> Best regards, Rafael.
>>
>>
>> 2013/11/22 ExsonQu <hex...@gm...>
>>
>>> Hi, Rafael,
>>>
>>>        Please try the following link to replace the trunk.
>>>
>>>          https://svn.code.sf.net/p/web-erp/code/stable4.11
>>>
>>>        Thanks and best regards!
>>>
>>>        Exson
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://weberp-accounting.1478800.n4.nabble.com/FormDesigner-php-tp4656864p4656950.html
>>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Shape the Mobile Experience: Free Subscription
>>> Software experts and developers: Be at the forefront of tech innovation.
>>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>>> conversations that shape the rapidly evolving mobile landscape. Sign up
>>> now.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Web-erp-developers mailing list
>>> Web...@li...
>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>
>>
>>
>

Re: [WebERP-developers] FormDesigner.php

[Rafael C. <raf...@gm...>]

Hi,

I upload a testing version of FormDesigner.php OUTSIDE the trunk. I will
not commit this version until I am completely sure that it is that we are
looking for as the short term solution.

To download FormDesigner.php TESTING VERSION (and related files):
http://www.verdoramas.biz/FormDesigner/webERP.zip version 2013-11-24 20:18.

WARNING: This is NOT backward compatible. Changes in *.xml files are NOT
compatible with previous versions:

   - All *.xml files and report generators MUST have standardized ('height'
   with 'Height'), ('Length' with 'Width'), ('radius' with 'Radius'), and
   ('width' with 'Width').
   - Some elements were grouped. Now there are group of elements for:
   form-heading, company-logo, company-info, form-narrative, Deliver-to (in
   purchase-order), supplier (in purchase-order), column-header, column-data,
   column-footer, table-header, table-data and table-footer.
   - There are 3 turn on/off rectangles. These rectangles can have rounded
   corners. For square rectangle use Radius = 0.

To do:

- 3 turn on/off images (additional to logo). These images can be used as
watermarks, banners, etc.

- Extra attributes to rectangles (select corners to round or not; to fill
or not the rectangle; to select the rectangle filling).

- To develop a routine to update old *.xml files to the new format.


Please review and comment. Thanks.

Best regards, Rafael.


2013/11/22 Rafael Chacón <raf...@gm...>

> Hi Exson,
>
> Done.
>
> Best regards, Rafael.
>
>
> 2013/11/22 ExsonQu <hex...@gm...>
>
>> Hi, Rafael,
>>
>>        Please try the following link to replace the trunk.
>>
>>          https://svn.code.sf.net/p/web-erp/code/stable4.11
>>
>>        Thanks and best regards!
>>
>>        Exson
>>
>>
>>
>> --
>> View this message in context:
>> http://weberp-accounting.1478800.n4.nabble.com/FormDesigner-php-tp4656864p4656950.html
>> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>>
>>
>> ------------------------------------------------------------------------------
>> Shape the Mobile Experience: Free Subscription
>> Software experts and developers: Be at the forefront of tech innovation.
>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>> conversations that shape the rapidly evolving mobile landscape. Sign up
>> now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>

Re: [WebERP-developers] To reconstruct the translation files

[Rafael C. <raf...@gm...>]

Hi Tim,

Great! Yes, I use Linux. Thank you very much.

Best regards, Rafael.


Hi Phil,

All my work is commited to the trunk version. Only I do a copy of
FormDesign.php in stable4.11.

Best regards, Rafael.



2013/11/23 Phil Daintree <ph...@lo...>

>  Is there anything in stable that should be committed to the trunk before
> I produce a new release?
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 24/11/13 03:15, Rafael Chacón wrote:
>
> Hi Phil, Hi Exson,
>
> With the changes in LanguagesArray.php and in FormDesigner.php, many
> translation lines have been reduced (e.g. the translation of the language
> name, the standardization of titles reduces the quantity of titles to
> translate, etc.).
>
> Also, adding user-support in FormDesigner.php, some translation lines have
> been added.
>
> I think it is appropriate to reconstruct the translation files.
>
> The procedure to do this is:
> 1. Copy all files from last version to a new webERP instalation.
> 2. Run .../Z_poRebuildDefault.php (Rebuild the System Default Language
> File) with local language in "English - Great Britain".
> 3. <loop>Open each messages.po with a POEditor, update from a POT file
> (.../locale/en_GB.utf8/LC_MESSAGES/messages.pot) and save.
> 4. Copy all new files on .../locale/ to the last version.
>
> Is it correct?
> May I proceed with this?
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up
> now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] Language pull-down menu.

[Rafael C. <raf...@gm...>]

OK.


2013/11/23 Phil Daintree <ph...@lo...>

>  Hi Rafael,
>
> Best to do your work in the trunk rather than stable as the stable branch
> was created and never updated since the last release.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 24/11/13 01:57, Rafael Chacón wrote:
>
> Hi, Exson:
>
> I think we should update LanguagesArray.php in the stable branch in the
> svn. The modifications in this script do that each language in the list be
> read in their respective native language. In this way, the usability is
> improved.
>
> Is it possible to commit this code there before the final release?
>
> Thanks and best regards!
>
> Rafael.
>
>
> 2013/11/21 Rafael Chacón <raf...@gm...>
>
>>  Hi, Exson: Translations included.
>>
>>  Hi, Phil: Thank you very much.
>>
>>  Regards, Rafael.
>>
>>
>> 2013/11/21 Rafael Chacón <raf...@gm...>
>>
>>> Hi, Exson:
>>>
>>> Thank you very much for your translations. And it is a plaesure to help
>>> people with this project.
>>>
>>> Hi, Phil:
>>>
>>> Yes, I agree with you. But it is gratifying to see the results.
>>>
>>> For documentation purposes:
>>>
>>> * My sources are:
>>>     (1) Files .../locale/xx_XX.utf8/LC_MESSAGES/messages.po, the
>>> transation for the English term;
>>>     (2) http://en.wikipedia.org/wiki/Main_Page, code inside the left
>>> panel "Languages"; and
>>>     (3) if available, people who speak those languages.
>>>
>>> * Convention for language localisation ("language variant"):
>>>     ["Language family" in local language] + ' ' + ["National variety" in
>>> local language].
>>> That is, to group by Language-family and to subgroup by National-variety.
>>>
>>> The standard specifies between "code" (Language-family) and sub-code
>>> (National-variety) to link them "...with a hyphen, though in some contexts
>>> it's necessary to substitute this with an underscore", but I used a space.
>>> I prefer something more close to the natural speaking of each users, but if
>>> is wanted to keep the standard I can subtutute it by a '-' (hyphen) or a '
>>> - ' (space hyphen space).
>>>
>>> Best regards, Rafael.
>>>
>>>
>>> 2013/11/20 Phil Daintree <ph...@lo...>
>>>
>>>>  Yes tricky job this - and needs the bi-lingual guys to do it for
>>>> their language.
>>>>
>>>> Phil
>>>>
>>>> Phil Daintree
>>>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>>>
>>>>   On 21/11/13 12:28, Rafael Chacón wrote:
>>>>
>>>>   Hi,
>>>>
>>>>  I need help to translate to local language:
>>>>
>>>> - Arabic Eygptian
>>>> - Chinese - Traditional Hongkong
>>>> - Chinese - Traditional Taiwan
>>>>
>>>>  Sorry, but files on .../locale/xx-XX.utf8 do not have translations for
>>>> language name.
>>>>
>>>>  Note: Please, native speakers review the correspondent local
>>>> translation.
>>>>
>>>>  Regards, Rafael.
>>>>
>>>>
>>>>
>>>>  2013/11/20 Rafael Chacón <raf...@gm...>
>>>>
>>>>>  Thank you.
>>>>>
>>>>>  I will translate the name of each language to the name in their
>>>>> respective language (as in Wikipedia).
>>>>>
>>>>> Please, native speakers review my translation to their respective
>>>>> language.
>>>>>
>>>>>  Best regards, Rafael.
>>>>>
>>>>>
>>>>> 2013/11/20 Phil Daintree <ph...@lo...>
>>>>>
>>>>>>  Yes this is a good idea Rafael
>>>>>> There really is no need to have these in any other language so the
>>>>>> gettext function is not necessary I think. Each country should be listed in
>>>>>> it's native language.
>>>>>>
>>>>>> Phil
>>>>>>
>>>>>> Phil Daintree
>>>>>> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>>>>>>
>>>>>>  On 20/11/13 03:30, Rafael Chacón wrote:
>>>>>>
>>>>>>   Hi All,
>>>>>>
>>>>>> What about if the language list has the name of each language in
>>>>>> their respective language (as in Wikipedia) instead of having a
>>>>>> localized name?
>>>>>>
>>>>>> I think:
>>>>>> 1. We can save the work of translating each name (more faster).
>>>>>> 2. For a user it is easier to find the name of their language in
>>>>>> their own language, rather than look for it in another.
>>>>>>
>>>>>>  Regards,
>>>>>>
>>>>>>  Rafael Chacon
>>>>>>
>>>>>>
>>>>>>   ------------------------------------------------------------------------------
>>>>>> Shape the Mobile Experience: Free Subscription
>>>>>> Software experts and developers: Be at the forefront of tech innovation.
>>>>>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>>>>>> conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Shape the Mobile Experience: Free Subscription
>>>>>> Software experts and developers: Be at the forefront of tech
>>>>>> innovation.
>>>>>> Intel(R) Software Adrenaline delivers strategic insight and
>>>>>> game-changing
>>>>>> conversations that shape the rapidly evolving mobile landscape. Sign
>>>>>> up now.
>>>>>>
>>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>>> _______________________________________________
>>>>>> Web-erp-developers mailing list
>>>>>> Web...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Shape the Mobile Experience: Free Subscription
>>>> Software experts and developers: Be at the forefront of tech innovation.
>>>> Intel(R) Software Adrenaline delivers strategic insight and game-changing
>>>> conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> Shape the Mobile Experience: Free Subscription
>>>> Software experts and developers: Be at the forefront of tech innovation.
>>>> Intel(R) Software Adrenaline delivers strategic insight and
>>>> game-changing
>>>> conversations that shape the rapidly evolving mobile landscape. Sign up
>>>> now.
>>>>
>>>> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>> _______________________________________________
>>>> Web-erp-developers mailing list
>>>> Web...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>>>
>>>>
>>>
>>
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now. http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>
>
> _______________________________________________
> Web-erp-developers mailing lis...@li...https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up
> now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>

Re: [WebERP-developers] To reconstruct the translation files

[Phil D. <ph...@lo...>]

Is there anything in stable that should be committed to the trunk before 
I produce a new release?

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 24/11/13 03:15, Rafael Chacón wrote:
> Hi Phil, Hi Exson,
>
> With the changes in LanguagesArray.php and in FormDesigner.php, many 
> translation lines have been reduced (e.g. the translation of the 
> language name, the standardization of titles reduces the quantity of 
> titles to translate, etc.).
>
> Also, adding user-support in FormDesigner.php, some translation lines 
> have been added.
>
> I think it is appropriate to reconstruct the translation files.
>
> The procedure to do this is:
> 1. Copy all files from last version to a new webERP instalation.
> 2. Run .../Z_poRebuildDefault.php (Rebuild the System Default Language 
> File) with local language in "English - Great Britain".
> 3. <loop>Open each messages.po with a POEditor, update from a POT file 
> (.../locale/en_GB.utf8/LC_MESSAGES/messages.pot) and save.
> 4. Copy all new files on .../locale/ to the last version.
>
> Is it correct?
> May I proceed with this?
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] Language pull-down menu.

[Phil D. <ph...@lo...>]

Hi Rafael,

Best to do your work in the trunk rather than stable as the stable 
branch was created and never updated since the last release.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 24/11/13 01:57, Rafael Chacón wrote:
> Hi, Exson:
>
> I think we should update LanguagesArray.php in the stable branch in 
> the svn. The modifications in this script do that each language in the 
> list be read in their respective native language. In this way, the 
> usability is improved.
>
> Is it possible to commit this code there before the final release?
>
> Thanks and best regards!
>
> Rafael.
>
>
> 2013/11/21 Rafael Chacón <raf...@gm... 
> <mailto:raf...@gm...>>
>
>     Hi, Exson: Translations included.
>
>     Hi, Phil: Thank you very much.
>
>     Regards, Rafael.
>
>
>     2013/11/21 Rafael Chacón <raf...@gm...
>     <mailto:raf...@gm...>>
>
>         Hi, Exson:
>
>         Thank you very much for your translations. And it is a
>         plaesure to help people with this project.
>
>         Hi, Phil:
>
>         Yes, I agree with you. But it is gratifying to see the results.
>
>         For documentation purposes:
>
>         * My sources are:
>             (1) Files .../locale/xx_XX.utf8/LC_MESSAGES/messages.po,
>         the transation for the English term;
>             (2) http://en.wikipedia.org/wiki/Main_Page, code inside
>         the left panel "Languages"; and
>             (3) if available, people who speak those languages.
>
>         * Convention for language localisation ("language variant"):
>             ["Language family" in local language] + ' ' + ["National
>         variety" in local language].
>         That is, to group by Language-family and to subgroup by
>         National-variety.
>
>         The standard specifies between "code" (Language-family) and
>         sub-code (National-variety) to link them "...with a hyphen,
>         though in some contexts it's necessary to substitute this with
>         an underscore", but I used a space. I prefer something more
>         close to the natural speaking of each users, but if is wanted
>         to keep the standard I can subtutute it by a '-' (hyphen) or a
>         ' - ' (space hyphen space).
>
>         Best regards, Rafael.
>
>
>         2013/11/20 Phil Daintree <ph...@lo...
>         <mailto:ph...@lo...>>
>
>             Yes tricky job this - and needs the bi-lingual guys to do
>             it for their language.
>
>             Phil
>
>             Phil Daintree
>             Logic Works Ltd -+64 (0)275 567890  <tel:%2B64%20%280%29275%20567890>
>             http://www.logicworks.co.nz
>
>             On 21/11/13 12:28, Rafael Chacón wrote:
>>             Hi,
>>
>>             I need help to translate to local language:
>>
>>             - Arabic Eygptian
>>             - Chinese - Traditional Hongkong
>>             - Chinese - Traditional Taiwan
>>
>>             Sorry, but files on .../locale/xx-XX.utf8 do not have
>>             translations for language name.
>>
>>             Note: Please, native speakers review the correspondent
>>             local translation.
>>
>>             Regards, Rafael.
>>
>>
>>
>>             2013/11/20 Rafael Chacón <raf...@gm...
>>             <mailto:raf...@gm...>>
>>
>>                 Thank you.
>>
>>                 I will translate the name of each language to the
>>                 name in their respective language (as in Wikipedia).
>>
>>                 Please, native speakers review my translation to
>>                 their respective language.
>>
>>                 Best regards, Rafael.
>>
>>
>>                 2013/11/20 Phil Daintree <ph...@lo...
>>                 <mailto:ph...@lo...>>
>>
>>                     Yes this is a good idea Rafael
>>                     There really is no need to have these in any
>>                     other language so the gettext function is not
>>                     necessary I think. Each country should be listed
>>                     in it's native language.
>>
>>                     Phil
>>
>>                     Phil Daintree
>>                     Logic Works Ltd -+64 (0)275 567890  <tel:%2B64%20%280%29275%20567890>
>>                     http://www.logicworks.co.nz
>>
>>                     On 20/11/13 03:30, Rafael Chacón wrote:
>>>                     Hi All,
>>>
>>>                     What about if the language list has the name of
>>>                     each language in their respective language (as
>>>                     in Wikipedia) instead of having a localized name?
>>>
>>>                     I think:
>>>                     1. We can save the work of translating each name
>>>                     (more faster).
>>>                     2. For a user it is easier to find the name of
>>>                     their language in their own language, rather
>>>                     than look for it in another.
>>>
>>>                     Regards,
>>>
>>>                     Rafael Chacon
>>>
>>>
>>>                     ------------------------------------------------------------------------------
>>>                     Shape the Mobile Experience: Free Subscription
>>>                     Software experts and developers: Be at the forefront of tech innovation.
>>>                     Intel(R) Software Adrenaline delivers strategic insight and game-changing
>>>                     conversations that shape the rapidly evolving mobile landscape. Sign up now.
>>>                     http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>>
>>>
>>>                     _______________________________________________
>>>                     Web-erp-developers mailing list
>>>                     Web...@li...  <mailto:Web...@li...>
>>>                     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>                     ------------------------------------------------------------------------------
>>                     Shape the Mobile Experience: Free Subscription
>>                     Software experts and developers: Be at the
>>                     forefront of tech innovation.
>>                     Intel(R) Software Adrenaline delivers strategic
>>                     insight and game-changing
>>                     conversations that shape the rapidly evolving
>>                     mobile landscape. Sign up now.
>>                     http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>                     _______________________________________________
>>                     Web-erp-developers mailing list
>>                     Web...@li...
>>                     <mailto:Web...@li...>
>>                     https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>>
>>
>>
>>             ------------------------------------------------------------------------------
>>             Shape the Mobile Experience: Free Subscription
>>             Software experts and developers: Be at the forefront of tech innovation.
>>             Intel(R) Software Adrenaline delivers strategic insight and game-changing
>>             conversations that shape the rapidly evolving mobile landscape. Sign up now.
>>             http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>>
>>
>>             _______________________________________________
>>             Web-erp-developers mailing list
>>             Web...@li...  <mailto:Web...@li...>
>>             https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>             ------------------------------------------------------------------------------
>             Shape the Mobile Experience: Free Subscription
>             Software experts and developers: Be at the forefront of
>             tech innovation.
>             Intel(R) Software Adrenaline delivers strategic insight
>             and game-changing
>             conversations that shape the rapidly evolving mobile
>             landscape. Sign up now.
>             http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>             _______________________________________________
>             Web-erp-developers mailing list
>             Web...@li...
>             <mailto:Web...@li...>
>             https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

Re: [WebERP-developers] To reconstruct the translation files

[Tim S. <tim...@gm...>]

Hi Rafael,

If you are running Linux, then the script build/make_release.sh should
do it all for you. (It will also update the database files, and zip up
the code but you can ignore that). Remember to change the constants at
the top of the script though.

Thanks
Tim

On 23 November 2013 14:15, Rafael Chacón <raf...@gm...> wrote:
> Hi Phil, Hi Exson,
>
> With the changes in LanguagesArray.php and in FormDesigner.php, many
> translation lines have been reduced (e.g. the translation of the language
> name, the standardization of titles reduces the quantity of titles to
> translate, etc.).
>
> Also, adding user-support in FormDesigner.php, some translation lines have
> been added.
>
> I think it is appropriate to reconstruct the translation files.
>
> The procedure to do this is:
> 1. Copy all files from last version to a new webERP instalation.
> 2. Run .../Z_poRebuildDefault.php (Rebuild the System Default Language File)
> with local language in "English - Great Britain".
> 3. <loop>Open each messages.po with a POEditor, update from a POT file
> (.../locale/en_GB.utf8/LC_MESSAGES/messages.pot) and save.
> 4. Copy all new files on .../locale/ to the last version.
>
> Is it correct?
> May I proceed with this?
>
> Best regards, Rafael.
>
> ------------------------------------------------------------------------------
> Shape the Mobile Experience: Free Subscription
> Software experts and developers: Be at the forefront of tech innovation.
> Intel(R) Software Adrenaline delivers strategic insight and game-changing
> conversations that shape the rapidly evolving mobile landscape. Sign up now.
> http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>



-- 
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T   +256 (0) 312 314 418
M +256 (0) 752 963 325
www.weberpafrica.com
Twitter: @TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk/

[WebERP-developers] To reconstruct the translation files

[Rafael C. <raf...@gm...>]

Hi Phil, Hi Exson,

With the changes in LanguagesArray.php and in FormDesigner.php, many
translation lines have been reduced (e.g. the translation of the language
name, the standardization of titles reduces the quantity of titles to
translate, etc.).

Also, adding user-support in FormDesigner.php, some translation lines have
been added.

I think it is appropriate to reconstruct the translation files.

The procedure to do this is:
1. Copy all files from last version to a new webERP instalation.
2. Run .../Z_poRebuildDefault.php (Rebuild the System Default Language
File) with local language in "English - Great Britain".
3. <loop>Open each messages.po with a POEditor, update from a POT file
(.../locale/en_GB.utf8/LC_MESSAGES/messages.pot) and save.
4. Copy all new files on .../locale/ to the last version.

Is it correct?
May I proceed with this?

Best regards, Rafael.

[WebERP-developers] To reconstruct the translation files.

[Rafael C. <raf...@gm...>]

Hi Phil, Hi Exson,

With the changes in LanguagesArray.php and in FormDesigner.php, many
translation lines have been reduced (e.g. the translation of the language
name, the standardization of titles reduces the quantity of titles to
translate, etc.).

Also, adding user-support in FormDesigner.php, some translation lines have
been added.

I think it is appropriate to reconstruct the translation files.

The procedure to do this is:
1. Copy all files from last version to a new webERP instalation.
2. Run http://www.verdoramas.biz/weberp/Z_poRebuildDefault.php (Rebuild the
System Default Language File) with local language in "English - Great
Britain".
3. <loop>Open each messages.po with a POEditor, update from a POT file
(.../locale/en_GB.utf8/LC_MESSAGES/messages.pot) and save.
4. Copy all new files on .../locale/ to the last version.

Is it correct?
May I proceed with this?

Best regards, Rafael.