Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0056308 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [POS2] Core | major | always | 2024-08-27 08:46 | 2025-01-29 14:26 | |||||||
| 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 | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | Gold | |||||||||||
| Support ticket | ||||||||||||
| 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 (viewer) 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 | OBNetwork customer | => Gold |
| 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 |
| 2025-01-29 14:26 | guillermogil | Type | design defect => feature request |
| Copyright © 2000 - 2009 MantisBT Group |