[tryton] Re: version 4 GL & balance reports

2016-12-03 Thread Richard PALO 

Le 04/12/2016 à 04:06, Cédric Krier a écrit :

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.



This is what more or less what I concluded.

We have easily 20-30K general ledger entries per year (ignoring analytic)
which I consider small to medium for an SME.

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).
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).
In any event, one must not be myopic as to the number of fiscal years.


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 GL it is typically an additional line prior to the moves for the period.


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... But have 
you tried to select only used
accounts (say 200-300) out of 1200 in e.g. the French accounting plan?


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.
There are many examples such as in SAGE, CEGID, Unit4(if I remember well) 


--
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/44348d34-6f55-7f8c-528c-d2c14083bd5a%40netbsd.org.

Re: [tryton] Invoice Location

2016-12-03 Thread Carlos Eduardo Sotelo Pinto 
List

Summarizing, about invoicing on peru.

- There is two kind of invoices: Invoice and Simple Invoice
- There is no difference on accounting or tax policies for both types
- Differences on both invoices are based on make a restriction refered to
the Party Type or party Identifier [ Companies and No Companies ]
- Each invoice type have different printying document

Best regards




2016-12-03 21:46 GMT-05:00 Carlos Eduardo Sotelo Pinto <
carlos.sotelo.pi...@gmail.com>:

> Hi Cedrik, List
>
> Yes Cedirk, you are right, there is no difference on accounting, just on
> the printing, on this way:
>
> - Simple invoice, no taxes must be printed, but the taxes are the same
> - Commercial invoice, taxes printing is mandatory as a common invoice.
>
> I guess, the main difference is relted to party, no the invoice at itself.
> As the information provided and the ER diagram, Party could be categorized
> on :
>
> - Companies, which one just could request for a common or commercial
> invoice
> - No companies, this kinds of partyes couldnt request the common invoice,
> just simple invoice
>
> As explained on before, I am using just a difference on the printing, and
> I use a extra field like "Invoice document type", then I could choice which
> one will be the final printing. However this is no making a real difference
> between the parties related, since I could select a non company and use the
> common invoice, do you make send?
> What I need is to make a diference related to the party bases on the Party
> Type of identifier. Parties provide a many to many relation ship for
> identifiers, but I need a many to one relationshiop.
>
> A common ER Diagram used for invoicing software is like the provided on my
> attachment, where a party dependence based on the id document type could be
> used. Finaly the invoice type  ( or invoice document type ) could be
> restricted based on the party document type, that is what I am looking for.
>
> My question is about a suggest in order to do a right locale
> custommization, since I will let this module as free for the comunity, and
> I am interested on maked it as much as as posisble as trytonic could be
> done.
>
> I have done some invoicing modules as explained on before, that make no
> sense for the final users, and I countinue making maintenance, but this
> build as a gpl module, musty be tested and 100% trytron
>
> Best regards
>
>
>
>
>
> ​
>
>
> 2016-12-03 21:25 GMT-05:00 Cédric Krier :
>
>> On 2016-12-03 08:51, Carlos Eduardo Sotelo Pinto wrote:
>> > Hello People
>> >
>> > I am working on a location for the invoice module. I refer to peruivian
>> > location, and I have this issue:
>> >
>> > We have two kind of out invoices on the printing, but accountant
>> behavior
>> > is the same, however the party customer is different
>> >
>> > - Comercial Invoice (FACTURA), just for Companies
>> > - Simple Invoice (BOLETA DE VENTA), just for Non Companies
>> >
>> > Both of the aaplyes the same taxes, however on the Simple Invoice, is no
>> > necesary to specify the tax ammount.
>> >
>> > Refered to Party, since on Tryton have *Identifiers*, is no necesary to
>> > manage identifiers, however, bahavior is no the same, since on this way
>> on
>> > manage indentifiers, let the prty manage more than once, however, party
>> > just have once identifier, legal identifiers are:
>> >
>> > * 0 | DOC.TRIB.NO.DOM.SIN.RUC
>> > * 1 | DOC. NACIONAL DE IDENTIDAD
>> > * 4 | CARNET DE EXTRANJERIA
>> > * 6 | REG. UNICO DE CONTRIBUYENTES
>> > * 7 | PASAPORTE
>> > * A | CED. DIPLOMATICA DE IDENTIDAD
>> >
>> >
>> > ID 6 Is just for Companies, then Comercial INvoices are just for them
>> >
>> >
>> > Until now, on a  previous locale version, I have been working on this
>> way:
>> >
>> > - Just one invoice, two different reports, and m,anage indentifiers
>> using
>> > tryton identifiers. The main issue, any kind of customer could have
>> invoice
>> > or simple invoice, and make some errors on the people who will operate
>> the
>> > erp, then I thinking on changing the design
>> >
>> > Any suggest?
>>
>> You did not describe what are the differences between both types of
>> invoices except that tax amount is not necessary but I guess having it
>> it not a problem.
>>
>> --
>> 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/ms
>> gid/tryton/20161204022554.GD52356%40tetsuo.
>>
>
>
>
> --
> Carlos Eduardo Sotelo Pinto
> Senior Software Developer
> Claro RPC +51 989550602
> GTalk: carlos.sotelo.pi...@gmail.com | Skype: csotelop
> GNULinux RU #379182 | GNULinux RM #277661
>
> Please consider the environment before printing this email
> Join the campaign at http://thinkBeforePrinting.org
>



