Re: [WebERP-developers] AnalysisHorizontalPosition.php

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

*** See
http://unstable.verdorama.systems/downloads/AnalysisHorizontalIncome%20%282015-08-04%29.zip
for attachment ***

Best regards, Rafael.

----------
2015-08-13 8:01 GMT-06:00 Rafael Chacón <raf...@gm...>:

> Hi Ricard,
>
> 1) New script instead of to modify GLBalanceSheet.php script:
> Two "local" reasons:
> (a) Here, we plan to have a set of horizontal analysis (for statement of
> financial position, for statement of comprehensive income, for statement of
> changes in equity, and for statement of cash flows). A script to generate
> from one to all of them. The first step is to have a script for each
> horizontal analysis; the second is to create a script to select the
> horizontal analysis to generate (a “master” script) and to modify previous
> scripts (make them as “subroutine” scripts). Obviously, we have also to
> create scripts for a statement of changes in equity, and for statement of
> cash flows.
> (b) there are different users between
> GLBalanceSheet/AnalysisHorizontalPosition and
> GLProfit_Loss/AnalysisHorizontalIncome. Each addressee wants to see some
> columns and others do not. This involves to turn on/off some columns. We do
> not want to complicate these scripts (especially the formatting).
>
> 2) On the % of variation, some attention to signs must be improved:
> Yes, we are including a footnote to explain: (a) meaning of signs in
> Absolute variation; and (b) meaning of signs in Relative variation.
> In case of the Horizontal Analysis of Statement of Comprehensive Income,
> it is easy to understand: (*) positive absolute variation = increases the
> Net Profit; negative = decreases. (**) positive relative variation = the
> amount of the account increases; negative = decreases.
>
> I enclose AnalysisHorizontalPosition.php, if you want to test it and
> comment it.
> I warn you that this script does NOT have sections 1 and 2 (I'm fixing
> this). This “bug” occurred because we overwrite sections 1 and 2 (we use a
> section for “Gross profit” with an income and a cost groups).
>
> Best regards, Rafael.
>
>
> 2015-08-11 19:50 GMT-06:00 Pak Ricard <pak...@gm...>:
>
>> Hi Rafael:
>>
>> I've been playing with your new AnalysisHorizontalPosition.php script and
>> looks very good. Thanks for sharing it!
>>
>> Just 2 questions:
>>
>> 1) Why don't modify directly the GLBalanceSheet.php script, so the
>> variation column and % column are shown always in the BS? Like this we
>> should only maintain 1 script not 2 very similar. (I'm lazy, so that's why
>> I always look for reduction of code lines to maintain).
>>
>> 2) On the % of variation, some attention to signs must be improved. I'm
>> not accountant so not sure if I'm right or not.
>>
>> Take the example below of a bank account. Last year we had -705.000 IDR
>> (we owed the bank) and this year 4.745.000 IDR. The variation in IDR is
>> right, but I dare say that the bank account increased by +773%, not -
>>
>> 1212121212Cash bank IDR4,745,000-705,0005,450,000-773%
>> but if the variation had been on the other side (from + last year to -
>> this year), it would be correct to use the - sign). Also I guess it should
>> be opposite for liabilities.
>>
>> Regards,
>> Ricard
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>