Community mailing list archives

community@mail.odoo.com

Re: Order Date problem in POS

by
Alien Group Lda, Aires Silvestre
- 09/30/2016 11:03:02
Could see the revision e9b1254a. Even before all this started the build was far later May.

Adding more detailed info. It all started when last Saturday we performed a maintenance that included:
  • Update of all Fedora packages. Again, F24, 64bit

Now we have scenarios like this:

Pos Order:
Check the Order Date is 09/30/2016 11:53:38, later on in the next screenshot look at the create date in the metadata




Now the metadata of this Pos Order, the create_date is 09/30/2016 14:16:37




Another pattern we noticed is that in the postgres database, for the date_order column, some values have milliseconds and other don't. These entries without millisecond are those right, see rows 11, 12, and 13. In rows 11,12 and 13 we have date_order = create_date and in the other rows,





Furthermore, performed a psql -l and right now we are getting this:


We always use 'UTF8' for Encoding and 'en_US.utf8' for Collate and Ctype and now we noticed that pt_BR... wired.

Any ideas?

On 09/30/2016 11:23 AM, Martin Trigaux wrote:
On 30/09/16 11:48, Aires Silvestre wrote:
> We're facing an issue in some Point of Sales regarding the field Order
> Date that is saved in model pos.order right after a sale in confirmed.
>
> Those POS run in Odoo V9 C, Fedora 24 64bit. It started from the moment
> we updated Fedora packages and the Odoo build (build 29 September,
> yesterday).
>
> Right after the sale is confirmed in the POS session, the instance of
> pos.order is recorded with a wrong date in the field date_order. The
> date recorded differs from the current time it is recorded, several
> hours of difference and off course this affects sales reports. Because
> they sale close to midnight is normal to get a specific sale made in one
> day reported in another.

Hello,

There used to have a bug in this date (corrected in May, rev e9b1254a), 
if you are indeed using the latest build, the date_order should contain 
the date at the time of validation in the point of sale.

One scenario that may explain a difference is if you have no internet 
connection. The orders are stored in the browser until it is able to 
reach the server. the create_date is when the order is received by the 
server but the date_order is the date of the validation.

Martin

-- 
Martin Trigaux
Odoo
https://odoo.com
https://github.com/mart-e

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe