web-erp-developers

[WebERP-developers] Statement of cash flows.

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

Hi,

Any of you have worked to show a statement of cash flows of the company for
a range of periods entered ?

I am looking for a general purpose script to generate a statement of cash
flows.

Jonathan Kiranga has developed that module in another application, that ran
on vfp FoxPro but not in webERP.

In this moment, I have two groups of requirements very different:
* Accounting people: They want periods in months (at end-of-month, by group
of months) like other statements in webERP (statement of financial
position, and statement of comprehensive income), and a net use and
generation (each account shown as cash-in or a cash-out).
* Treasury and Audit people: They want periods in days (at end-of-day, by
group of days) and a separated use and generation (for each account, the
cash generated and the cash used in different lines).

I will appreciate any info, comment or help about this topic.

Best regards, Rafael.

[WebERP-developers] Fwd: Statement of cash flows.

[gilberto d. s. a. <gs...@gm...>]

---------- Forwarded message ----------
From: gilberto dos santos alves <gs...@gm...>
Date: 2015-03-03 0:17 GMT-03:00
Subject: Re: [WebERP-developers] Statement of cash flows.
To: webERP Developers <web...@li...>


if i understand what you want, i use general ledger accounts for control
payments, returns, parcels of what we will pay, lets give some examples to
discuss.

all these are reports fragments that may use cash flow accountings, general
ledger account of some vendor or any control that you want.

are standard on weberp.

see details on description of transaction history for account 1410 and 1060
look for vendor t202 and nf451102 for receive july-2014, payments 08-2014,
09-2014 and 10-2014


...
Pagto Credores13407.08.20142.498,83T202-nf451102 dp1 ac121


t202 is vendor
nf451102 is #nfe (fiscal document number)
dp1 (is payment 1/3 (remain more 2 payments) 2.498,83 * 3 parcelas (dp2,
dp3)
advice to vendor = 121

worflow of transactions are report 999 (ordered by 3 digits) for better
understand.

here are reports [1]
and
purchase order for vendor t202 [2]

[1]
https://drive.google.com/folderview?id=0B7RGseydrhtyfjlSZ2RVZHZZU25lMEhVejlSSzEyQUpSRS1ocWlBQUlHT3JReUY1VkZwMTg&usp=sharing

[2]
https://drive.google.com/file/d/0B7RGseydrhtyeFJXSENodmh6Rzg/view?usp=sharing




2015-03-02 14:05 GMT-03:00 Rafael Chacón <raf...@gm...>:

> Hi,
>
> Any of you have worked to show a statement of cash flows of the company
> for a range of periods entered ?
>
> I am looking for a general purpose script to generate a statement of cash
> flows.
>
> Jonathan Kiranga has developed that module in another application, that
> ran on vfp FoxPro but not in webERP.
>
> In this moment, I have two groups of requirements very different:
> * Accounting people: They want periods in months (at end-of-month, by
> group of months) like other statements in webERP (statement of financial
> position, and statement of comprehensive income), and a net use and
> generation (each account shown as cash-in or a cash-out).
> * Treasury and Audit people: They want periods in days (at end-of-day, by
> group of days) and a separated use and generation (for each account, the
> cash generated and the cash used in different lines).
>
> I will appreciate any info, comment or help about this topic.
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>


-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil







-- 
gilberto dos santos alves
+55(11)9-8646-5049
sao paulo - sp - brasil

Re: [WebERP-developers] Fwd: Statement of cash flows.

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

Hi Gilberto:

Thank you, very much, for your comments.

Yes, you are right.

* While Accounting people want those statements to send them to managers,
shareholders, tax-offices and banks-offices {they want turn on/off show
budget; an easy to add feature to all statements},
* Treasury and Audit people use the statement of cash flows --as you point
out-- to control sales, credit, collect (receivables), payments, etc. In
some cases, the responsibilities for the accounts are segmented. As
example, receivables: debits (funds use) on sales people and credits (funds
generation) on collect people. This is the reason they want a "separated
basis" (instead of "net basis") for showing accounts {other requirement:
select net/separated basis}.

