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

what is making some POS Orders to stay with the PAID status instead of Posted

By
michel Guénard
on 2/1/15, 6:23 AM 856 views

Is there any known case where POS orders which belong to a accounted session (and then closed) remain with a Paid status whilst the other ones from the same session are properly accounted for?

This happened 70 times for 25 different POS sessions over a period of time of 2 years!

Could it be related to the products sold?

Do you use the POS module in offline mode?

Shawn Varghese
on 2/1/15, 7:27 AM
1
Shawn Varghese
On 2/1/15, 7:50 AM

This has been observed before, and in our case, it has occurred due to issues in the offline behaviour of the POS Module. Not sure if this applies to you, but consider the following case:

 

When an order is created in the POS session, there are a number of associated attributes to the order object along with order lines, such as user id, session id etc. Now, suppose the current ongoing session id is '1', then the order object in the POS session will also have a session id attribute with the value  '1'.

When we press the 'Validate' button, the browser sends the order object to the python function in the backend to be processed and inserted into the database. However, until the operation is completed, a copy of the order object remains in your browser. In case the operation fails, the browser will attempt to send the order object again.

Now, coming back to the 'Validate' button. Suppose you press Validate and close the session/browser immediately, the copy of the order object will remain in the browser cache (with the session id '1'). At the end of the day, you will Close and Validate all entries and all the orders' states will change from 'Paid' to 'Posted'. You then start a new session, so now the current session id is '2'. However, when you open the POS Session interface, that copy of the order object that was remaining from the previous session will be inserted again to the database. Since this order object still had the old session id, you get an entry into the database with 'Paid' status for session id '1', which had already been closed.

 

This is what has happened in our case. My apologies for explaining this very poorly. This is one issue which exists, at least in OpenERP 7, and causes a lot of issues in the Accounting at the end of the day/month. Hope the explanation makes sense !

0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 2/1/15, 11:29 AM

@shawn

Thanks for detailled explanation;.

This is a severe issue as we have no solution - other than posting enties manually, but leaving the orders permanently with their erroneous status - to record the corrsponding sales and VAT and perhaps inventory and stock accounting!!!!!!!!!!!!!!!!!!!!

would you qualify this issue as a bug to be reported to Odoo?

I personnaly think it is one. I will wait for other cases  to be reported on as an answer to my question; 

In the meantime, I forwarded my question to the online support; I will also forward your answer to Odoo support .

 

Yup, the offline mode in the POS module is not robust at all. There are numerous cases where it can fail and lead to duplicate entries in the database. It took a lot of code modifications to make the system more sturdy. Please let us know if you get a resolution to this.

Shawn Varghese
on 2/1/15, 2:49 PM

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

3 follower(s)

Stats

Asked: 2/1/15, 6:23 AM
Seen: 856 times
Last updated: 5/9/16, 6:24 AM