Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0056308
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[POS2] Coremajoralways2024-08-27 08:462024-08-28 13:15
ReportermalsasuaView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0056308: EWI caused because Sales Representative has been deleted in BO

Descriptionin 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
TagsNo 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
Powered by Mantis Bugtracker