Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementmajoralways2021-07-07 10:322021-07-07 16:36
Reporterhector_hernaezView Statuspublic 
Assigned ToTriage Finance 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0047349: 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

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



- 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)


- 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
vmromanos (developer)
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)

- Issue History
Date Modified Username Field Change
2021-07-07 10:32 hector_hernaez New Issue
2021-07-07 10:32 hector_hernaez Assigned To => Triage Finance
2021-07-07 10:32 hector_hernaez Modules => Core
2021-07-07 10:32 hector_hernaez Resolution time => 1627423200
2021-07-07 10:32 hector_hernaez Triggers an Emergency Pack => No
2021-07-07 16:36 vmromanos Resolution time 1627423200 =>
2021-07-07 16:36 vmromanos Note Added: 0130233
2021-07-07 16:36 vmromanos Type defect => design defect

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker