Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0056308 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
design defect | [POS2] Core | major | always | 2024-08-27 08:46 | 2024-08-28 13:15 | |||||||
Reporter | malsasua | View Status | public | |||||||||
Assigned To | Retail | |||||||||||
Priority | high | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM revision | |||||||||||
Review Assigned To | ||||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0056308: EWI caused because Sales Representative has been deleted in BO | |||||||||||
Description | 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". | |||||||||||
Steps To Reproduce | . 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 | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0168513) marvintm (manager) 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. |
Issue History | |||
Date Modified | Username | Field | Change |
2024-08-27 08:46 | malsasua | New Issue | |
2024-08-27 08:46 | malsasua | Assigned To | => Retail |
2024-08-27 08:46 | malsasua | Triggers an Emergency Pack | => No |
2024-08-27 08:47 | malsasua | Project | Retail Modules => POS2 |
2024-08-28 13:15 | marvintm | Note Added: 0168513 | |
2024-08-28 13:15 | marvintm | Category | Web POS => Core |
2024-08-28 13:15 | marvintm | Type | defect => design defect |
Copyright © 2000 - 2009 MantisBT Group |