Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0053734

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 07. Sales management

major

always

2023-10-20 10:25

2023-11-27 14:12

Reporter

Leyre

View Status

public

Assigned To

kousalya_r

Priority

normal

Resolution

fixed

Fixed in Version

Status

closed

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

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

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

Description

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

Steps To Reproduce

In 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 Solution

See video: https://www.youtube.com/watch?v=pm9u5tLHuWg [^]

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0023430	RMP21	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.

Notes
(0156615) hgbot (developer) 2023-11-02 12:02	Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/123 [^]

(0157677) hgbot (developer) 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 (developer) 2023-11-27 14:07	Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.discounts/-/merge_requests/123 [^]

(0157679) ifernandez (developer) 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.

Issue History
Date Modified	Username	Field	Change
2023-10-20 10:25	Leyre	New Issue
2023-10-20 10:25	Leyre	Assigned To	=> Triage Omni OMS
2023-10-20 10:25	Leyre	Modules	=> Core
2023-10-20 10:25	Leyre	Triggers an Emergency Pack	=> No
2023-10-20 10:27	Practics	Issue Monitored: Practics
2023-10-24 09:52	aferraz	Assigned To	Triage Omni OMS => kousalya_r
2023-11-02 12:02	hgbot	Note Added: 0156615
2023-11-17 15:33	aferraz	Relationship added	related to 0023430
2023-11-17 15:33	aferraz	Relationship added	related to 0023486
2023-11-27 14:07	hgbot	Resolution	open => fixed
2023-11-27 14:07	hgbot	Status	new => closed
2023-11-27 14:07	hgbot	Fixed in Version	=> RR24Q1
2023-11-27 14:07	hgbot	Note Added: 0157677
2023-11-27 14:07	hgbot	Note Added: 0157678
2023-11-27 14:12	ifernandez	Note Added: 0157679

Copyright © 2000 - 2009 MantisBT Group