Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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
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 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 1/24/14, 8:27 AM|
|Seen: 687 times|
|Last updated: 3/16/15, 8:10 AM|