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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034907
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 07. Sales managementmajoralways2017-01-11 11:202017-01-11 11:31
ReporterpsanjuanView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityhighResolutionopenFixed 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

0034907: Sales Dimensional Report can be improved by adding Document Type dimension.

DescriptionSales Dimensional Report can be improved by adding Document Type dimension.
Same would apply to Purchase Dimensional Report.
Steps To ReproduceGo 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.
Proposed SolutionDocument 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 €
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0034345 closedrqueralta Sales Dimensional Report is not showing sales order lines with 0 line net amount 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-01-11 11:20 psanjuan New Issue
2017-01-11 11:20 psanjuan Assigned To => Triage Finance
2017-01-11 11:20 psanjuan Modules => Core
2017-01-11 11:20 psanjuan Triggers an Emergency Pack => No
2017-01-11 11:30 psanjuan Steps to Reproduce Updated View Revisions
2017-01-11 11:30 psanjuan Proposed Solution updated
2017-01-11 11:30 psanjuan Relationship added related to 0034345
2017-01-11 11:31 psanjuan Steps to Reproduce Updated View Revisions


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker