Openbravo Issue Tracking System - POS2
View Issue Details
0056308POS2Corepublic2024-08-27 08:462024-08-28 13:15
malsasua 
Retail 
highmajoralways
newopen 
5
 
 
No
0056308: EWI caused because Sales Representative has been deleted in BO
in BO, when a Sales Representative is deleted, if this Sales REpresentative is used in the POS, in a ticket, the ticket is stuck in Error While Importing window:
org.postgresql.util.PSQLException: ERROR: insert or update on table "c_order" violates foreign key constraint "c_order_salesrep"
  Detail: Key (salesrep_id)=(D030935A598B45B983155F8ACBE2BC27) is not present in table "ad_user".
. in BO:
1. create a new user
  - Is Sales Representative = Y
  - role: vallblanca user
. in POS:
2. login
3. new ticket -> Receipt Properties -> select Sales Representative created in 1
. in BO:
4. delete user created in 1
. in POS
5. complete the ticket created in 3

Ticket is stuck in EWI window
No tags attached.
Issue History
2024-08-27 08:46malsasuaNew Issue
2024-08-27 08:46malsasuaAssigned To => Retail
2024-08-27 08:46malsasuaTriggers an Emergency Pack => No
2024-08-27 08:47malsasuaProjectRetail Modules => POS2
2024-08-28 13:15marvintmNote Added: 0168513
2024-08-28 13:15marvintmCategoryWeb POS => Core
2024-08-28 13:15marvintmTypedefect => design defect

Notes
(0168513)
marvintm   
2024-08-28 13:15   
Deleting masterdata is currently not supported by the masterdata refresh, as the data is loaded asynchronously. The POS may have loaded a record, and if the record is then deleted, the POS will generate transactions referencing this record. This is a general problem in the way masterdata is managed, and can happen with sales representatives, but also with products, discounts or taxes.

For this reason, masterdata records should be disabled instead.