Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0027567Openbravo ERP07. Sales managementpublic2014-09-09 16:052014-09-17 09:17
rafaroda 
rafademiguel 
normalminorN/A
newopen 
5
 
 
Core
No
0027567: Sales Invoice Dimensional Report Comparative exportable to Excel
Sales Invoice Dimensional Report Comparative exportable to Excel: now only Sales Invoice Dimensional Report NO Comparative is exportable to Excel.
1) Go to Sales Invoice Dimensional Report
2) Select Comparative checkbox
3) Click on XLS Format
Fields to be displayed on the Excel output (see .XLS attached)

1. Organization
2. Business Partner Group
3. Business Partner
4. Product Group
5. Product
6. Contact
7. Sales rep.
8. Project
9. Ship to address

10. Amount
11. Cost
12. Profit
13. Margin%

14. Amount Ref
15. Cost Ref
16. Profit Ref
17. Margin ref %
18. A.%
19. Margin diff

20. Amount Ref2
21. Cost Ref2
22. Profit Ref2
23. Margin ref2 %
24. A.2%
25. Margin diff2

26. Amount Ref3
27. Cost Ref3
28. Profit Ref3
29. Margin ref3 %
30. A.3%
31. Margin diff3

32. Weight
33. Weight Ref
34. Weight Ref2
35. Weight Ref3

36. Quantity
37. Quanity ref
38. Quantity %
39. Quanity ref2
40. Quantity2 %
41. Quanity ref3
42. Quantity3 %


Ordering criteria of the fields:

1. Organization
2. Business Partner Group
3. Business Partner
4. Product Group
5. Product
6. Contact
7. Sales rep.
8. Project
9. Ship to address
No tags attached.
related to feature request 0026935 closed rafaroda Sales Invoice Dimensional Report exportable to excel 
depends on feature request 0027133 closed rafademiguel Sales Invoice Dimensional Report Multicomparative 
xls ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml.xls (17,408) 2014-09-17 08:51
https://issues.openbravo.com/file_download.php?file_id=7247&type=bug
diff SIDRComparativeExcel.diff (163,441) 2014-09-17 09:17
https://issues.openbravo.com/file_download.php?file_id=7248&type=bug
Issue History
2014-09-09 16:05rafarodaNew Issue
2014-09-09 16:05rafarodaAssigned To => rafaroda
2014-09-09 16:05rafarodaModules => Core
2014-09-09 16:05rafarodaTriggers an Emergency Pack => No
2014-09-09 16:07rafarodaRelationship addedrelated to 0026935
2014-09-17 08:26rafarodaRelationship addeddepends on 0027133
2014-09-17 08:50rafarodaAssigned Torafaroda => rafademiguel
2014-09-17 08:50rafarodaProposed Solution updated
2014-09-17 08:51rafarodaFile Added: ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml.xls
2014-09-17 09:17rafarodaFile Added: SIDRComparativeExcel.diff

There are no notes attached to this issue.