-- 
Carlos Eduardo Sotelo Pinto

Re: [tryton] Invoice Location

2016-12-03 Thread Carlos Eduardo Sotelo Pinto 
Hi Cedrik, List

Yes Cedirk, you are right, there is no difference on accounting, just on
the printing, on this way:

- Simple invoice, no taxes must be printed, but the taxes are the same
- Commercial invoice, taxes printing is mandatory as a common invoice.

I guess, the main difference is relted to party, no the invoice at itself.
As the information provided and the ER diagram, Party could be categorized
on :

- Companies, which one just could request for a common or commercial invoice
- No companies, this kinds of partyes couldnt request the common invoice,
just simple invoice

As explained on before, I am using just a difference on the printing, and I
use a extra field like "Invoice document type", then I could choice which
one will be the final printing. However this is no making a real difference
between the parties related, since I could select a non company and use the
common invoice, do you make send?
What I need is to make a diference related to the party bases on the Party
Type of identifier. Parties provide a many to many relation ship for
identifiers, but I need a many to one relationshiop.

A common ER Diagram used for invoicing software is like the provided on my
attachment, where a party dependence based on the id document type could be
used. Finaly the invoice type  ( or invoice document type ) could be
restricted based on the party document type, that is what I am looking for.

My question is about a suggest in order to do a right locale
custommization, since I will let this module as free for the comunity, and
I am interested on maked it as much as as posisble as trytonic could be
done.

I have done some invoicing modules as explained on before, that make no
sense for the final users, and I countinue making maintenance, but this
build as a gpl module, musty be tested and 100% trytron

Best regards





​


2016-12-03 21:25 GMT-05:00 Cédric Krier :

> On 2016-12-03 08:51, Carlos Eduardo Sotelo Pinto wrote:
> > Hello People
> >
> > I am working on a location for the invoice module. I refer to peruivian
> > location, and I have this issue:
> >
> > We have two kind of out invoices on the printing, but accountant behavior
> > is the same, however the party customer is different
> >
> > - Comercial Invoice (FACTURA), just for Companies
> > - Simple Invoice (BOLETA DE VENTA), just for Non Companies
> >
> > Both of the aaplyes the same taxes, however on the Simple Invoice, is no
> > necesary to specify the tax ammount.
> >
> > Refered to Party, since on Tryton have *Identifiers*, is no necesary to
> > manage identifiers, however, bahavior is no the same, since on this way
> on
> > manage indentifiers, let the prty manage more than once, however, party
> > just have once identifier, legal identifiers are:
> >
> > * 0 | DOC.TRIB.NO.DOM.SIN.RUC
> > * 1 | DOC. NACIONAL DE IDENTIDAD
> > * 4 | CARNET DE EXTRANJERIA
> > * 6 | REG. UNICO DE CONTRIBUYENTES
> > * 7 | PASAPORTE
> > * A | CED. DIPLOMATICA DE IDENTIDAD
> >
> >
> > ID 6 Is just for Companies, then Comercial INvoices are just for them
> >
> >
> > Until now, on a  previous locale version, I have been working on this
> way:
> >
> > - Just one invoice, two different reports, and m,anage indentifiers using
> > tryton identifiers. The main issue, any kind of customer could have
> invoice
> > or simple invoice, and make some errors on the people who will operate
> the
> > erp, then I thinking on changing the design
> >
> > Any suggest?
>
> You did not describe what are the differences between both types of
> invoices except that tax amount is not necessary but I guess having it
> it not a problem.
>
> --
> 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/20161204022554.GD52356%40tetsuo.
>



