Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0053734Openbravo ERP07. Sales managementpublic2023-10-20 10:252023-11-27 14:12
ReporterLeyre 
Assigned Tokousalya_r 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0053734: Error: null value in column "pricelist" violates not-null constraint, when Book a Sales Order,
DescriptionError: null value in column "pricelist" violates not-null constraint, when Book a Sales Order,
Steps To ReproduceIn the Backend:
1. Create a discount: Buy X pay Y of different product:
  1.1.Include Price Lists: Only those defined; Add to the Price List tab: The White Valley Group Sale Price List, for example.
  1.2.Included Products: Only those defined; Add to the Products tab two products.
  1.3. X Units = 2 and Y Units = 1
  1.4. Application Rule: Disctribute Lowest Price.

2. Create a Sales Order:
  2.1. Price List: the same defined in the previous discount, in this case: The White Valley Group Sale Price List.
  2.2. Add two lines, with the two products defined in the discount.
  2.3. Click on Book button -> Ok

Result: Error: null value in column "pricelist" violates not-null constraint.
Proposed SolutionSee video: https://www.youtube.com/watch?v=pm9u5tLHuWg [^]
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023430RMP21 closed guilleaer Retail Modules Problem with discount "Buy X pay Y of different product" 
related to defect 0023486 closed guilleaer Retail Modules Discount Buy X pay Y of different product - Apply to lowest price - No distribute - is not working fine in ERP. 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2023-10-20 10:25LeyreNew Issue
2023-10-20 10:25LeyreAssigned To => Triage Omni OMS
2023-10-20 10:25LeyreModules => Core
2023-10-20 10:25LeyreTriggers an Emergency Pack => No
2023-10-20 10:27PracticsIssue Monitored: Practics
2023-10-24 09:52aferrazAssigned ToTriage Omni OMS => kousalya_r
2023-11-02 12:02hgbotNote Added: 0156615
2023-11-17 15:33aferrazRelationship addedrelated to 0023430
2023-11-17 15:33aferrazRelationship addedrelated to 0023486
2023-11-27 14:07hgbotResolutionopen => fixed
2023-11-27 14:07hgbotStatusnew => closed
2023-11-27 14:07hgbotFixed in Version => RR24Q1
2023-11-27 14:07hgbotNote Added: 0157677
2023-11-27 14:07hgbotNote Added: 0157678
2023-11-27 14:12ifernandezNote Added: 0157679

Notes
(0156615)
hgbot   
2023-11-02 12:02   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/123 [^]
(0157677)
hgbot   
2023-11-27 14:07   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts [^]
Changeset: be8ea744ae4b402d6504a639f57e2dfbbee3b29e
Author: Íñigo Fernández <inigo.fernandez@openbravo.com>
Date: 27-11-2023 13:06:59
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/commit/be8ea744ae4b402d6504a639f57e2dfbbee3b29e [^]

Fixes ISSUE-53734: Error: null value in column "pricelist" violates not-null constraint, when Book a Sales Order

---
M src-db/database/model/functions/OBDISC_XY_DIFFERENT_PRODUCT.xml
---
(0157678)
hgbot   
2023-11-27 14:07   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/123 [^]
(0157679)
ifernandez   
2023-11-27 14:12   
The current solution, no longer throws an error, but it still doesn't applies the discount. This is because the discounts engine from the backoffice hasn't the support for that rule's configuration.