For a net-basis and periods-in-months, we have 2 possibilities:
1. To use chartdetails table (as in GLBalanceSheet.php and in
GLProfit_Loss.php); or
2. To use gltrans table.

For a "separated-basis" and periods-in-days, we have only 1 possibility:
1. To use gltrans table.

Other comments:
* Show budget (Turn on) is possible if periods are in months (budget is
net-basis and monthly-basis in chartdetails table).


If anyone else has comments, suggestions or comments, I appreciate much to
let me know.

Best regards, Rafael.


2015-03-02 21:28 GMT-06:00 gilberto dos santos alves <gs...@gm...>:

>
> ---------- Forwarded message ----------
> From: gilberto dos santos alves <gs...@gm...>
> Date: 2015-03-03 0:17 GMT-03:00
> Subject: Re: [WebERP-developers] Statement of cash flows.
> To: webERP Developers <web...@li...>
>
>
> if i understand what you want, i use general ledger accounts for control
> payments, returns, parcels of what we will pay, lets give some examples to
> discuss.
>
> all these are reports fragments that may use cash flow accountings,
> general ledger account of some vendor or any control that you want.
>
> are standard on weberp.
>
> see details on description of transaction history for account 1410 and
> 1060 look for vendor t202 and nf451102 for receive july-2014, payments
> 08-2014, 09-2014 and 10-2014
>
>
> ...
> Pagto Credores13407.08.20142.498,83T202-nf451102 dp1 ac121
>
>
> t202 is vendor
> nf451102 is #nfe (fiscal document number)
> dp1 (is payment 1/3 (remain more 2 payments) 2.498,83 * 3 parcelas (dp2,
> dp3)
> advice to vendor = 121
>
> worflow of transactions are report 999 (ordered by 3 digits) for better
> understand.
>
> here are reports [1]
> and
> purchase order for vendor t202 [2]
>
> [1]
> https://drive.google.com/folderview?id=0B7RGseydrhtyfjlSZ2RVZHZZU25lMEhVejlSSzEyQUpSRS1ocWlBQUlHT3JReUY1VkZwMTg&usp=sharing
>
> [2]
> https://drive.google.com/file/d/0B7RGseydrhtyeFJXSENodmh6Rzg/view?usp=sharing
>
>
>
>
> 2015-03-02 14:05 GMT-03:00 Rafael Chacón <raf...@gm...>:
>
>> Hi,
>>
>> Any of you have worked to show a statement of cash flows of the company
>> for a range of periods entered ?
>>
>> I am looking for a general purpose script to generate a statement of cash
>> flows.
>>
>> Jonathan Kiranga has developed that module in another application, that
>> ran on vfp FoxPro but not in webERP.
>>
>> In this moment, I have two groups of requirements very different:
>> * Accounting people: They want periods in months (at end-of-month, by
>> group of months) like other statements in webERP (statement of financial
>> position, and statement of comprehensive income), and a net use and
>> generation (each account shown as cash-in or a cash-out).
>> * Treasury and Audit people: They want periods in days (at end-of-day, by
>> group of days) and a separated use and generation (for each account, the
>> cash generated and the cash used in different lines).
>>
>> I will appreciate any info, comment or help about this topic.
>>
>> Best regards, Rafael.
>>
>>
>> ------------------------------------------------------------------------------
>> Dive into the World of Parallel Programming The Go Parallel Website,
>> sponsored
>> by Intel and developed in partnership with Slashdot Media, is your hub
>> for all
>> things parallel software development, from weekly thought leadership
>> blogs to
>> news, videos, case studies, tutorials and more. Take a look and join the
>> conversation now. http://goparallel.sourceforge.net/
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>
>
> --
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
>
> --
> gilberto dos santos alves
> +55(11)9-8646-5049
> sao paulo - sp - brasil
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
>