-- 
Carlos Eduardo Sotelo Pinto
Senior Software Developer
Claro RPC +51 989550602
GTalk: carlos.sotelo.pi...@gmail.com | Skype: csotelop
GNULinux RU #379182 | GNULinux RM #277661

Please consider the environment before printing this email
Join the campaign at http://thinkBeforePrinting.org

-- 
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/CAEhw%3DE_mRFgWdwECbHCRxytNzm3OYwEnAZ3EN4yD6N6%2BX0M1_A%40mail.gmail.com.

Re: [tryton] Re: version 4 GL & balance reports

2016-12-03 Thread Cédric Krier 
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.

Re: [tryton] Invoice Location

2016-12-03 Thread Cédric Krier 
On 2016-12-03 08:51, Carlos Eduardo Sotelo Pinto wrote:
> Hello People
> 
> I am working on a location for the invoice module. I refer to peruivian
> location, and I have this issue:
> 
> We have two kind of out invoices on the printing, but accountant behavior
> is the same, however the party customer is different
> 
> - Comercial Invoice (FACTURA), just for Companies
> - Simple Invoice (BOLETA DE VENTA), just for Non Companies
> 
> Both of the aaplyes the same taxes, however on the Simple Invoice, is no
> necesary to specify the tax ammount.
> 
> Refered to Party, since on Tryton have *Identifiers*, is no necesary to
> manage identifiers, however, bahavior is no the same, since on this way on
> manage indentifiers, let the prty manage more than once, however, party
> just have once identifier, legal identifiers are:
> 
> * 0 | DOC.TRIB.NO.DOM.SIN.RUC
> * 1 | DOC. NACIONAL DE IDENTIDAD
> * 4 | CARNET DE EXTRANJERIA
> * 6 | REG. UNICO DE CONTRIBUYENTES
> * 7 | PASAPORTE
> * A | CED. DIPLOMATICA DE IDENTIDAD
> 
> 
> ID 6 Is just for Companies, then Comercial INvoices are just for them
> 
> 
> Until now, on a  previous locale version, I have been working on this way:
> 
> - Just one invoice, two different reports, and m,anage indentifiers using
> tryton identifiers. The main issue, any kind of customer could have invoice
> or simple invoice, and make some errors on the people who will operate the
> erp, then I thinking on changing the design
> 
> Any suggest?

You did not describe what are the differences between both types of
invoices except that tax amount is not necessary but I guess having it
it not a problem.

-- 
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/20161204022554.GD52356%40tetsuo.

[tryton] Invoice Location

2016-12-03 Thread Carlos Eduardo Sotelo Pinto 
Hello People

I am working on a location for the invoice module. I refer to peruivian
location, and I have this issue:

We have two kind of out invoices on the printing, but accountant behavior
is the same, however the party customer is different

- Comercial Invoice (FACTURA), just for Companies
- Simple Invoice (BOLETA DE VENTA), just for Non Companies

Both of the aaplyes the same taxes, however on the Simple Invoice, is no
necesary to specify the tax ammount.

Refered to Party, since on Tryton have *Identifiers*, is no necesary to
manage identifiers, however, bahavior is no the same, since on this way on
manage indentifiers, let the prty manage more than once, however, party
just have once identifier, legal identifiers are:

* 0 | DOC.TRIB.NO.DOM.SIN.RUC
* 1 | DOC. NACIONAL DE IDENTIDAD
* 4 | CARNET DE EXTRANJERIA
* 6 | REG. UNICO DE CONTRIBUYENTES
* 7 | PASAPORTE
* A | CED. DIPLOMATICA DE IDENTIDAD


