Skip to Content
Menu
This question has been flagged
2 Replies
7190 Views

After my first test last week with the POS module and "closing" the day by printing a report, I am now failing to print a report for sales I complete (with cash) at the POS, already tried several sellers and closed, open sessions etc. I toured the database with pgadmin, and many tables I looked at looked scarily empty after sales. It looks possible that somehow I damaged the ability of the server to record sales, though I did not edit any tables or source, how can I find a way out? Thanks!

Avatar
Discard
Best Answer

POS orders are stored in pos_order and pos_order_line tables in the DB but bank statements are stored in account_bank_statement and account_bank_statement_line

Sale module is another module. Sales from POS are not stored in sale_order/sale_order_line

Avatar
Discard
Author

Thanks, it looks like completing POS sales does not enter any data in my pos_tables. However my database is not all broken, I was able to create new sellers and products etc. Any idea how I can go about troubleshooting this? It looks like I may have found a bug or a feature! I am on Windows 8.1

Maybe orders are not well sent to database ??? If the Led (top right of POS) turns red with a number, It is because orders are stuck in the browser and are not sent to DB

Author

right! I think I remember seeing the green color up there, but not recently, and "closing" already shows 0,00, so nothing is transferred to the database. I am getting the suspicion it could be a firewall thing, even though other parts of the OpenERP work well. Any ideas how to troubleshoot my red light, considering I can pgadmin in the database?

Thanks!

Take a look at the openerp-server.log, It may contain some indications.

Author

thanks, I have not found the answer yet, but browsing the POS files I was surprised I needed some Windows permission to see them, the addon must have been installed with higher priviledges than the server itself. But since I can run POS, these permissions are probably not the answer. I will be switching to Linux in a couple of days, maybe that will work a bit better.

Author Best Answer

right! I think I remember seeing the green color up there, but not recently, and "closing" already shows 0,00, so nothing is transferred to the database. I am getting the suspicion it could be a firewall thing, even though other parts of the OpenERP work well. Any ideas how to troubleshoot my red light, considering I can pgadmin in the database?

Thanks!

Avatar
Discard
Related Posts Replies Views Activity
0
Jun 24
1454
1
May 24
2938
7
Oct 24
14140
1
Feb 25
1018
0
Mar 24
1171