Re: [tryton] Re: version 4 GL & balance reports
Le 04/12/2016 à 12:30, Cédric Krier a écrit : On 2016-12-04 07:59, Richard PALO wrote: As a side note, seems a bit heavy if tryton needs to read all previous years to get starting balance (I most certinaly hope not). It is not heaving and indeed it is even a speedup. I see, account_account_deferral comes in for caching here. Great. 3. with movements (in the period) This could probably be done by creating a Function field that returns the number of moves. seems there should probably also be an option simply to include or not the 'start balance' as well Do you mean that you want to have a column with debit - credit ? Well, for a balance report, it is useful to have either extra column for initial balance, or both debit and credit, but this is probably a simple matter of report formatting which could be site specific. For me, it is not necessary on trial balance because the goal is to show that the accounts are balanced so if start and and balance sum equals 0 and debit equals credit sum, it is OK. To be clear, what I meant about including or not 'start balance' is for the case where an extract is requested of only the mouvements during the period should show up on 'end balance' In this case, 'start balance' column is not used in computing the 'end balance', and needs not be included, but if displayed, the values should necessarily be '0,00'. with 'start balance' Account | Start Balance | Debit | Credit | Debit - Credit - Start Balance (like now) without Account | 0,00 | Debit | Credit | Debit - Credit or simply (facultive) Account | Debit | Credit | Debit - Credit For GL it is typically an additional line prior to the moves for the period. There is already. yes, indeed... but the request is similar. while suppressing the non-intuitive behaviour currently of 4.x selecting by default only the first account. That's default behaviour to select the first record, I do not think it will change. For a report, this is not intuitive though perhaps a 'selection only' option that limits output to what is selected on the screen could continue to provide current behaviour... It is better to have always the same behaviour in the all application. Any action applies on what is selected. Well, normally, selection is an active process. But when these missing filters are available, they can be saved and this process will be much improved. But have you tried to select only used accounts (say 200-300) out of 1200 in e.g. the French accounting plan? Use the filters. I guess that brings us back to the subject at hand ;-) There seems to miss as well a means to be able to select only non-reconciled entries (relative to the accounting year), which appears to be a crucial need expressed by accountants and legal auditors. I do not understand exactly what you mean. For me, there is no sense to care about non-reconciled per fiscal year. Also I do not see the point to care about them individually, we have the Aged Balance for that. Balance is not interesting for this, although auxiliary balance/GL is also necessary, what is expected is a GL *detailing* only non-reconciled entries, typically for year-end (or periodic situation) closing. What is the point? It is useless in Tryton because non-deferral lines stay. Well, as already mentioned prior (I believe in tryton-fr and in the issue tracker), the accountant and legal auditor ask for it, as well as the decision maker who wants a report of only these 'open' entries, for readability purposes. cordially, -- Richard PALO -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/cec71e2f-e789-3f28-14cc-a7a631330b46%40netbsd.org.
Re: [tryton] Re: version 4 GL & balance reports
On 2016-12-04 07:59, Richard PALO wrote: > As a side note, seems a bit heavy if tryton needs to read all previous > years to get starting balance (I most certinaly hope not). It is not heaving and indeed it is even a speedup. > This is one of the benefits of having an annual opening balance as is > traditionnally done (not to mention it expressly provides for independent > accounting years, a fundamental principle in accounting). This is not the design chosen by Tryton because it breaks any attempt to track receivable or payable. > In any event, one must not be myopic as to the number of fiscal years. Do not understand. > > > 3. with movements (in the period) > > > > This could probably be done by creating a Function field that returns > > the number of moves. > > > > > seems there should probably also be an option simply to include or not > > > the 'start balance' as well > > > > Do you mean that you want to have a column with debit - credit ? > > > > Well, for a balance report, it is useful to have either extra column for > initial balance, or both debit and credit, > but this is probably a simple matter of report formatting which could be site > specific. For me, it is not necessary on trial balance because the goal is to show that the accounts are balanced so if start and and balance sum equals 0 and debit equals credit sum, it is OK. > For GL it is typically an additional line prior to the moves for the period. There is already. > > > while suppressing the non-intuitive behaviour currently of 4.x selecting > > > by default only the first account. > > > > That's default behaviour to select the first record, I do not think it > > will change. > > > > For a report, this is not intuitive though perhaps a 'selection only' option > that limits output to what is > selected on the screen could continue to provide current behaviour... It is better to have always the same behaviour in the all application. Any action applies on what is selected. > But have you tried to select only used > accounts (say 200-300) out of 1200 in e.g. the French accounting plan? Use the filters. > > > There seems to miss as well a means to be able to select only > > > non-reconciled entries (relative to the > > > accounting year), which appears to be a crucial need expressed by > > > accountants and legal auditors. > > > > I do not understand exactly what you mean. For me, there is no sense to > > care about non-reconciled per fiscal year. Also I do not see the point > > to care about them individually, we have the Aged Balance for that. > > > > Balance is not interesting for this, although auxiliary balance/GL is also > necessary, > what is expected is a GL *detailing* only non-reconciled entries, typically > for year-end > (or periodic situation) closing. What is the point? It is useless in Tryton because non-deferral lines stay. -- Cédric Krier - B2CK SPRL Email/Jabber: cedric.kr...@b2ck.com Tel: +32 472 54 46 59 Website: http://www.b2ck.com/ -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20161204113016.GE71015%40tetsuo.
Re: [tryton] Re: version 4 GL & balance reports
On 2016-12-03 13:37, Richard PALO wrote: > Anybody get further into prototype mode in order to propose a blueprint > supporting, > in addition to 'all' as is currently: > 1. with 'start balance <> 0' > and/or > 2. with 'end balance <> 0' > and/or I think written is quite complex because it is a SQL SUM but with cumulate of previous fiscal year. So I think probably the easiest will be to write a searcher that will filter the records using python evaluation for each record. This is not very performant but it should be OK as the number of account should not be too large. > 3. with movements (in the period) This could probably be done by creating a Function field that returns the number of moves. > seems there should probably also be an option simply to include or not the > 'start balance' as well Do you mean that you want to have a column with debit - credit ? > while suppressing the non-intuitive behaviour currently of 4.x selecting by > default only the first account. That's default behaviour to select the first record, I do not think it will change. > There seems to miss as well a means to be able to select only non-reconciled > entries (relative to the > accounting year), which appears to be a crucial need expressed by accountants > and legal auditors. I do not understand exactly what you mean. For me, there is no sense to care about non-reconciled per fiscal year. Also I do not see the point to care about them individually, we have the Aged Balance for that. -- Cédric Krier - B2CK SPRL Email/Jabber: cedric.kr...@b2ck.com Tel: +32 472 54 46 59 Website: http://www.b2ck.com/ -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/20161204030606.GA71015%40tetsuo.
