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.

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

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
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