Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0034907Openbravo ERP07. Sales managementpublic2017-01-11 11:202017-01-11 11:31
psanjuan 
Triage Omni OMS 
highmajoralways
newopen 
20Professional Appliance
 
 
Core
No
0034907: Sales Dimensional Report can be improved by adding Document Type dimension.
Sales Dimensional Report can be improved by adding Document Type dimension.
Same would apply to Purchase Dimensional Report.
Go to Sales Order window and create a new one for F&B España, Alimentos y Supemercados business partner, for current date.
Add a line and enter any product for instance "Agua sin Gas 1L". Enter an ordered quantity = 10.
Remove discounts if any.
Book the order.
Write down sales order number, for instance 1000198, and total net amount = 15.30

Launch Sales Dimensional report for current date, F&B España Organization and select Product and Document No dimensions.

Verify below info is shown in the report:
Agua sin Gas
1000198 15.30 €

Go to Sales Order window and create a new sales order for F&B España, Alimentos y Supermercados business partner.
Change sales order type to Warehouse Order.
Change Document No to 1000198.
Enter as order date, current date.

Add a line and enter any product for instance "Agua sin Gas 1L". Enter an ordered quantity = 25.
Remove discounts if any.
Book the order.
Write down warehouse order number, 1000198, and total net amount = 38.25

Launch Sales Dimensional report for current date, F&B España Organization and select Product and Document No dimensions.

Verify below info is shown in the report:
Agua sin Gas
1000198 53.55 €

Above information is not 100% as there is no a unique order number 1000198 for that amount, but two.
Document Type dimension can improve Sales Dimensional Report, therefore below information is shown for our test case scenario, regardless that dimension Document Type is selected or not.

Agua sin Gas
1000198 15.30 €
1000198 38.25 €
No tags attached.
related to defect 0034345 closed rqueralta Sales Dimensional Report is not showing sales order lines with 0 line net amount 
Issue History
2017-01-11 11:20psanjuanNew Issue
2017-01-11 11:20psanjuanAssigned To => Triage Finance
2017-01-11 11:20psanjuanModules => Core
2017-01-11 11:20psanjuanTriggers an Emergency Pack => No
2017-01-11 11:30psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14243#r14243
2017-01-11 11:30psanjuanProposed Solution updated
2017-01-11 11:30psanjuanRelationship addedrelated to 0034345
2017-01-11 11:31psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14244#r14244

There are no notes attached to this issue.