Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0032061Openbravo ERP07. Sales managementpublic2016-01-29 15:112017-04-27 11:38
Reporterpsanjuan 
Assigned ToTriage Omni OMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS20OS VersionProfessional Appliance
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
Summary0032061: No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line
DescriptionNo "Cost" information shown in Sales Invoice Dimensional Report in case there is not a 1 to 1 relationship between a sales invoice line and a goods shipment line.

For instance:

- in the case of booking a POS Order having "Invoice Terms" = "Immediate".
Info shown in the Invoice (Lines) is not going to be copied/pasted from the goods shipment but from the POS Order (only 1 line, for instance in case POS Order includes 15 units of a product that are going to be taken from different warehouses storage bins, while org's costing rule do have set up Warehouse Cost dimension = Yes)

Same applies to the process "Create Invoices From Order". This process creates a sales invoice do not based in the corresponding Goods Shipment if any, but just the lines included in the order.

In all those cases cost of the goods sold information is lost.
Steps To ReproduceIn F&B España

Create a new costing rule by making warehouse a costing dimension.

Create a product named "A 24355 C", add a Purchase Price list "Bebidas Alegres" = 100.00; add a sales price list "Tarifa de Ventas" = 200.00

Create a purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 100 and 10 units. Book the order.

Create another purchase order for F&B España, today's date. Enter 10 units of Product "A 24355 C", price 150 and 10 units. Book the order.

Create a Goods receipt to receipt 10 units in WH Norte (RN-1-0-0) at a price / cost of 100.00 and create another Goods receipt to receipt 10 units in WH Sur (RS-1-0-0) at a price/cost of 150.00. Complete Goods Shipments.

- Run costing background process therefore vendor receipts above are cost calculated. Check that the cost in WH Norte is 100.00 (10 units) and the cost in WH Sur is 150.00 (10 units).

Create a POS Sales Order with "Inmmediate" Invoice Terms for F&B España:
- Add line with product "A 24355 C" Qty = 15 units, sales price 200
- Complete POS Sales Order.

Run costing background process therefore customer shipment created as explained below is cost calculated.

Check that a Goods Shipment is created with 2 lines one line for 10 units from RN-1-0-0 and the other line for 5 units from RS-1-0-0.

Check that a Sales Invoice is created with only one line (15 units at a price of 200.00).

From Sales order lines, navigate to Sales Invoice lines and check that Goods Shipment Line info in not shown in there as sales invoice line can not be related to two goods shipment lines.

Run Sales Invoice Dimensional Report for today's date an check that "NO cost info is shown in there for the product". See image attached.

Proposed Solutionto be researched.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0023971 new psanjuan It is necessary further explanation on how it works the Sales Invoice Dimensional Report regarding cost information 
related to defect 0032938 closed AtulOpenbravo It is necessary a script to add the 1-1 relation between sales invoice line and goods shipment line 
related to defect 0024355 closed AtulOpenbravo "Good Shipment Line" field information is not filled when creating POS Order with Invoice Terms=Immediate 
related to design defect 0033624 closed AtulOpenbravo Different total net amount and total gross amount in order and invoice is the order line is split in more than one shipment line 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-01-29 15:11psanjuanNew Issue
2016-01-29 15:11psanjuanAssigned To => Triage Finance
2016-01-29 15:11psanjuanModules => Core
2016-01-29 15:11psanjuanTriggers an Emergency Pack => No
2016-01-29 15:11psanjuanRelationship addedrelated to 0024355
2016-01-29 15:13psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10826#r10826
2016-01-29 15:14psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10827#r10827
2016-01-29 15:15psanjuanSummaryNo "Cost" information shown in Sales Invoice Dimensional Report => No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line
2016-01-29 15:24psanjuanDescription Updatedbug_revision_view_page.php?rev_id=10829#r10829
2016-02-11 18:30ngarciaIssue Monitored: networkb
2016-05-12 09:45ngarciaRelationship addedrelated to 0023971
2016-10-17 12:51ngarciaRelationship addedrelated to 0032938
2016-10-17 15:24psanjuanRelationship addedrelated to 0033624
2017-04-27 11:38ngarciaDescription Updatedbug_revision_view_page.php?rev_id=15066#r15066

There are no notes attached to this issue.