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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0051646
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2023-02-20 12:262023-02-20 14:42
Reporterandre_montenegroView Statuspublic 
Assigned ToTriage Omni OMS 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojorge-garcia
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0051646: Buy X and get Y as a gift promotion results duplicated if applied to different products

DescriptionIf applied a discount "Buy X and get Y as a gift promotion" twice for 2 different products when "Apply to lowest Price" is checked, discounts and promotions applied to the lines is NOK in ERP.

Example:

Exists a 3x2 discount applied to Prod A and Prod B
If paid an order with 2 Prod A and 4 Prod B, discount is applied twice to the lower price (let's assume it's Prod B).
For Prod B, ERP displays 2 promotions "3x2 discount" applied, but one of them applies 0.00 discount and the other one applies the full discount.
Steps To ReproduceERP:
1. Login in the backend as Openbravo
2. Go to Discounts & Promotions window
3. Verify that promotion '3 x 2 Bottles' exists
4. If not create it:
   * Discount/Promotion Type: Buy X pay Y of different product
   * Starting Date: 01/01/2023
   * Included Products: Only those defined
   * Definition:
     - X Units: 3
     - Y Units: 2
     - Application Rule: Apply to lowest Price

  * Product Tab:
    - Create new records: Bottle 1L , Camel bak 3L

POS:
    
1. Login in POS as Vallblanca user
2. Add two products of Camel Bak 3 L
3. Add four products of Bottle 1L
4. Verify that 3x2 Bottle discount is applied to Bottle 1L.
5. Pay order with Cash or Card.

Verify ERP:
1. Go to Sales Order & select last paid order.
2. Verify Discounts and Promotions for each Line

Line 10 (Camel back 3 L)has a discount "3x2 Bottles" with 0.00 Discount per unit - OK
Line 20 (Bottle 1 L) has 2 discounts "3x2 Bottles", "Discounts and Promotions" tab:
  - Line 10 with discount 0.00 - NOK
  - Line 20 with discount per Unit 9.50 / Total Amount 19.00 - NOK
Proposed SolutionDiscounts and Promotions tab for Line 20 (Bottle 1 L) should contain 2 discounts "3x2 Bottles", each one with a value of 9.50 pero Unit and Total amount.
TagsNo tags attached.
Attached Filespng file icon ERP_Prod_1.png [^] (129,495 bytes) 2023-02-20 12:26


png file icon ERP_Prod_2.png [^] (133,840 bytes) 2023-02-20 12:27


png file icon POS_Ticekt.png [^] (57,352 bytes) 2023-02-20 12:27

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0146785)
jorge-garcia (reporter)
2023-02-20 14:41

 The problem reported is not an issue as it works as expected.

Here is the explanation:

In the case reported, the promotion "3 x 2 Bottles" could be applied twice to the ticket as all six units of the ticket participate in the promotion calculation.

"Buy X Get Y from different products" discount type consumes units from the lines for two reasons:
  * To calculate how many times the promotion is applied (in this case two times).
  * To block those units and avoid other promotions to consume them (in this case, it will block the six units from ticket lines)

The result seen in the ERP is the following:
  * From Camel Back, two units has been consumed by the promotion with 0€ amount discounted (as these two units should be paid by the customer)
  * From Bottle 1L, two units has been consumed by the promotion with 0€ amount discounted (as with these two additional units, we have four units that the customer should pay) and two other units consumed by the same promotion with 19€ amount discounted (as these two units will be free for the customer)

At the end, the user gets six units: four bottles to be paid and two bottles for free.

- Issue History
Date Modified Username Field Change
2023-02-20 12:26 andre_montenegro New Issue
2023-02-20 12:26 andre_montenegro Assigned To => Triage Omni OMS
2023-02-20 12:26 andre_montenegro File Added: ERP_Prod_1.png
2023-02-20 12:26 andre_montenegro Web browser => Google Chrome
2023-02-20 12:26 andre_montenegro Modules => Core
2023-02-20 12:26 andre_montenegro Triggers an Emergency Pack => No
2023-02-20 12:27 andre_montenegro File Added: ERP_Prod_2.png
2023-02-20 12:27 andre_montenegro File Added: POS_Ticekt.png
2023-02-20 14:41 jorge-garcia Note Added: 0146785
2023-02-20 14:42 jorge-garcia Review Assigned To => jorge-garcia
2023-02-20 14:42 jorge-garcia Status new => closed
2023-02-20 14:42 jorge-garcia Resolution open => no change required

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker