openerp-india team mailing list archive

["Amit Parik \(OpenERP\)" <amp@xxxxxxxxxxx>]

Hello Stefan,

Thanks for the fix!
Our Core team will review your branch!


** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: New => Fix Committed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

-- 
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/1210524

Title:
  [6.1, 7.0, account] Aged partner balance off by one day wrt.
  reconciliations

Status in OpenERP Addons (modules):
  Fix Committed

Bug description:
  account/report/account_aged_partner_balance.py does a lot of queries
  in the form of

      WHERE account_move_reconcile.create_date > %s

  where the report start date (e.g. '2013-08-09') is substituted in the
  argument. Of course, create_date is not a field of type date but of
  datetime. A datetime argument like '2013-08-09' constitutes the
  *start* of the day, so that the expression is actually true for any
  time on that very day. The effect is that reconciliations of the start
  date of the report are ignored, and the amounts of the reconciled move
  lines will feature in the report.

  Accountants checking the results of the reconcilations that they just
  made may be surprised (if not worried).

  A solution could be to craft the query arguments in the form of
  '2013-08-09 23:59:59', so that reconciliations created on the report
  start date are taken into account.

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