Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0047349Openbravo ERP07. Sales managementpublic2021-07-07 10:322021-07-07 16:36
Reporterhector_hernaez 
Assigned ToTriage Omni OMS 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
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
Summary0047349: Diffences in totals between the Sales Quotation and the Sales order generated from it
DescriptionWhen a Sales Quotation is generated in the POS and after that, a Sales Order is generated from the Sales Quotation, the totals are different.
Steps To ReproduceAll has been reproduced in livebuilds 3.0RR20Q3.4

PREVIOUS STEPS:
- Go to 'Document Type' and select the record 'VBS Quotation'.
- Once in this record, in 'Document Type for Order', select 'VBS POS Order'.



STEPS TO REPRODUCE

webPOS

- In webPOS select 'Create Quotation'.
- Add to the ticket the product 'Alpine skiing backpack 27L'(x3).
- In the menu, select 'Receipt discounts'.
- Select 'disc_5_var_euro - 5 EUR' and change it to 8 EUR.
- Apply to the product.
- Click on the total amount (a message will appear with the Sales Quotation number)


Backoffice

- Go to 'Sales Quotation' tab and select the record created before (Here the total is 321.70).
- Press 'Create Order' button and 'OK'.
- Go to 'Sales Order' tab and look for the sales order created (Here the total is 321.69).

As you can see, the totals are different.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2021-07-07 10:32hector_hernaezNew Issue
2021-07-07 10:32hector_hernaezAssigned To => Triage Finance
2021-07-07 10:32hector_hernaezModules => Core
2021-07-07 10:32hector_hernaezResolution time => 1627423200
2021-07-07 10:32hector_hernaezTriggers an Emergency Pack => No
2021-07-07 16:36vmromanosResolution time1627423200 =>
2021-07-07 16:36vmromanosNote Added: 0130233
2021-07-07 16:36vmromanosTypedefect => design defect

Notes
(0130233)
vmromanos   
2021-07-07 16:36   
Moved to design defect and removed resolution time.

Right now the POS and the BO have different engines to calculate discounts and taxes, and therefore some rounding issues might happen depending on the numbers.

The POS calculates this way: (Units x Gross Unit Price) - total discount.
(3 x 109.90) - 8 = 312.70€.
Then, to know the gross unit price after discounts, it does 312.70/3 = 107.23€

In the BO the only editable field is the Gross Unit Price, where we can enter exactly what the POS calculates (107.23€). Then the line gross amount is calculated by multiplying by the units: 107.23 x 3 = 321.69€

Both calculations make sense considering the information and the scope both products have.


Although the POS and the BO are two different products, ideally they should share the same taxes and discounts engine to avoid this kind of discrepancies. And the engine should be the one recently developed for the POS (see 0041773).

Issue moved to DD as it should be fixed when the BO flows are adapted to use the POS engine. Note that this project is already in the backlog (but without a committed date)