|View Issue Details[ Jump to Notes ]||[ Issue History ] [ Print ]|
|Type||Category||Severity||Reproducibility||Date Submitted||Last Update|
|design defect||[Openbravo ERP] 07. Sales management||major||always||2016-01-29 15:11||2017-04-27 11:38|
|Assigned To||Triage Omni OMS|
|Priority||urgent||Resolution||open||Fixed in Version|
|Status||new||Fix in branch||Fixed in SCM revision|
|OS||Linux 32 bit||Database||PostgreSQL||Java version||1.6.0_18|
|OS Version||Professional Appliance||Database version||8.3.9||Ant version||1.7.1|
|Product Version||SCM revision|
|Review Assigned To|
|Regression introduced in release|
|Regression introduced by commit|
|Triggers an Emergency Pack||No|
0032061: No "Cost" information shown in Sales Invoice Dimensional Report in case there is no 1 to 1 relation between SO line and GS line
|Description||No "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. |
- 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 Reproduce||In 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 Solution||to be researched.|
|Tags||No tags attached.|
|Relationships [ Relation Graph ] [ Dependency Graph ]|
|2016-01-29 15:11||psanjuan||New Issue|
|2016-01-29 15:11||psanjuan||Assigned To||=> Triage Finance|
|2016-01-29 15:11||psanjuan||Modules||=> Core|
|2016-01-29 15:11||psanjuan||Triggers an Emergency Pack||=> No|
|2016-01-29 15:11||psanjuan||Relationship added||related to 0024355|
|2016-01-29 15:13||psanjuan||Steps to Reproduce Updated||View Revisions|
|2016-01-29 15:14||psanjuan||Steps to Reproduce Updated||View Revisions|
|2016-01-29 15:15||psanjuan||Summary||No "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:24||psanjuan||Description Updated||View Revisions|
|2016-02-11 18:30||ngarcia||Issue Monitored: networkb|
|2016-05-12 09:45||ngarcia||Relationship added||related to 0023971|
|2016-10-17 12:51||ngarcia||Relationship added||related to 0032938|
|2016-10-17 15:24||psanjuan||Relationship added||related to 0033624|
|2017-04-27 11:38||ngarcia||Description Updated||View Revisions|
|Copyright © 2000 - 2009 MantisBT Group|