Odoo Help


Point of sale refunds in account_bank_statement_line table in OpenERP 6.1 having false date

Alloice Lagat
on 1/24/14, 8:27 AM 993 views

Hello, I am creating a report for point of sale to get the total refunds made in a day, and so i queried the table account_bank_statement_line to get the amount, but the date for the refunds i.e Order 137667889 REFUND shows a date i.e 2014-01-20 and yet the that it was created was today i.e 2014-01-24, the date for other Orders i.e Order 137667889 is ok, So is there a bug on how the current date is not being captured by the refunds? the create_date and write_date are ok, its only the date column that is wrong, so it means if i want to get the refunds for a day, i wont get it since it will be having a date that is not for today.

Below is The query and the output

SELECT id,create_date,write_date,date,ref,amount
  FROM account_bank_statement_line where ref like '%%REFUND' order by id desc;


id      |create_date        |write_date    |date    |ref       |   amount
7201;"2014-01-22 12:17:39.57431";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390385908531 REFUND";-1200.00
7144;"2014-01-22 08:36:24.819073";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390378507908 REFUND";-4000.00
7134;"2014-01-22 08:10:08.37137";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390369891636 REFUND";-3500.00
7104;"2014-01-22 06:22:18.093536";"2014-01-22 14:24:26.828939";"2014-01-20";"Order 1390208029693 REFUND";-3600.00

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 1/24/14, 8:27 AM
Seen: 993 times
Last updated: 3/16/15, 8:10 AM