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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033624
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementmajoralways2016-08-04 14:072016-10-17 15:24
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revisionno change re
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033624: Different total net amount and total gross amount in order and invoice is the order line is split in more than one shipment line

DescriptionDifferent total net amount and total gross amount in order and invoice is the order line is split in more than one shipment line
Steps To ReproduceConfigure the instance to accept more than 2 decimals in prices:

http://wiki.openbravo.com/wiki/How_to_change_the_price_precision [^]


As group admin role:
   Create a new product
   Add a sales price list of 0.756 to it
   Create a goods receipt and receive one unit of the product in two different storage bins of the same warehouse
   Create a Sales Order with POS Order type and add 2 units of the previously created product
   Check the total net amount is 1.51 in the order and 1.52 in the invoice
   Check the total gross amount is 1.83 in the order and 1.84 in the invoice
   
   The same happens if you create a standard order, a goods shipment with two lines and a sales invoice from it
Proposed SolutionIssue changed as Design Defect as Openbravo is not currently designed now to support this scenario.

In this scenario purchase order shows below info while ordering 2 units of the same product at a price of 0.756:

Line Net Amount = Taxable Amount = 1.51
Tax Rate = 21%
Tax Amount = 0.32
Total Gross Amount = 1.83

However sales invoice shows below info while invoicing 1 unit at a price of 0.756 (storage bin x), and another 1 unit at a price of 0.756 (storage bin y):

Line Net Amount = Taxable Amount = 1.52
Tax Rate = 21%
Tax Amount = 0.32
Total Gross Amount = 1.84

It would be necessary to adjust taxable amount (-0.01) and therefore total gross amount (0.01) as described in the issue 25506 related.

This issue (design defect) is currently blocked by issue 25506 (feature request).


Proposed solution above do not valid.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0034150 scheduledcollazoandy4 Create Lines From function selects only shipped units while invoicing from orders. 
related to design defect 0032061 newTriage Omni OMS No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line 

-  Notes
(0090586)
psanjuan (manager)
2016-10-14 13:23
edited on: 2016-10-17 15:37

 It is not the same to invoice 1 line of 2 units than 2 lines of 1 units. There could be mathematical rounding issues do not caused by Openbravo.

It should be clear what strategy customer needs to follow in regards to invoicing.

If they want to invoice from the shipment, invoice lines could be split.
If they want to invoice from the order, invoice lines could not be split.

Therefore there are two options:


Option A - In the case of creating a POS Sales order, that requires that the invoice is created taking into account the shipment(s), please select "After Delivery" as Invoice Terms.

Option B - In the case of creating a POS Sales order, that requires that the invoice do not need to take into account the shipments but just the order, please select "Inmediate" as Invoice Terms.

This is already working.

Following option B in the example provided, the invoice will contain just 1 line for 2 units of the product, otherwise it will be split into 2 lines of 1 unit each (same as in the shipment).

Havind said that, please be aware that option B does not properly reflects cost in the Sales Invoice Dimensional report. See issue related 32061 (Design Defect).

Once double check, we can not consider this issue either a defect or a design defect.

Finally, and in the case of not using a POS Sales Order, there is a defect related that reflects an issue related to "Create Lines From" whenever an order is selected. Create Lines From (Order) function needs to be improved, therefore invoice created does not take the units shipped but just ordered ones, having into account that once the corresponding shipment(s) are booked, correct cost are calculated and shown in the Sales Invoice Dimensional Report.

Please see issue related 34150
(0090613)
psanjuan (manager)
2016-10-17 10:57

 No change required

- Issue History
Date Modified Username Field Change
2016-08-04 14:07 ngarcia New Issue
2016-08-04 14:07 ngarcia Assigned To => Triage Finance
2016-08-04 14:07 ngarcia Modules => Core
2016-08-04 14:07 ngarcia Resolution time => 1472076000
2016-08-04 14:07 ngarcia Triggers an Emergency Pack => No
2016-08-04 14:12 ngarcia Issue Monitored: networkb
2016-08-09 08:34 aferraz Assigned To Triage Finance => AtulOpenbravo
2016-08-18 12:09 aferraz Relationship added related to 0032265
2016-08-19 09:45 psanjuan Type defect => design defect
2016-08-19 09:45 psanjuan Proposed Solution updated
2016-08-19 09:45 psanjuan Relationship added related to 0025506
2016-08-19 09:46 psanjuan Proposed Solution updated
2016-08-19 09:47 psanjuan Relationship replaced depends on 0025506
2016-08-19 09:49 psanjuan Relationship deleted related to 0032265
2016-10-13 09:58 psanjuan Proposed Solution updated
2016-10-13 10:46 psanjuan Proposed Solution updated
2016-10-14 13:23 psanjuan Note Added: 0090586
2016-10-14 13:24 psanjuan Relationship deleted depends on 0025506
2016-10-14 13:24 psanjuan Relationship added related to 0034150
2016-10-14 13:25 psanjuan Note Edited: 0090586 View Revisions
2016-10-14 13:26 psanjuan Note Edited: 0090586 View Revisions
2016-10-14 13:26 psanjuan Status new => scheduled
2016-10-14 13:27 psanjuan Status scheduled => resolved
2016-10-14 13:27 psanjuan Resolution open => no change required
2016-10-14 13:27 psanjuan Fixed in SCM revision => no change required
2016-10-14 13:28 psanjuan Proposed Solution updated
2016-10-17 10:57 psanjuan Status resolved => new
2016-10-17 10:57 psanjuan Note Added: 0090613
2016-10-17 10:57 psanjuan Status new => closed
2016-10-17 15:24 psanjuan Relationship added related to 0032061
2016-10-17 15:30 psanjuan Note Edited: 0090586 View Revisions
2016-10-17 15:36 psanjuan Note Edited: 0090586 View Revisions
2016-10-17 15:37 psanjuan Note Edited: 0090586 View Revisions

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker