Odoo Help

Welcome!

This community 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.

0

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

By
Alloice Lagat
on 1/24/14, 8:27 AM 649 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;

Output

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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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