← Back to team overview

openerp-india team mailing list archive

Re: [Bug 1219381] Re: [7.0 Trunk] Closing fiscal Year generate inconsistency in Total Payable and Total Receivable computation on Partner Form

 

Pedro.


2013/10/18 Pedro Manuel Baeza <pedro.baeza@xxxxxxxxx>

> Sorry to get too late to this, but I don't think the solution provided
> is the most suitable., because you are assumming that there is a copy of
> the account.move.line in the current fiscal year that corresponds to the
> open balance of previous fiscal years, but this doesn't have to be true
> for all countries and legislations. That's why there are another fiscal
> year closing wizards distributed along localizations.


Can you show me one law in Spain "For example" where the closing Account
Move can not have a copy of the move "not reconciled" in the past fiscal
year?.

AFAIK: the openening balance in normal Accounting "Not fiscal one" it is
possible, but I don't know if it is by  law or by best practice?

Add this information to be sure give the correct argument to Martin
please.

For us I really prefer Sum the "original" as I did, but I don't know if it
bring other problems.

@martin:

A second scenario where i see problem.

What happen 1/jan of the year, where the "Auditing Closing Process" was not
done yet, in 100% of my customers the really close the fiscal year In
march, not in december.

It is an operative problem, and my patch correct it......

Sorry I miss this point and the Pedro ones.

Thanks Pedro, Thanks Martin.

>
> The initial solution provided by Nhomar was the one I propose because I
> think is the universal solution. You are talking about the problem in
> performance including all the fiscal years, but there is no such a
> problem because inmediately on the same query you are restricting to
> only not reconciled entries, so the number of the results is the same
> and the speed of the query is very similar.
>
> Please reconsider the patch.
>
> Regards.
>
> ** Changed in: openobject-addons
>        Status: Fix Committed => In Progress
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1219381
>
> Title:
>   [7.0 Trunk] Closing fiscal Year generate inconsistency in Total
>   Payable and Total Receivable computation on Partner Form
>
> Status in OpenERP Addons (modules):
>   In Progress
>
> Bug description:
>   The problem.
>
>   When we make the close Fiscal Year process and close the fiscal year
>   all "Total Payable" and "Total Reaceivable" fields on partners go to
>   0.
>
>   How to reproduce the problem.
>
>   1.- Install Accounting - Custom chart of account.
>   2.- Create a New fiscal year (One Year BEfore) let's say 2012 and all
> them periods.
>   3.- Generate a Customer invoice lets say "August 2012" for 1000.
>   4.- Partner Form looks Ok, Total Receivable 1000.
>   5.- Go to "Generate Opening En..." on End of period menu in Account run
> the wizard answering the questions.
>   6.- Close the Fiscal year in the menu "Close a Fiscal Year" under the
> same path.
>
>   What do i got:
>
>   7.- Go to Partner Form, "Total Receivable is 0".
>
>   What  do i expect:
>
>   7.- Go to Partner Form, "Total Receivable is 1000".
>
>   I made a video with the explanation all menus in english, i think it
>   it pretty clear if not, i can put subtitles becaus the speach is in
>   spanish.
>
>   http://youtu.be/xYkQdFV1THM
>
>   It is affecting all our migrations and generating some problems in our
>   workflows that use this Fields as "Control Fields" for Workflows.
>
>   I will propose a patch, and a MP. @Thanks to Pedro Baeza from Openerp
>   Spanish Community.
>
>   The Patch: https://launchpadlibrarian.net/149063580/patch.diff
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/1219381/+subscriptions
>


-- 
--------------------
Saludos Cordiales

Nhomar G. Hernandez M.
+58-414-4110269
Skype: nhomar00
Web-Blog: http://geronimo.com.ve
Servicios IT: http://vauxoo.com
Linux-Counter: 467724
Correos:
nhomar@xxxxxxxxxxxxxx
nhomar@xxxxxxxxxx
twitter @nhomar

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1219381

Title:
  [7.0 Trunk] Closing fiscal Year generate inconsistency in Total
  Payable and Total Receivable computation on Partner Form

Status in OpenERP Addons (modules):
  In Progress

Bug description:
  The problem.

  When we make the close Fiscal Year process and close the fiscal year
  all "Total Payable" and "Total Reaceivable" fields on partners go to
  0.

  How to reproduce the problem.

  1.- Install Accounting - Custom chart of account.
  2.- Create a New fiscal year (One Year BEfore) let's say 2012 and all them periods.
  3.- Generate a Customer invoice lets say "August 2012" for 1000.
  4.- Partner Form looks Ok, Total Receivable 1000.
  5.- Go to "Generate Opening En..." on End of period menu in Account run the wizard answering the questions.
  6.- Close the Fiscal year in the menu "Close a Fiscal Year" under the same path.

  What do i got:

  7.- Go to Partner Form, "Total Receivable is 0".

  What  do i expect:

  7.- Go to Partner Form, "Total Receivable is 1000".

  I made a video with the explanation all menus in english, i think it
  it pretty clear if not, i can put subtitles becaus the speach is in
  spanish.

  http://youtu.be/xYkQdFV1THM

  It is affecting all our migrations and generating some problems in our
  workflows that use this Fields as "Control Fields" for Workflows.

  I will propose a patch, and a MP. @Thanks to Pedro Baeza from Openerp
  Spanish Community.

  The Patch: https://launchpadlibrarian.net/149063580/patch.diff

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1219381/+subscriptions


References