Hello All,
I am having some issues with Date and Time when generating reports.
I fully understand that by default Odoo stores all information in its Database in UTC format where as when I see the form view it shows the correct time & date as per timezone of the user.
The timezone of my server is set PKT (GMT+5), and the same time is set in postgresql.conf.
Lets suppose its 12.01 AM 25 July and I make any purchase order at that moment; and if I generate any report to see all the purchase orders made on 25 July it will NOT show this record as in Odoo Database this transaction was stored in UTC which is 7.01 PM 24 July. So this transaction will appear in the report for 24 July but as per me it was made on 25 July.
This is one just example, this is something happening on almost everything.
Can any one be kind enough to help me fix this issue in my modules.
I am using a few custom modules on as well on Odoo CE V11 and I am really looking forward to your expert advise.
Please help me.
Thanks