ID 6 Is just for Companies, then Comercial INvoices are just for them


Until now, on a  previous locale version, I have been working on this way:

- Just one invoice, two different reports, and m,anage indentifiers using
tryton identifiers. The main issue, any kind of customer could have invoice
or simple invoice, and make some errors on the people who will operate the
erp, then I thinking on changing the design

Any suggest?

Best regards

-

My ER Diagram is attached,













​

-- 
Carlos Eduardo Sotelo Pinto
Senior Software Developer
Claro RPC +51 989550602
GTalk: carlos.sotelo.pi...@gmail.com | Skype: csotelop
GNULinux RU #379182 | GNULinux RM #277661

Please consider the environment before printing this email
Join the campaign at http://thinkBeforePrinting.org

-- 
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/CAEhw%3DE9C96WEFJZxJrLcDbZTFZPryirB_N7hX6%3DnYzMk3fARpg%40mail.gmail.com.

[tryton-dev] Un-assigned Tryton issue tracker requests

2016-12-03 Thread Tryton issue tracker 
Created ID   Activity   Title
===
 bug
1 month ago 5954 1 week ago RPCException on windows   
 bug
3 weeks ago 6018 3 weeks ago Button with Eval('one2many_field') doe ...
 bug
2 months ago 5905 2 months ago Display bug in tryton client with ubun ...
 bug
3 months ago 5810 3 months ago Client crash when user name on Windows ...
 bug
14 months ago 5030 4 months ago Error connecting with Tryton client fr ...
 bug
21 months ago 4582 21 months ago Display datetime before epoch on windows  
 bug
24 months ago 4359 24 months ago Windows client error when image size i ...

To view or respond to any of the requests listed above, visit the URL

   https://bugs.tryton.org/

and click on "Show Unassigned". Do NOT respond to this message.

-- 
You received this message because you are subscribed to the Google Groups 
"tryton-dev" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton-dev/20161203230002.4549B1180086%40moretus.b2ck.com.

[tryton] Re: version 4 GL & balance reports

2016-12-03 Thread Richard PALO 

Le 27/05/2016 à 09:42, Richard PALO a écrit :

As indicated https://bugs.tryton.org/issue5168 I'm trying to see how to 
approach (as suggested) under 4.0
a function field 'searcher' that operates on 'sum' fields as the patch which 
worked on 3.8 no longer does.

The issue is that since 4.0 the balance and GL reports are huge and, as such, 
somewhat unuseable as they
include *all* accounts, including those with a start balance of 0 *and* no 
movements (D/C).

Under the French plan (PCG), I have for example in a company a balance 
generating 40 pages of output
for only 28 accounts usually printing on two pages.

NB: there are over 1200 accounts defined in the French plan

The General Ledger prints 948 pages (!) mostly throw away.

It should be possible to generate [periodic] balance or GL reports including 
only the
movements in the period (thus without start balance) as well.

This, unfortunately, has turned into a blocker to migrate production to 4.0 for 
the moment.

How would a 'searcher' be able to do this in the first place?
Is there a good example already implemented in the existing modules to take a 
look at?

To me, it still seems more logical to have a global 'default' option 'with 
start balance'
and only, always, generate accounts with movements.

(That is, generating 'all' accounts is perhaps something that could better be 
done from
configure->accounts or perhaps a even a new report under account plan)

I'd like to solicit other experiences/observations/suggestions from the 
community.

cheers



Given that 4.2+ will be the basis for any future platform certification
(in particular for purposes of legal requirements in France),
I'd like to renew the call to see if anybody has worked on adding the
afore mentioned options to general ledger and balance reports.

Having not had more than cursory time myself, perhaps a crowd funding approach 
is more
appropriate.  We would certainly participate!

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
3. with movements (in the period)

seems there should probably also be an option simply to include or not the 
'start balance' as well
while suppressing the non-intuitive behaviour currently of 4.x selecting by 
default only the first account.

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.

cheers
--

Richard PALO

--
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/9ec3822d-efbd-b779-cec6-095d4fdf20a9%40netbsd.org.