[7.0/trunk] Opening With Last Closing Balance error

[Francisco Martinez]

Hello,
when use a payment method for POS with the "Opening With Last Closing Balance" option checked, it works incorrectly. I test it a lot of times and it opens the cash session with a incorrect value (it is not the last). The value which opens is earlier than the last.
The code used when create the new cash session is (account_cash_statement.py at line 203):

                last_bank_statement_ids = self.search(cr, uid, domain, limit=1, order='create_date desc', context=context)

The "order by" is based on the create_date column of the table 'account_bank_statement'. This column saves the time including millisecs with 6 digits and Python did not understand to order for. The column 'closing_date' is the best candidate to improve the result:

                last_bank_statement_ids = self.search(cr, uid, domain, limit=1, order='closing_date desc', context=context)

It works correctly.

Regards
Fco.

[Hiral Patel (OpenERP) (hip-openerp)]

Hello Francisco Martinez,

I have checked your issue and got the same problem. I have attached the video to reproduce it.

Thanks for reporting.

[Ishwar Malvi(OpenERP) (ima-openerp)]

Hello,

  It has been fix committed in https://code.launchpad.net/~openerp-community/openobject-addons/trunk-bug-1102217 branch.
  Revision No: 8546.
  Revision ID: <email address hidden>

  It will be available in trunk soon.

Thanks,
Ishwar Malvi