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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0032061
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementmajoralways2016-01-29 15:112017-04-27 11:38
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Finance 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
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

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

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

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0023971 newpsanjuan It is necessary further explanation on how it works the Sales Invoice Dimensional Report regarding cost information 
related to defect 0032938 closedAtulOpenbravo It is necessary a script to add the 1-1 relation between sales invoice line and goods shipment line 
related to defect 0024355 closedAtulOpenbravo "Good Shipment Line" field information is not filled when creating POS Order with Invoice Terms=Immediate 
related to design defect 0033624 closedAtulOpenbravo 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker