Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0027567 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
feature request | [Openbravo ERP] 07. Sales management | minor | N/A | 2014-09-09 16:05 | 2014-09-17 09:17 | |||||||
Reporter | rafaroda | View Status | public | |||||||||
Assigned To | rafademiguel | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM revision | |||||||||||
Merge Request Status | ||||||||||||
Review Assigned To | ||||||||||||
OBNetwork customer | No | |||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Support ticket | ||||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0027567: Sales Invoice Dimensional Report Comparative exportable to Excel | |||||||||||
Description | Sales Invoice Dimensional Report Comparative exportable to Excel: now only Sales Invoice Dimensional Report NO Comparative is exportable to Excel. | |||||||||||
Steps To Reproduce | 1) Go to Sales Invoice Dimensional Report 2) Select Comparative checkbox 3) Click on XLS Format | |||||||||||
Proposed Solution | 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 | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ![]() ![]() diff --git a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml --- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml +++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml @@ -13047,6 +13047,17 @@ <!--085A3DDF2C8749EFA23842C61B518D9C--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--085A3DDF2C8749EFA23842C61B518D9C--></AD_TEXTINTERFACES> +<!--08A085D6E1A846D69794E6A78E26FD78--><AD_TEXTINTERFACES> +<!--08A085D6E1A846D69794E6A78E26FD78--> <AD_TEXTINTERFACES_ID><![CDATA[08A085D6E1A846D69794E6A78E26FD78]]></AD_TEXTINTERFACES_ID> +<!--08A085D6E1A846D69794E6A78E26FD78--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--08A085D6E1A846D69794E6A78E26FD78--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--08A085D6E1A846D69794E6A78E26FD78--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--08A085D6E1A846D69794E6A78E26FD78--> <TEXT><![CDATA[Amount Ref3]]></TEXT> +<!--08A085D6E1A846D69794E6A78E26FD78--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--08A085D6E1A846D69794E6A78E26FD78--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--08A085D6E1A846D69794E6A78E26FD78--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--08A085D6E1A846D69794E6A78E26FD78--></AD_TEXTINTERFACES> + <!--08C14BD2ACD747E8913757418B574A10--><AD_TEXTINTERFACES> <!--08C14BD2ACD747E8913757418B574A10--> <AD_TEXTINTERFACES_ID><![CDATA[08C14BD2ACD747E8913757418B574A10]]></AD_TEXTINTERFACES_ID> <!--08C14BD2ACD747E8913757418B574A10--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13113,6 +13124,28 @@ <!--0AB88EF426844BBDB58120DC8038851B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--0AB88EF426844BBDB58120DC8038851B--></AD_TEXTINTERFACES> +<!--0B7B27AC01134EE0B955C279760BE142--><AD_TEXTINTERFACES> +<!--0B7B27AC01134EE0B955C279760BE142--> <AD_TEXTINTERFACES_ID><![CDATA[0B7B27AC01134EE0B955C279760BE142]]></AD_TEXTINTERFACES_ID> +<!--0B7B27AC01134EE0B955C279760BE142--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0B7B27AC01134EE0B955C279760BE142--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0B7B27AC01134EE0B955C279760BE142--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0B7B27AC01134EE0B955C279760BE142--> <TEXT><![CDATA[Quantity Ref2]]></TEXT> +<!--0B7B27AC01134EE0B955C279760BE142--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--0B7B27AC01134EE0B955C279760BE142--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--0B7B27AC01134EE0B955C279760BE142--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--0B7B27AC01134EE0B955C279760BE142--></AD_TEXTINTERFACES> + +<!--0BB033357B664B08B2D24E1CC942E941--><AD_TEXTINTERFACES> +<!--0BB033357B664B08B2D24E1CC942E941--> <AD_TEXTINTERFACES_ID><![CDATA[0BB033357B664B08B2D24E1CC942E941]]></AD_TEXTINTERFACES_ID> +<!--0BB033357B664B08B2D24E1CC942E941--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--0BB033357B664B08B2D24E1CC942E941--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--0BB033357B664B08B2D24E1CC942E941--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--0BB033357B664B08B2D24E1CC942E941--> <TEXT><![CDATA[Q.%]]></TEXT> +<!--0BB033357B664B08B2D24E1CC942E941--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--0BB033357B664B08B2D24E1CC942E941--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--0BB033357B664B08B2D24E1CC942E941--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--0BB033357B664B08B2D24E1CC942E941--></AD_TEXTINTERFACES> + <!--0C22BD342F36449EBF3DDD9AB3E4EB78--><AD_TEXTINTERFACES> <!--0C22BD342F36449EBF3DDD9AB3E4EB78--> <AD_TEXTINTERFACES_ID><![CDATA[0C22BD342F36449EBF3DDD9AB3E4EB78]]></AD_TEXTINTERFACES_ID> <!--0C22BD342F36449EBF3DDD9AB3E4EB78--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13157,6 +13190,17 @@ <!--0F9B9D3FE71C4172B53EBC5D49E1D00D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--0F9B9D3FE71C4172B53EBC5D49E1D00D--></AD_TEXTINTERFACES> +<!--102B108B799944E69ACD1BAB7B174C3F--><AD_TEXTINTERFACES> +<!--102B108B799944E69ACD1BAB7B174C3F--> <AD_TEXTINTERFACES_ID><![CDATA[102B108B799944E69ACD1BAB7B174C3F]]></AD_TEXTINTERFACES_ID> +<!--102B108B799944E69ACD1BAB7B174C3F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--102B108B799944E69ACD1BAB7B174C3F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--102B108B799944E69ACD1BAB7B174C3F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--102B108B799944E69ACD1BAB7B174C3F--> <TEXT><![CDATA[Q.2%]]></TEXT> +<!--102B108B799944E69ACD1BAB7B174C3F--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--102B108B799944E69ACD1BAB7B174C3F--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--102B108B799944E69ACD1BAB7B174C3F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--102B108B799944E69ACD1BAB7B174C3F--></AD_TEXTINTERFACES> + <!--1056FD6F4AE9463A80DBABC6AD0AA7A4--><AD_TEXTINTERFACES> <!--1056FD6F4AE9463A80DBABC6AD0AA7A4--> <AD_TEXTINTERFACES_ID><![CDATA[1056FD6F4AE9463A80DBABC6AD0AA7A4]]></AD_TEXTINTERFACES_ID> <!--1056FD6F4AE9463A80DBABC6AD0AA7A4--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13212,6 +13256,17 @@ <!--1239DDC8CC1D46DFA50936AB7B448DC5--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--1239DDC8CC1D46DFA50936AB7B448DC5--></AD_TEXTINTERFACES> +<!--12C0B539FF6C435FBF85007CBE543A84--><AD_TEXTINTERFACES> +<!--12C0B539FF6C435FBF85007CBE543A84--> <AD_TEXTINTERFACES_ID><![CDATA[12C0B539FF6C435FBF85007CBE543A84]]></AD_TEXTINTERFACES_ID> +<!--12C0B539FF6C435FBF85007CBE543A84--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--12C0B539FF6C435FBF85007CBE543A84--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--12C0B539FF6C435FBF85007CBE543A84--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--12C0B539FF6C435FBF85007CBE543A84--> <TEXT><![CDATA[Margin diff3]]></TEXT> +<!--12C0B539FF6C435FBF85007CBE543A84--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--12C0B539FF6C435FBF85007CBE543A84--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--12C0B539FF6C435FBF85007CBE543A84--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--12C0B539FF6C435FBF85007CBE543A84--></AD_TEXTINTERFACES> + <!--15155BC7060D432E86869136477D8C65--><AD_TEXTINTERFACES> <!--15155BC7060D432E86869136477D8C65--> <AD_TEXTINTERFACES_ID><![CDATA[15155BC7060D432E86869136477D8C65]]></AD_TEXTINTERFACES_ID> <!--15155BC7060D432E86869136477D8C65--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13520,6 +13575,17 @@ <!--21444EAA2E5211DE95D5ABB0C6CBBF57--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--21444EAA2E5211DE95D5ABB0C6CBBF57--></AD_TEXTINTERFACES> +<!--215F39A620544331909F18DAD58CAD97--><AD_TEXTINTERFACES> +<!--215F39A620544331909F18DAD58CAD97--> <AD_TEXTINTERFACES_ID><![CDATA[215F39A620544331909F18DAD58CAD97]]></AD_TEXTINTERFACES_ID> +<!--215F39A620544331909F18DAD58CAD97--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--215F39A620544331909F18DAD58CAD97--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--215F39A620544331909F18DAD58CAD97--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--215F39A620544331909F18DAD58CAD97--> <TEXT><![CDATA[Weight Ref]]></TEXT> +<!--215F39A620544331909F18DAD58CAD97--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--215F39A620544331909F18DAD58CAD97--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--215F39A620544331909F18DAD58CAD97--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--215F39A620544331909F18DAD58CAD97--></AD_TEXTINTERFACES> + <!--21C7674B589C4C8BBB2D6C62943148FE--><AD_TEXTINTERFACES> <!--21C7674B589C4C8BBB2D6C62943148FE--> <AD_TEXTINTERFACES_ID><![CDATA[21C7674B589C4C8BBB2D6C62943148FE]]></AD_TEXTINTERFACES_ID> <!--21C7674B589C4C8BBB2D6C62943148FE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13564,6 +13630,17 @@ <!--23D9E05B782A4D3ABADEFF565FBD5CE4--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--23D9E05B782A4D3ABADEFF565FBD5CE4--></AD_TEXTINTERFACES> +<!--241698B8347148C089444D401274F8CF--><AD_TEXTINTERFACES> +<!--241698B8347148C089444D401274F8CF--> <AD_TEXTINTERFACES_ID><![CDATA[241698B8347148C089444D401274F8CF]]></AD_TEXTINTERFACES_ID> +<!--241698B8347148C089444D401274F8CF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--241698B8347148C089444D401274F8CF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--241698B8347148C089444D401274F8CF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--241698B8347148C089444D401274F8CF--> <TEXT><![CDATA[Margin diff2]]></TEXT> +<!--241698B8347148C089444D401274F8CF--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--241698B8347148C089444D401274F8CF--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--241698B8347148C089444D401274F8CF--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--241698B8347148C089444D401274F8CF--></AD_TEXTINTERFACES> + <!--25584757FAAF48399C3A676DF6C51970--><AD_TEXTINTERFACES> <!--25584757FAAF48399C3A676DF6C51970--> <AD_TEXTINTERFACES_ID><![CDATA[25584757FAAF48399C3A676DF6C51970]]></AD_TEXTINTERFACES_ID> <!--25584757FAAF48399C3A676DF6C51970--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13728,6 +13805,17 @@ <!--289A4164B9AF4467AF8247D7ADFB578B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--289A4164B9AF4467AF8247D7ADFB578B--></AD_TEXTINTERFACES> +<!--28A44DDB95BC4C28944EE410A744036E--><AD_TEXTINTERFACES> +<!--28A44DDB95BC4C28944EE410A744036E--> <AD_TEXTINTERFACES_ID><![CDATA[28A44DDB95BC4C28944EE410A744036E]]></AD_TEXTINTERFACES_ID> +<!--28A44DDB95BC4C28944EE410A744036E--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--28A44DDB95BC4C28944EE410A744036E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--28A44DDB95BC4C28944EE410A744036E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--28A44DDB95BC4C28944EE410A744036E--> <TEXT><![CDATA[Weight Ref2]]></TEXT> +<!--28A44DDB95BC4C28944EE410A744036E--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--28A44DDB95BC4C28944EE410A744036E--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--28A44DDB95BC4C28944EE410A744036E--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--28A44DDB95BC4C28944EE410A744036E--></AD_TEXTINTERFACES> + <!--28B043CED5304260B3F424705EC667CE--><AD_TEXTINTERFACES> <!--28B043CED5304260B3F424705EC667CE--> <AD_TEXTINTERFACES_ID><![CDATA[28B043CED5304260B3F424705EC667CE]]></AD_TEXTINTERFACES_ID> <!--28B043CED5304260B3F424705EC667CE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -13750,6 +13838,17 @@ <!--28DDB97537F74AE9A594421EBCA8742D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--28DDB97537F74AE9A594421EBCA8742D--></AD_TEXTINTERFACES> +<!--2A04C00873A844E88910DDD3DAA6623B--><AD_TEXTINTERFACES> +<!--2A04C00873A844E88910DDD3DAA6623B--> <AD_TEXTINTERFACES_ID><![CDATA[2A04C00873A844E88910DDD3DAA6623B]]></AD_TEXTINTERFACES_ID> +<!--2A04C00873A844E88910DDD3DAA6623B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--2A04C00873A844E88910DDD3DAA6623B--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--2A04C00873A844E88910DDD3DAA6623B--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--2A04C00873A844E88910DDD3DAA6623B--> <TEXT><![CDATA[Quantity Ref3]]></TEXT> +<!--2A04C00873A844E88910DDD3DAA6623B--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--2A04C00873A844E88910DDD3DAA6623B--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--2A04C00873A844E88910DDD3DAA6623B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--2A04C00873A844E88910DDD3DAA6623B--></AD_TEXTINTERFACES> + <!--2A1D06FA18B54BFE9CF2ACB115B588E3--><AD_TEXTINTERFACES> <!--2A1D06FA18B54BFE9CF2ACB115B588E3--> <AD_TEXTINTERFACES_ID><![CDATA[2A1D06FA18B54BFE9CF2ACB115B588E3]]></AD_TEXTINTERFACES_ID> <!--2A1D06FA18B54BFE9CF2ACB115B588E3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14168,6 +14267,17 @@ <!--41D653AB70244D3EA6DC190256BD8171--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--41D653AB70244D3EA6DC190256BD8171--></AD_TEXTINTERFACES> +<!--430E7D2E362C4601863686171473BA19--><AD_TEXTINTERFACES> +<!--430E7D2E362C4601863686171473BA19--> <AD_TEXTINTERFACES_ID><![CDATA[430E7D2E362C4601863686171473BA19]]></AD_TEXTINTERFACES_ID> +<!--430E7D2E362C4601863686171473BA19--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--430E7D2E362C4601863686171473BA19--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--430E7D2E362C4601863686171473BA19--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--430E7D2E362C4601863686171473BA19--> <TEXT><![CDATA[Ship to address]]></TEXT> +<!--430E7D2E362C4601863686171473BA19--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--430E7D2E362C4601863686171473BA19--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--430E7D2E362C4601863686171473BA19--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--430E7D2E362C4601863686171473BA19--></AD_TEXTINTERFACES> + <!--434E926805CE4AAB86F56DDF76E68352--><AD_TEXTINTERFACES> <!--434E926805CE4AAB86F56DDF76E68352--> <AD_TEXTINTERFACES_ID><![CDATA[434E926805CE4AAB86F56DDF76E68352]]></AD_TEXTINTERFACES_ID> <!--434E926805CE4AAB86F56DDF76E68352--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14223,6 +14333,17 @@ <!--44D1EA1FFEC24136BA583266096969E6--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--44D1EA1FFEC24136BA583266096969E6--></AD_TEXTINTERFACES> +<!--45181C19BD1641D481F38A37AD83AEB5--><AD_TEXTINTERFACES> +<!--45181C19BD1641D481F38A37AD83AEB5--> <AD_TEXTINTERFACES_ID><![CDATA[45181C19BD1641D481F38A37AD83AEB5]]></AD_TEXTINTERFACES_ID> +<!--45181C19BD1641D481F38A37AD83AEB5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--45181C19BD1641D481F38A37AD83AEB5--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--45181C19BD1641D481F38A37AD83AEB5--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--45181C19BD1641D481F38A37AD83AEB5--> <TEXT><![CDATA[Amount Ref]]></TEXT> +<!--45181C19BD1641D481F38A37AD83AEB5--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--45181C19BD1641D481F38A37AD83AEB5--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--45181C19BD1641D481F38A37AD83AEB5--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--45181C19BD1641D481F38A37AD83AEB5--></AD_TEXTINTERFACES> + <!--4716134EDEBA4F8FA5988CD14FDC00D9--><AD_TEXTINTERFACES> <!--4716134EDEBA4F8FA5988CD14FDC00D9--> <AD_TEXTINTERFACES_ID><![CDATA[4716134EDEBA4F8FA5988CD14FDC00D9]]></AD_TEXTINTERFACES_ID> <!--4716134EDEBA4F8FA5988CD14FDC00D9--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14355,6 +14476,17 @@ <!--48B16F0CEB9E47D4BF0963C89D22504D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--48B16F0CEB9E47D4BF0963C89D22504D--></AD_TEXTINTERFACES> +<!--4A11FB292A99433E95106A2609AA12C6--><AD_TEXTINTERFACES> +<!--4A11FB292A99433E95106A2609AA12C6--> <AD_TEXTINTERFACES_ID><![CDATA[4A11FB292A99433E95106A2609AA12C6]]></AD_TEXTINTERFACES_ID> +<!--4A11FB292A99433E95106A2609AA12C6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--4A11FB292A99433E95106A2609AA12C6--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--4A11FB292A99433E95106A2609AA12C6--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--4A11FB292A99433E95106A2609AA12C6--> <TEXT><![CDATA[A.%]]></TEXT> +<!--4A11FB292A99433E95106A2609AA12C6--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--4A11FB292A99433E95106A2609AA12C6--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--4A11FB292A99433E95106A2609AA12C6--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--4A11FB292A99433E95106A2609AA12C6--></AD_TEXTINTERFACES> + <!--4A2CBA2EA7EF4F01843340C1921843F1--><AD_TEXTINTERFACES> <!--4A2CBA2EA7EF4F01843340C1921843F1--> <AD_TEXTINTERFACES_ID><![CDATA[4A2CBA2EA7EF4F01843340C1921843F1]]></AD_TEXTINTERFACES_ID> <!--4A2CBA2EA7EF4F01843340C1921843F1--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -14773,6 +14905,17 @@ <!--5708B2818D3B40DFACC92839DE74CD00--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--5708B2818D3B40DFACC92839DE74CD00--></AD_TEXTINTERFACES> +<!--5775AC35D1884F8994A76E4F9D0183BD--><AD_TEXTINTERFACES> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <AD_TEXTINTERFACES_ID><![CDATA[5775AC35D1884F8994A76E4F9D0183BD]]></AD_TEXTINTERFACES_ID> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <TEXT><![CDATA[Sales rep.]]></TEXT> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--5775AC35D1884F8994A76E4F9D0183BD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--5775AC35D1884F8994A76E4F9D0183BD--></AD_TEXTINTERFACES> + <!--577D60287C4D9046E040007F010043BC--><AD_TEXTINTERFACES> <!--577D60287C4D9046E040007F010043BC--> <AD_TEXTINTERFACES_ID><![CDATA[577D60287C4D9046E040007F010043BC]]></AD_TEXTINTERFACES_ID> <!--577D60287C4D9046E040007F010043BC--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -18282,6 +18425,17 @@ <!--7F43B45FA64349EEB3B4D648D94C4D6D--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--7F43B45FA64349EEB3B4D648D94C4D6D--></AD_TEXTINTERFACES> +<!--7FC50E9FA3C645B0891C636C73EF4442--><AD_TEXTINTERFACES> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <AD_TEXTINTERFACES_ID><![CDATA[7FC50E9FA3C645B0891C636C73EF4442]]></AD_TEXTINTERFACES_ID> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <TEXT><![CDATA[Cost Ref]]></TEXT> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--7FC50E9FA3C645B0891C636C73EF4442--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--7FC50E9FA3C645B0891C636C73EF4442--></AD_TEXTINTERFACES> + <!--7FE8FB5A56364220AFD4C71D2E2D457B--><AD_TEXTINTERFACES> <!--7FE8FB5A56364220AFD4C71D2E2D457B--> <AD_TEXTINTERFACES_ID><![CDATA[7FE8FB5A56364220AFD4C71D2E2D457B]]></AD_TEXTINTERFACES_ID> <!--7FE8FB5A56364220AFD4C71D2E2D457B--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -18348,6 +18502,17 @@ <!--83138086E1BB4553A01995EE567C1BF5--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--83138086E1BB4553A01995EE567C1BF5--></AD_TEXTINTERFACES> +<!--839DD11BD461499E8740BF211BBB08BD--><AD_TEXTINTERFACES> +<!--839DD11BD461499E8740BF211BBB08BD--> <AD_TEXTINTERFACES_ID><![CDATA[839DD11BD461499E8740BF211BBB08BD]]></AD_TEXTINTERFACES_ID> +<!--839DD11BD461499E8740BF211BBB08BD--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--839DD11BD461499E8740BF211BBB08BD--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--839DD11BD461499E8740BF211BBB08BD--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--839DD11BD461499E8740BF211BBB08BD--> <TEXT><![CDATA[Margin diff]]></TEXT> +<!--839DD11BD461499E8740BF211BBB08BD--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--839DD11BD461499E8740BF211BBB08BD--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--839DD11BD461499E8740BF211BBB08BD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--839DD11BD461499E8740BF211BBB08BD--></AD_TEXTINTERFACES> + <!--83A34A4C0D067671E040007F010125A3--><AD_TEXTINTERFACES> <!--83A34A4C0D067671E040007F010125A3--> <AD_TEXTINTERFACES_ID><![CDATA[83A34A4C0D067671E040007F010125A3]]></AD_TEXTINTERFACES_ID> <!--83A34A4C0D067671E040007F010125A3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -19853,6 +20018,17 @@ <!--95CA79458E3CC420E040007F01015644--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--95CA79458E3CC420E040007F01015644--></AD_TEXTINTERFACES> +<!--96367EE4E03F4C22B3D091F52588E236--><AD_TEXTINTERFACES> +<!--96367EE4E03F4C22B3D091F52588E236--> <AD_TEXTINTERFACES_ID><![CDATA[96367EE4E03F4C22B3D091F52588E236]]></AD_TEXTINTERFACES_ID> +<!--96367EE4E03F4C22B3D091F52588E236--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--96367EE4E03F4C22B3D091F52588E236--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--96367EE4E03F4C22B3D091F52588E236--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--96367EE4E03F4C22B3D091F52588E236--> <TEXT><![CDATA[A.3%]]></TEXT> +<!--96367EE4E03F4C22B3D091F52588E236--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--96367EE4E03F4C22B3D091F52588E236--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--96367EE4E03F4C22B3D091F52588E236--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--96367EE4E03F4C22B3D091F52588E236--></AD_TEXTINTERFACES> + <!--982644405A4C4BC6AD687D6014C11878--><AD_TEXTINTERFACES> <!--982644405A4C4BC6AD687D6014C11878--> <AD_TEXTINTERFACES_ID><![CDATA[982644405A4C4BC6AD687D6014C11878]]></AD_TEXTINTERFACES_ID> <!--982644405A4C4BC6AD687D6014C11878--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -20315,6 +20491,17 @@ <!--AD935A21C34B4D4DAB1A214124C25C07--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--AD935A21C34B4D4DAB1A214124C25C07--></AD_TEXTINTERFACES> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--><AD_TEXTINTERFACES> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <AD_TEXTINTERFACES_ID><![CDATA[ADB63E1CE69F46249E8DF8FC7CE538FE]]></AD_TEXTINTERFACES_ID> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <TEXT><![CDATA[M. Ref3%]]></TEXT> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--ADB63E1CE69F46249E8DF8FC7CE538FE--></AD_TEXTINTERFACES> + <!--AE7B8660F2B811DDA8F4001D09C4A2FE--><AD_TEXTINTERFACES> <!--AE7B8660F2B811DDA8F4001D09C4A2FE--> <AD_TEXTINTERFACES_ID><![CDATA[AE7B8660F2B811DDA8F4001D09C4A2FE]]></AD_TEXTINTERFACES_ID> <!--AE7B8660F2B811DDA8F4001D09C4A2FE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -20821,6 +21008,17 @@ <!--BC2ADB71F77CFC33E040A8C064002DA8--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--BC2ADB71F77CFC33E040A8C064002DA8--></AD_TEXTINTERFACES> +<!--BD38FCA4635243C5A29679AAE243C766--><AD_TEXTINTERFACES> +<!--BD38FCA4635243C5A29679AAE243C766--> <AD_TEXTINTERFACES_ID><![CDATA[BD38FCA4635243C5A29679AAE243C766]]></AD_TEXTINTERFACES_ID> +<!--BD38FCA4635243C5A29679AAE243C766--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--BD38FCA4635243C5A29679AAE243C766--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--BD38FCA4635243C5A29679AAE243C766--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--BD38FCA4635243C5A29679AAE243C766--> <TEXT><![CDATA[Profit Ref]]></TEXT> +<!--BD38FCA4635243C5A29679AAE243C766--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--BD38FCA4635243C5A29679AAE243C766--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--BD38FCA4635243C5A29679AAE243C766--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--BD38FCA4635243C5A29679AAE243C766--></AD_TEXTINTERFACES> + <!--BFB26FEF2745470C8456D5A1434DC1D3--><AD_TEXTINTERFACES> <!--BFB26FEF2745470C8456D5A1434DC1D3--> <AD_TEXTINTERFACES_ID><![CDATA[BFB26FEF2745470C8456D5A1434DC1D3]]></AD_TEXTINTERFACES_ID> <!--BFB26FEF2745470C8456D5A1434DC1D3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -20854,6 +21052,17 @@ <!--C0CADA462DC64FBD83F11FCFB658D412--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--C0CADA462DC64FBD83F11FCFB658D412--></AD_TEXTINTERFACES> +<!--C12868E7696C40248A46F1E3750395A5--><AD_TEXTINTERFACES> +<!--C12868E7696C40248A46F1E3750395A5--> <AD_TEXTINTERFACES_ID><![CDATA[C12868E7696C40248A46F1E3750395A5]]></AD_TEXTINTERFACES_ID> +<!--C12868E7696C40248A46F1E3750395A5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--C12868E7696C40248A46F1E3750395A5--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--C12868E7696C40248A46F1E3750395A5--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--C12868E7696C40248A46F1E3750395A5--> <TEXT><![CDATA[M. Ref%]]></TEXT> +<!--C12868E7696C40248A46F1E3750395A5--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--C12868E7696C40248A46F1E3750395A5--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--C12868E7696C40248A46F1E3750395A5--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--C12868E7696C40248A46F1E3750395A5--></AD_TEXTINTERFACES> + <!--C25EA66C5D9841209AE6AB7F11AE2F27--><AD_TEXTINTERFACES> <!--C25EA66C5D9841209AE6AB7F11AE2F27--> <AD_TEXTINTERFACES_ID><![CDATA[C25EA66C5D9841209AE6AB7F11AE2F27]]></AD_TEXTINTERFACES_ID> <!--C25EA66C5D9841209AE6AB7F11AE2F27--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21184,6 +21393,17 @@ <!--CE977BA940134F7FA8D6D83515D483CD--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--CE977BA940134F7FA8D6D83515D483CD--></AD_TEXTINTERFACES> +<!--CF47B491E98048FB963D16E9D72BF2EC--><AD_TEXTINTERFACES> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <AD_TEXTINTERFACES_ID><![CDATA[CF47B491E98048FB963D16E9D72BF2EC]]></AD_TEXTINTERFACES_ID> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <TEXT><![CDATA[Quantity Ref]]></TEXT> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--CF47B491E98048FB963D16E9D72BF2EC--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--CF47B491E98048FB963D16E9D72BF2EC--></AD_TEXTINTERFACES> + <!--CF7B445B487E4AC3A63CE243F78AE40D--><AD_TEXTINTERFACES> <!--CF7B445B487E4AC3A63CE243F78AE40D--> <AD_TEXTINTERFACES_ID><![CDATA[CF7B445B487E4AC3A63CE243F78AE40D]]></AD_TEXTINTERFACES_ID> <!--CF7B445B487E4AC3A63CE243F78AE40D--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21217,6 +21437,17 @@ <!--CFD9C649094548D4AE25DB1FD7286161--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--CFD9C649094548D4AE25DB1FD7286161--></AD_TEXTINTERFACES> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--><AD_TEXTINTERFACES> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <AD_TEXTINTERFACES_ID><![CDATA[CFEAC3F09AA1495B87B6D9B3FC3CB882]]></AD_TEXTINTERFACES_ID> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <TEXT><![CDATA[Cost Ref3]]></TEXT> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--CFEAC3F09AA1495B87B6D9B3FC3CB882--></AD_TEXTINTERFACES> + <!--D02ADB9E9D3A4589B407C8F40ED11B54--><AD_TEXTINTERFACES> <!--D02ADB9E9D3A4589B407C8F40ED11B54--> <AD_TEXTINTERFACES_ID><![CDATA[D02ADB9E9D3A4589B407C8F40ED11B54]]></AD_TEXTINTERFACES_ID> <!--D02ADB9E9D3A4589B407C8F40ED11B54--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21283,6 +21514,17 @@ <!--D149927F9A4A44A5A4E3818F97B3D460--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--D149927F9A4A44A5A4E3818F97B3D460--></AD_TEXTINTERFACES> +<!--D1739F83DA9D4BB389ACF95431CC60D7--><AD_TEXTINTERFACES> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <AD_TEXTINTERFACES_ID><![CDATA[D1739F83DA9D4BB389ACF95431CC60D7]]></AD_TEXTINTERFACES_ID> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <TEXT><![CDATA[A.2%]]></TEXT> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--D1739F83DA9D4BB389ACF95431CC60D7--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D1739F83DA9D4BB389ACF95431CC60D7--></AD_TEXTINTERFACES> + <!--D31ACC923A894905A06B66D61C6F76A2--><AD_TEXTINTERFACES> <!--D31ACC923A894905A06B66D61C6F76A2--> <AD_TEXTINTERFACES_ID><![CDATA[D31ACC923A894905A06B66D61C6F76A2]]></AD_TEXTINTERFACES_ID> <!--D31ACC923A894905A06B66D61C6F76A2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21327,6 +21569,17 @@ <!--D55D94632B5145F1B9F341617451079F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--D55D94632B5145F1B9F341617451079F--></AD_TEXTINTERFACES> +<!--D659C92FFEE04BBB822E856546D63D72--><AD_TEXTINTERFACES> +<!--D659C92FFEE04BBB822E856546D63D72--> <AD_TEXTINTERFACES_ID><![CDATA[D659C92FFEE04BBB822E856546D63D72]]></AD_TEXTINTERFACES_ID> +<!--D659C92FFEE04BBB822E856546D63D72--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D659C92FFEE04BBB822E856546D63D72--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D659C92FFEE04BBB822E856546D63D72--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D659C92FFEE04BBB822E856546D63D72--> <TEXT><![CDATA[Amount Ref2]]></TEXT> +<!--D659C92FFEE04BBB822E856546D63D72--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--D659C92FFEE04BBB822E856546D63D72--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--D659C92FFEE04BBB822E856546D63D72--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D659C92FFEE04BBB822E856546D63D72--></AD_TEXTINTERFACES> + <!--D6836A7FA29D4396AA319E5818DB66EE--><AD_TEXTINTERFACES> <!--D6836A7FA29D4396AA319E5818DB66EE--> <AD_TEXTINTERFACES_ID><![CDATA[D6836A7FA29D4396AA319E5818DB66EE]]></AD_TEXTINTERFACES_ID> <!--D6836A7FA29D4396AA319E5818DB66EE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21349,6 +21602,28 @@ <!--D69AA41C4E364F7385E8A4CC0C7E470F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--D69AA41C4E364F7385E8A4CC0C7E470F--></AD_TEXTINTERFACES> +<!--D764C465F33648D399F9E637319F0971--><AD_TEXTINTERFACES> +<!--D764C465F33648D399F9E637319F0971--> <AD_TEXTINTERFACES_ID><![CDATA[D764C465F33648D399F9E637319F0971]]></AD_TEXTINTERFACES_ID> +<!--D764C465F33648D399F9E637319F0971--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D764C465F33648D399F9E637319F0971--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D764C465F33648D399F9E637319F0971--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D764C465F33648D399F9E637319F0971--> <TEXT><![CDATA[Profit Ref2]]></TEXT> +<!--D764C465F33648D399F9E637319F0971--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--D764C465F33648D399F9E637319F0971--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--D764C465F33648D399F9E637319F0971--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D764C465F33648D399F9E637319F0971--></AD_TEXTINTERFACES> + +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--><AD_TEXTINTERFACES> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <AD_TEXTINTERFACES_ID><![CDATA[D7AA48D9A59E4C53B7536B6EEA2BB69A]]></AD_TEXTINTERFACES_ID> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <TEXT><![CDATA[M. Ref2%]]></TEXT> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--D7AA48D9A59E4C53B7536B6EEA2BB69A--></AD_TEXTINTERFACES> + <!--D9E52AB5AEAF4D2995B9852E4C8C8F8F--><AD_TEXTINTERFACES> <!--D9E52AB5AEAF4D2995B9852E4C8C8F8F--> <AD_TEXTINTERFACES_ID><![CDATA[D9E52AB5AEAF4D2995B9852E4C8C8F8F]]></AD_TEXTINTERFACES_ID> <!--D9E52AB5AEAF4D2995B9852E4C8C8F8F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21536,6 +21811,17 @@ <!--E30F1F5F7E0E4C388C508F9399897CD6--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--E30F1F5F7E0E4C388C508F9399897CD6--></AD_TEXTINTERFACES> +<!--E31152DED90C47749B8E3D7A49E49DDF--><AD_TEXTINTERFACES> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <AD_TEXTINTERFACES_ID><![CDATA[E31152DED90C47749B8E3D7A49E49DDF]]></AD_TEXTINTERFACES_ID> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <TEXT><![CDATA[Q.3%]]></TEXT> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--E31152DED90C47749B8E3D7A49E49DDF--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--E31152DED90C47749B8E3D7A49E49DDF--></AD_TEXTINTERFACES> + <!--E338C20A995D11DDABB6001D09C4A2FE--><AD_TEXTINTERFACES> <!--E338C20A995D11DDABB6001D09C4A2FE--> <AD_TEXTINTERFACES_ID><![CDATA[E338C20A995D11DDABB6001D09C4A2FE]]></AD_TEXTINTERFACES_ID> <!--E338C20A995D11DDABB6001D09C4A2FE--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21756,6 +22042,17 @@ <!--E870D62895BA41EA865329180E327DCC--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--E870D62895BA41EA865329180E327DCC--></AD_TEXTINTERFACES> +<!--E958BA9911F746D4B893F26AFDE8EA17--><AD_TEXTINTERFACES> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <AD_TEXTINTERFACES_ID><![CDATA[E958BA9911F746D4B893F26AFDE8EA17]]></AD_TEXTINTERFACES_ID> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <TEXT><![CDATA[M.%]]></TEXT> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--E958BA9911F746D4B893F26AFDE8EA17--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--E958BA9911F746D4B893F26AFDE8EA17--></AD_TEXTINTERFACES> + <!--EC40E4D9DE0541EAA8ABD0698BF5C115--><AD_TEXTINTERFACES> <!--EC40E4D9DE0541EAA8ABD0698BF5C115--> <AD_TEXTINTERFACES_ID><![CDATA[EC40E4D9DE0541EAA8ABD0698BF5C115]]></AD_TEXTINTERFACES_ID> <!--EC40E4D9DE0541EAA8ABD0698BF5C115--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21789,6 +22086,17 @@ <!--EF37F8AD6CF64607AB640944393D610B--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--EF37F8AD6CF64607AB640944393D610B--></AD_TEXTINTERFACES> +<!--EF56936544CF46AC921F73274DFCCF27--><AD_TEXTINTERFACES> +<!--EF56936544CF46AC921F73274DFCCF27--> <AD_TEXTINTERFACES_ID><![CDATA[EF56936544CF46AC921F73274DFCCF27]]></AD_TEXTINTERFACES_ID> +<!--EF56936544CF46AC921F73274DFCCF27--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--EF56936544CF46AC921F73274DFCCF27--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--EF56936544CF46AC921F73274DFCCF27--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--EF56936544CF46AC921F73274DFCCF27--> <TEXT><![CDATA[Profit Ref3]]></TEXT> +<!--EF56936544CF46AC921F73274DFCCF27--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--EF56936544CF46AC921F73274DFCCF27--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--EF56936544CF46AC921F73274DFCCF27--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--EF56936544CF46AC921F73274DFCCF27--></AD_TEXTINTERFACES> + <!--EF58A078931B4F91A77672FB31E2D289--><AD_TEXTINTERFACES> <!--EF58A078931B4F91A77672FB31E2D289--> <AD_TEXTINTERFACES_ID><![CDATA[EF58A078931B4F91A77672FB31E2D289]]></AD_TEXTINTERFACES_ID> <!--EF58A078931B4F91A77672FB31E2D289--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -21811,6 +22119,17 @@ <!--EF58CE8686F84DF9B010CE6269B3A39F--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--EF58CE8686F84DF9B010CE6269B3A39F--></AD_TEXTINTERFACES> +<!--EFCD18209CAF4E63B876136379A89592--><AD_TEXTINTERFACES> +<!--EFCD18209CAF4E63B876136379A89592--> <AD_TEXTINTERFACES_ID><![CDATA[EFCD18209CAF4E63B876136379A89592]]></AD_TEXTINTERFACES_ID> +<!--EFCD18209CAF4E63B876136379A89592--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--EFCD18209CAF4E63B876136379A89592--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--EFCD18209CAF4E63B876136379A89592--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--EFCD18209CAF4E63B876136379A89592--> <TEXT><![CDATA[Cost Ref2]]></TEXT> +<!--EFCD18209CAF4E63B876136379A89592--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--EFCD18209CAF4E63B876136379A89592--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--EFCD18209CAF4E63B876136379A89592--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--EFCD18209CAF4E63B876136379A89592--></AD_TEXTINTERFACES> + <!--F0B3D9CE4C8448518277E20EED9AF403--><AD_TEXTINTERFACES> <!--F0B3D9CE4C8448518277E20EED9AF403--> <AD_TEXTINTERFACES_ID><![CDATA[F0B3D9CE4C8448518277E20EED9AF403]]></AD_TEXTINTERFACES_ID> <!--F0B3D9CE4C8448518277E20EED9AF403--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -22218,6 +22537,17 @@ <!--FD9E7290E18A7584E040007F01015D57--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> <!--FD9E7290E18A7584E040007F01015D57--></AD_TEXTINTERFACES> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--><AD_TEXTINTERFACES> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <AD_TEXTINTERFACES_ID><![CDATA[FE34BF9EB08A4A068DFF9DAD8457B284]]></AD_TEXTINTERFACES_ID> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <TEXT><![CDATA[Weight Ref3]]></TEXT> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml]]></FILENAME> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <ISUSED><![CDATA[Y]]></ISUSED> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> +<!--FE34BF9EB08A4A068DFF9DAD8457B284--></AD_TEXTINTERFACES> + <!--FE5F8537C485BC8EE040007F01012D77--><AD_TEXTINTERFACES> <!--FE5F8537C485BC8EE040007F01012D77--> <AD_TEXTINTERFACES_ID><![CDATA[FE5F8537C485BC8EE040007F01012D77]]></AD_TEXTINTERFACES_ID> <!--FE5F8537C485BC8EE040007F01012D77--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml new file mode 100644 --- /dev/null +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml @@ -0,0 +1,1531 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ReportInvoiceCustomerDimensionalAnalysesComparativeXLS" pageWidth="3350" pageHeight="842" orientation="Landscape" columnWidth="3350" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true"> + <property name="ireport.scriptlethandling" value="0"/> + <property name="ireport.encoding" value="UTF-8"/> + <property name="ireport.zoom" value="0.75"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <import value="net.sf.jasperreports.engine.*"/> + <import value="java.util.*"/> + <import value="net.sf.jasperreports.engine.data.*"/> + <style name="default" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11"/> + <style name="Report_Title" fontName="Bitstream Vera Sans" fontSize="18"> + <box leftPadding="5"/> + </style> + <style name="Report_Subtitle" forecolor="#555555" fontName="Bitstream Vera Sans" fontSize="14"> + <box leftPadding="5"/> + </style> + <style name="Total_Field" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"> + <box leftPadding="5"/> + </style> + <style name="Detail_Header" mode="Opaque" forecolor="#FFFFFF" backcolor="#5D5D5D" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"> + <box leftPadding="5"> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#FFFFFF"/> + </box> + </style> + <style name="GroupHeader_DarkGray" mode="Opaque" forecolor="#FFFFFF" backcolor="#555555" vAlign="Middle" fontName="Bitstream Vera Sans" fontSize="18" isBold="true"> + <box leftPadding="5"/> + </style> + <style name="GroupHeader_Gray" mode="Opaque" backcolor="#999999"/> + <style name="Detail_Line" fontName="Bitstream Vera Sans" fontSize="11"> + <conditionalStyle> + <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> + <style mode="Opaque" backcolor="#CCCCCC"/> + </conditionalStyle> + </style> + <style name="Total_Gray" mode="Opaque" forecolor="#000000" backcolor="#CCCCCC"/> + <style name="Report_Data_Label" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> + <style name="Report_Data_Field" fontName="Bitstream Vera Sans" fontSize="11" isBold="false"/> + <style name="Report_Footer" isDefault="true" fontName="Bitstream Vera Sans" fontSize="11"/> + <style name="Group_Data_Label" fontName="Bitstream Vera Sans" fontSize="14" isBold="true"/> + <style name="Group_Data_Field" fontName="Bitstream Vera Sans" fontSize="14"/> + <style name="Detail_Data_Label" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> + <style name="Detail_Data_Field" mode="Opaque" backcolor="#CCCCCC" fontName="Bitstream Vera Sans" fontSize="11"/> + <style name="Group_Footer" fontName="Bitstream Vera Sans" fontSize="11" isBold="true"/> + <subDataset name="Table Dataset 1"/> + <parameter name="ATTACH" class="java.lang.String" isForPrompting="false"/> + <parameter name="BASE_WEB" class="java.lang.String" isForPrompting="false"/> + <parameter name="BASE_DESIGN" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["/opt/Apps230/src"]]></defaultValueExpression> + </parameter> + <parameter name="LANGUAGE" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["en_US"]]></defaultValueExpression> + </parameter> + <parameter name="USER_CLIENT" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["'0','1000000'"]]></defaultValueExpression> + </parameter> + <parameter name="USER_ORG" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["'1000000','1000001'"]]></defaultValueExpression> + </parameter> + <parameter name="REPORT_SUBTITLE" class="java.lang.String" isForPrompting="false"/> + <parameter name="NUMBERFORMAT" class="java.text.DecimalFormat" isForPrompting="false"> + <defaultValueExpression><![CDATA[new DecimalFormat("###,##0.00", new DecimalFormatSymbols())]]></defaultValueExpression> + </parameter> + <parameter name="LOCALE" class="java.util.Locale" isForPrompting="false"/> + <parameter name="strDateFormat" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["dd/MM/yyyy"]]></defaultValueExpression> + </parameter> + <queryString> + <![CDATA[SELECT ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, + SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(COSTREF) AS COSTREF, + SUM(AMOUNTREF2) AS AMOUNTREF2, SUM(QTYREF2) AS QTYREF2, SUM(WEIGHTREF2) AS WEIGHTREF2, SUM(COSTREF2) AS COSTREF2, SUM(AMOUNTREF3) AS AMOUNTREF3, SUM(QTYREF3) AS QTYREF3, SUM(WEIGHTREF3) AS WEIGHTREF3, SUM(COSTREF3) AS COSTREF3, + SUM(CONVAMOUNT) AS CONVAMOUNT, SUM(CONVCOST) AS CONVCOST, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, SUM(CONVCOSTREF) AS CONVCOSTREF, SUM(CONVAMOUNTREF2) AS CONVAMOUNTREF2, SUM(CONVCOSTREF2) AS CONVCOSTREF2, SUM(CONVAMOUNTREF3) AS CONVAMOUNTREF3, SUM(CONVCOSTREF3) AS CONVCOSTREF3 + FROM (SELECT ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, + SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST, + SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, SUM(COSTREF) AS COSTREF, + SUM(LINENETREF2) AS AMOUNTREF2, SUM(QTYINVOICEDREF2) AS QTYREF2, SUM(WEIGHT_REF2) AS WEIGHTREF2, SUM(COSTREF2) AS COSTREF2, + SUM(LINENETREF3) AS AMOUNTREF3, SUM(QTYINVOICEDREF3) AS QTYREF3, SUM(WEIGHT_REF3) AS WEIGHTREF3, SUM(COSTREF3) AS COSTREF3, + C_CURRENCY_CONVERT(SUM(LINENETAMT), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COST) WHEN SUM(COSTEDAMT) = 0 THEN 0 ELSE SUM(COST)*SUM(LINENETAMT)/SUM(COSTEDAMT) END AS CONVCOST, + C_CURRENCY_CONVERT(SUM(LINENETREF), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF) WHEN SUM(COSTEDAMTREF) = 0 THEN 0 ELSE SUM(COSTREF)*SUM(LINENETREF)/SUM(COSTEDAMTREF) END AS CONVCOSTREF, + C_CURRENCY_CONVERT(SUM(LINENETREF2), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF2, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF2) WHEN SUM(COSTEDAMTREF2) = 0 THEN 0 ELSE SUM(COSTREF2)*SUM(LINENETREF2)/SUM(COSTEDAMTREF2) END AS CONVCOSTREF2, + C_CURRENCY_CONVERT(SUM(LINENETREF3), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF3, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF3) WHEN SUM(COSTEDAMTREF3) = 0 THEN 0 ELSE SUM(COSTREF3)*SUM(LINENETREF3)/SUM(COSTEDAMTREF3) END AS CONVCOSTREF3, + TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, SUM(AA.COSTCALCULATED) as COSTCALCULATED, + C_CURRENCY_CONVERT(SUM(COSTEDAMT), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamt, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF2), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref2, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF3), TRCURRENCYID, '100', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref3 + FROM (SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char('en_US'))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char('en_US')) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char('en_US'))) AS ADDRESS, + C_INVOICELINE.LINENETAMT, C_INVOICELINE.QTYINVOICED, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,'100',trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COST, + 0 AS COSTREF, + 0 AS COSTREF2, + 0 AS COSTREF3, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMT, + 0 AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 0=0 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN ('7') + AND 1=1 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char('en_US'))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char('en_US')) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char('en_US'))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + C_INVOICELINE.LINENETAMT AS LINENETREF, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,'100',trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF, + 0 AS COSTREF2, + 0 AS COSTREF3, + 0 AS COSTEDAMT, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 3=3 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('14') + AND 2=2 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char('en_US'))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char('en_US')) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char('en_US'))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + C_INVOICELINE.LINENETAMT AS LINENETREF2, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF2, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + 0 AS COSTREF, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,'100',trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF2, + 0 AS COSTREF3, + 0 AS COSTEDAMT, + 0 AS COSTEDAMTREF, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 5=5 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('38') + AND 4=4 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char('en_US'))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char('en_US'))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char('en_US')) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char('en_US'))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + C_INVOICELINE.LINENETAMT AS LINENETREF3, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF3, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + 0 AS COSTREF, + 0 AS COSTREF2, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,'100',trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF3, + 0 AS COSTEDAMT, + 0 AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 7=7 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('49') + AND 6=6 + ) AA + GROUP BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID + ) ZZ + GROUP BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, 1 + ORDER BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, 1]]> + </queryString> + <field name="ORG" class="java.lang.String"/> + <field name="PARTNERGROUP" class="java.lang.String"/> + <field name="PARTNER" class="java.lang.String"/> + <field name="PRODCATEGORY" class="java.lang.String"/> + <field name="PRODUCT" class="java.lang.String"/> + <field name="CONTACT" class="java.lang.String"/> + <field name="SALESREP" class="java.lang.String"/> + <field name="PROJECT" class="java.lang.String"/> + <field name="ADDRESS" class="java.lang.String"/> + <field name="AMOUNT" class="java.math.BigDecimal"/> + <field name="QTY" class="java.math.BigDecimal"/> + <field name="WEIGHT" class="java.math.BigDecimal"/> + <field name="COST" class="java.math.BigDecimal"/> + <field name="AMOUNTREF" class="java.math.BigDecimal"/> + <field name="QTYREF" class="java.math.BigDecimal"/> + <field name="WEIGHTREF" class="java.math.BigDecimal"/> + <field name="COSTREF" class="java.math.BigDecimal"/> + <field name="AMOUNTREF2" class="java.math.BigDecimal"/> + <field name="QTYREF2" class="java.math.BigDecimal"/> + <field name="WEIGHTREF2" class="java.math.BigDecimal"/> + <field name="COSTREF2" class="java.math.BigDecimal"/> + <field name="AMOUNTREF3" class="java.math.BigDecimal"/> + <field name="QTYREF3" class="java.math.BigDecimal"/> + <field name="WEIGHTREF3" class="java.math.BigDecimal"/> + <field name="COSTREF3" class="java.math.BigDecimal"/> + <field name="CONVAMOUNT" class="java.math.BigDecimal"/> + <field name="CONVCOST" class="java.math.BigDecimal"/> + <field name="CONVAMOUNTREF" class="java.math.BigDecimal"/> + <field name="CONVCOSTREF" class="java.math.BigDecimal"/> + <field name="CONVAMOUNTREF2" class="java.math.BigDecimal"/> + <field name="CONVCOSTREF2" class="java.math.BigDecimal"/> + <field name="CONVAMOUNTREF3" class="java.math.BigDecimal"/> + <field name="CONVCOSTREF3" class="java.math.BigDecimal"/> + <field name="COSTCALCULATED" class="java.lang.Integer"/> + <variable name="AMOUNT" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVAMOUNT}]]></variableExpression> + </variable> + <variable name="COST" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVCOST}]]></variableExpression> + </variable> + <variable name="PROFIT" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$V{AMOUNT}.subtract($V{COST})]]></variableExpression> + </variable> + <variable name="MARGIN" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNT}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0): $V{PROFIT}.divide( $V{AMOUNT}, 4, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="AMOUNTREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVAMOUNTREF}]]></variableExpression> + </variable> + <variable name="COSTREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVCOSTREF}]]></variableExpression> + </variable> + <variable name="PROFITREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$V{AMOUNTREF}.subtract($V{COSTREF})]]></variableExpression> + </variable> + <variable name="MARGINREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF}.compareTo( new BigDecimal(0.0) )==0)?new BigDecimal(0.0):$V{PROFITREF}.divide( $V{AMOUNTREF}, 4, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="AMOUNT_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT}.subtract($V{AMOUNTREF}).divide( $V{AMOUNTREF}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="MARGINDIFF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{MARGIN}!=null && $V{MARGINREF}!=null )?new BigDecimal(0.0):$V{MARGIN}.subtract( $V{MARGINREF})]]></variableExpression> + </variable> + <variable name="AMOUNTREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVAMOUNTREF2}]]></variableExpression> + </variable> + <variable name="COSTREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVCOSTREF2}]]></variableExpression> + </variable> + <variable name="PROFITREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$V{AMOUNTREF2}.subtract($V{COSTREF2})]]></variableExpression> + </variable> + <variable name="MARGINREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF2}.compareTo( new BigDecimal(0.0) )==0)?new BigDecimal(0.0):$V{PROFITREF}.divide( $V{AMOUNTREF2}, 4, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="AMOUNT2_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT}.subtract($V{AMOUNTREF2}).divide( $V{AMOUNTREF2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="MARGINDIFF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{MARGIN}!=null && $V{MARGINREF2}!=null )?new BigDecimal(0.0):$V{MARGIN}.subtract( $V{MARGINREF2})]]></variableExpression> + </variable> + <variable name="AMOUNTREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVAMOUNTREF3}]]></variableExpression> + </variable> + <variable name="COSTREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{CONVCOSTREF3}]]></variableExpression> + </variable> + <variable name="PROFITREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$V{AMOUNTREF3}.subtract($V{COSTREF3})]]></variableExpression> + </variable> + <variable name="MARGINREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF3}.compareTo( new BigDecimal(0.0) )==0)?new BigDecimal(0.0):$V{PROFITREF3}.divide( $V{AMOUNTREF3}, 4, BigDecimal.ROUND_HALF_UP ).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="AMOUNT3_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{AMOUNTREF3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{AMOUNT}.subtract($V{AMOUNTREF3}).divide( $V{AMOUNTREF3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="MARGINDIFF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{MARGIN}!=null && $V{MARGINREF3}!=null )?new BigDecimal(0.0):$V{MARGIN}.subtract( $V{MARGINREF3})]]></variableExpression> + </variable> + <variable name="WEIGHT" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{WEIGHT}]]></variableExpression> + </variable> + <variable name="WEIGHTREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{WEIGHTREF}]]></variableExpression> + </variable> + <variable name="WEIGHTREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{WEIGHTREF2}]]></variableExpression> + </variable> + <variable name="WEIGHTREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{WEIGHTREF3}]]></variableExpression> + </variable> + <variable name="QTY" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{QTY}]]></variableExpression> + </variable> + <variable name="QTYREF" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{QTYREF}]]></variableExpression> + </variable> + <variable name="QTY_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{QTYREF}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY}.subtract($V{QTYREF}).divide( $V{QTYREF}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="QTYREF2" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{QTYREF2}]]></variableExpression> + </variable> + <variable name="QTY2_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{QTYREF2}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY}.subtract($V{QTYREF2}).divide( $V{QTYREF2}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <variable name="QTYREF3" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[$F{QTYREF3}]]></variableExpression> + </variable> + <variable name="QTY3_PER" class="java.math.BigDecimal" resetType="None"> + <variableExpression><![CDATA[($V{QTYREF3}.compareTo( new BigDecimal(0.0) )==0)? new BigDecimal(0.0):$V{QTY}.subtract($V{QTYREF3}).divide( $V{QTYREF3}, 2, BigDecimal.ROUND_HALF_UP).multiply(new BigDecimal(100.0))]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band splitType="Stretch"/> + </title> + <pageHeader> + <band height="15" splitType="Stretch"> + <staticText> + <reportElement key="element-1" style="Detail_Header" x="0" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Organization]]></text> + </staticText> + <staticText> + <reportElement key="element-2" style="Detail_Header" x="100" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Business Partner Group]]></text> + </staticText> + <staticText> + <reportElement key="element-3" style="Detail_Header" x="200" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Business Partner]]></text> + </staticText> + <staticText> + <reportElement key="element-4" style="Detail_Header" x="300" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Product Category]]></text> + </staticText> + <staticText> + <reportElement key="element-5" style="Detail_Header" x="400" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Product]]></text> + </staticText> + <staticText> + <reportElement key="element-7" style="Detail_Header" x="500" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Contact]]></text> + </staticText> + <staticText> + <reportElement key="element-8" style="Detail_Header" x="600" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Sales rep.]]></text> + </staticText> + <staticText> + <reportElement key="element-9" style="Detail_Header" x="700" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Project]]></text> + </staticText> + <staticText> + <reportElement key="element-10" style="Detail_Header" x="800" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Ship to address]]></text> + </staticText> + <staticText> + <reportElement key="element-11" style="Detail_Header" x="900" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Amount]]></text> + </staticText> + <staticText> + <reportElement key="element-12" style="Detail_Header" x="1000" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Cost]]></text> + </staticText> + <staticText> + <reportElement key="element-13" style="Detail_Header" x="1100" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Profit]]></text> + </staticText> + <staticText> + <reportElement key="element-14" style="Detail_Header" x="1200" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[M.%]]></text> + </staticText> + <staticText> + <reportElement key="element-15" style="Detail_Header" x="1250" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Amount Ref]]></text> + </staticText> + <staticText> + <reportElement key="element-16" style="Detail_Header" x="1350" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Cost Ref]]></text> + </staticText> + <staticText> + <reportElement key="element-17" style="Detail_Header" x="1450" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Profit Ref]]></text> + </staticText> + <staticText> + <reportElement key="element-18" style="Detail_Header" x="1550" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[M. Ref%]]></text> + </staticText> + <staticText> + <reportElement key="element-19" style="Detail_Header" x="1600" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[A.%]]></text> + </staticText> + <staticText> + <reportElement key="element-20" style="Detail_Header" x="1650" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Margin diff]]></text> + </staticText> + <staticText> + <reportElement key="element-21" style="Detail_Header" x="1700" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Amount Ref2]]></text> + </staticText> + <staticText> + <reportElement key="element-22" style="Detail_Header" x="1800" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Cost Ref2]]></text> + </staticText> + <staticText> + <reportElement key="element-23" style="Detail_Header" x="1900" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Profit Ref2]]></text> + </staticText> + <staticText> + <reportElement key="element-24" style="Detail_Header" x="2000" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[M. Ref2%]]></text> + </staticText> + <staticText> + <reportElement key="element-25" style="Detail_Header" x="2050" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[A.2%]]></text> + </staticText> + <staticText> + <reportElement key="element-26" style="Detail_Header" x="2100" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Margin diff2]]></text> + </staticText> + <staticText> + <reportElement key="element-27" style="Detail_Header" x="2150" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Amount Ref3]]></text> + </staticText> + <staticText> + <reportElement key="element-28" style="Detail_Header" x="2250" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Cost Ref3]]></text> + </staticText> + <staticText> + <reportElement key="element-29" style="Detail_Header" x="2350" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Profit Ref3]]></text> + </staticText> + <staticText> + <reportElement key="element-30" style="Detail_Header" x="2450" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[M. Ref3%]]></text> + </staticText> + <staticText> + <reportElement key="element-31" style="Detail_Header" x="2500" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[A.3%]]></text> + </staticText> + <staticText> + <reportElement key="element-32" style="Detail_Header" x="2550" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Margin diff3]]></text> + </staticText> + <staticText> + <reportElement key="element-33" style="Detail_Header" x="2600" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Weight]]></text> + </staticText> + <staticText> + <reportElement key="element-34" style="Detail_Header" x="2650" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Weight Ref]]></text> + </staticText> + <staticText> + <reportElement key="element-35" style="Detail_Header" x="2700" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Weight Ref2]]></text> + </staticText> + <staticText> + <reportElement key="element-36" style="Detail_Header" x="2750" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Weight Ref3]]></text> + </staticText> + <staticText> + <reportElement key="element-37" style="Detail_Header" x="2800" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Quantity]]></text> + </staticText> + <staticText> + <reportElement key="element-38" style="Detail_Header" x="2900" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Quantity Ref]]></text> + </staticText> + <staticText> + <reportElement key="element-39" style="Detail_Header" x="3000" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Q.%]]></text> + </staticText> + <staticText> + <reportElement key="element-40" style="Detail_Header" x="3050" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Quantity Ref2]]></text> + </staticText> + <staticText> + <reportElement key="element-41" style="Detail_Header" x="3150" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Q.2%]]></text> + </staticText> + <staticText> + <reportElement key="element-42" style="Detail_Header" x="3200" y="0" width="100" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Quantity Ref3]]></text> + </staticText> + <staticText> + <reportElement key="element-43" style="Detail_Header" x="3300" y="0" width="50" height="15"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#333333"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Q.3%]]></text> + </staticText> + </band> + </pageHeader> + <columnHeader> + <band splitType="Stretch"/> + </columnHeader> + <detail> + <band height="13" splitType="Stretch"> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-1" stretchType="RelativeToBandHeight" x="0" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Left"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{ORG}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-2" stretchType="RelativeToBandHeight" x="100" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{PARTNERGROUP}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-3" stretchType="RelativeToBandHeight" x="200" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{PARTNER}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement key="textField-4" stretchType="RelativeToBandHeight" x="300" y="0" width="100" height="13"/> + <box rightPadding="2"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{PRODCATEGORY}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement key="textField-5" stretchType="RelativeToBandHeight" x="400" y="0" width="100" height="13"/> + <box rightPadding="2"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{PRODUCT}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-7" stretchType="RelativeToBandHeight" x="500" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{CONTACT}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-8" stretchType="RelativeToBandHeight" x="600" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{SALESREP}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-9" stretchType="RelativeToBandHeight" x="700" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{PROJECT}]]></textFieldExpression> + </textField> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true"> + <reportElement key="textField-10" stretchType="RelativeToBandHeight" x="800" y="0" width="100" height="13"/> + <box leftPadding="5" rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font size="8" isBold="false"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{ADDRESS}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-11" stretchType="RelativeToBandHeight" x="900" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNT}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-12" stretchType="RelativeToBandHeight" x="1000" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{COST}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-13" stretchType="RelativeToBandHeight" x="1100" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROFIT}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-14" stretchType="RelativeToBandHeight" x="1200" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGIN}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-15" stretchType="RelativeToBandHeight" x="1250" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNTREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-16" stretchType="RelativeToBandHeight" x="1350" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{COSTREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-17" stretchType="RelativeToBandHeight" x="1450" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROFITREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-18" stretchType="RelativeToBandHeight" x="1550" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-19" stretchType="RelativeToBandHeight" x="1600" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNT_PER}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-20" stretchType="RelativeToBandHeight" x="1650" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINDIFF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-21" stretchType="RelativeToBandHeight" x="1700" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNTREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-22" stretchType="RelativeToBandHeight" x="1800" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{COSTREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-23" stretchType="RelativeToBandHeight" x="1900" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROFITREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-24" stretchType="RelativeToBandHeight" x="2000" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-25" stretchType="RelativeToBandHeight" x="2050" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNT2_PER}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-26" stretchType="RelativeToBandHeight" x="2100" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINDIFF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-27" stretchType="RelativeToBandHeight" x="2150" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNTREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-28" stretchType="RelativeToBandHeight" x="2250" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{COSTREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-29" stretchType="RelativeToBandHeight" x="2350" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROFITREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-30" stretchType="RelativeToBandHeight" x="2450" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-31" stretchType="RelativeToBandHeight" x="2500" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{AMOUNT3_PER}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="false"> + <reportElement key="textField-32" stretchType="RelativeToBandHeight" x="2550" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{MARGINDIFF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-33" stretchType="RelativeToBandHeight" x="2600" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{WEIGHT}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-34" stretchType="RelativeToBandHeight" x="2650" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{WEIGHTREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-35" stretchType="RelativeToBandHeight" x="2700" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{WEIGHTREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-36" stretchType="RelativeToBandHeight" x="2750" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{WEIGHTREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-37" stretchType="RelativeToBandHeight" x="2800" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTY}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-38" stretchType="RelativeToBandHeight" x="2900" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTYREF}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-39" stretchType="RelativeToBandHeight" x="3000" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTY_PER}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-40" stretchType="RelativeToBandHeight" x="3050" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTYREF2}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-41" stretchType="RelativeToBandHeight" x="3150" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTY2_PER}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-42" stretchType="RelativeToBandHeight" x="3200" y="0" width="100" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTYREF3}]]></textFieldExpression> + </textField> + <textField pattern="" isBlankWhenNull="true"> + <reportElement key="textField-43" stretchType="RelativeToBandHeight" x="3300" y="0" width="50" height="13"/> + <box rightPadding="2"> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{QTY3_PER}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band splitType="Stretch"/> + </pageFooter> + <summary> + <band splitType="Stretch"/> + </summary> +</jasperReport> diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java --- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java @@ -799,14 +799,53 @@ OBError myMessage = null; myMessage = new OBError(); if ("xls".equals(strOutput)) { + // Resets Order By + strOrderby = ""; + if (strOrder.equals("Amountasc")) { + strOrderby += ", CONVAMOUNT ASC"; + } else if (strOrder.equals("Amountdesc")) { + strOrderby += ", CONVAMOUNT DESC"; + } else { + strOrderby = ", 1"; + } try { - dataXLS = ReportInvoiceCustomerDimensionalAnalysesJRData.selectXLS(this, strCurrencyId, - Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg), Utility - .getContext(this, vars, "#User_Client", - "ReportInvoiceCustomerDimensionalAnalysesJR"), strDateFrom, DateTimeData - .nDaysAfter(this, strDateTo, "1"), strPartnerGroup, strcBpartnerId, - strProductCategory, strmProductId, strsalesrepId, strPartnerSalesrepId, - strcProjectId, strProducttype, strcDocTypeId); + if (strComparative.equals("Y")) { + dataXLS = ReportInvoiceCustomerDimensionalAnalysesJRData.selectComparativeXLS( + this, + strCurrencyId, + vars.getLanguage(), + Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg), + Utility.getContext(this, vars, "#User_Client", + "ReportInvoiceCustomerDimensionalAnalysesJR"), + strDateFrom, + DateTimeData.nDaysAfter(this, strDateTo, "1"), + strPartnerGroup, + strcBpartnerId, + strProductCategory, + strmProductId, + strsalesrepId, + strPartnerSalesrepId, + strcProjectId, + strProducttype, + strcDocTypeId, + "".equals(strDateFromRef) ? "31-12-9999" : strDateFromRef, + "".equals(strDateToRef) ? "31-12-9999" : DateTimeData.nDaysAfter(this, + strDateToRef, "1"), + "".equals(strDateFromRef2) ? "31-12-9999" : strDateFromRef2, + "".equals(strDateToRef2) ? "31-12-9999" : DateTimeData.nDaysAfter(this, + strDateToRef2, "1"), + "".equals(strDateFromRef3) ? "31-12-9999" : strDateFromRef3, + "".equals(strDateToRef3) ? "31-12-9999" : DateTimeData.nDaysAfter(this, + strDateToRef3, "1"), strHaving, strOrderby); + } else { + dataXLS = ReportInvoiceCustomerDimensionalAnalysesJRData.selectXLS(this, strCurrencyId, + Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg), Utility + .getContext(this, vars, "#User_Client", + "ReportInvoiceCustomerDimensionalAnalysesJR"), strDateFrom, DateTimeData + .nDaysAfter(this, strDateTo, "1"), strPartnerGroup, strcBpartnerId, + strProductCategory, strmProductId, strsalesrepId, strPartnerSalesrepId, + strcProjectId, strProducttype, strcDocTypeId); + } } catch (ServletException ex) { myMessage = Utility.translateError(this, vars, vars.getLanguage(), ex.getMessage()); } @@ -894,6 +933,9 @@ * LimitRowsScrollableFieldProviderFilter( dataXLS, rowLimit); */ String strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesXLS.jrxml"; + if (strComparative.equals("Y")) { + strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml"; + } HashMap<String, Object> parameters = new HashMap<String, Object>(); diff --git a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql --- a/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql +++ b/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql @@ -1171,4 +1171,313 @@ <Parameter name="producttype" optional="true" after="AND 1=1"><![CDATA[AND M_PRODUCT.PRODUCTTYPE = ?]]></Parameter> <Parameter name="cDocTypeId" optional="true" type="argument" after="AND 1=1"><![CDATA[AND C_DOCTYPE.C_DOCTYPE_ID IN]]></Parameter> </SqlMethod> + + <SqlMethod name="selectComparativeXLS" type="preparedStatement" return="scrollable"> + <SqlMethodComment></SqlMethodComment> + <Sql> + <![CDATA[ + SELECT ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, + SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(COSTREF) AS COSTREF, + SUM(AMOUNTREF2) AS AMOUNTREF2, SUM(QTYREF2) AS QTYREF2, SUM(WEIGHTREF2) AS WEIGHTREF2, SUM(COSTREF2) AS COSTREF2, SUM(AMOUNTREF3) AS AMOUNTREF3, SUM(QTYREF3) AS QTYREF3, SUM(WEIGHTREF3) AS WEIGHTREF3, SUM(COSTREF3) AS COSTREF3, + SUM(CONVAMOUNT) AS CONVAMOUNT, SUM(CONVCOST) AS CONVCOST, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, SUM(CONVCOSTREF) AS CONVCOSTREF, SUM(CONVAMOUNTREF2) AS CONVAMOUNTREF2, SUM(CONVCOSTREF2) AS CONVCOSTREF2, SUM(CONVAMOUNTREF3) AS CONVAMOUNTREF3, SUM(CONVCOSTREF3) AS CONVCOSTREF3 + FROM (SELECT ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, + SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM(COST) AS COST, + SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, SUM(COSTREF) AS COSTREF, + SUM(LINENETREF2) AS AMOUNTREF2, SUM(QTYINVOICEDREF2) AS QTYREF2, SUM(WEIGHT_REF2) AS WEIGHTREF2, SUM(COSTREF2) AS COSTREF2, + SUM(LINENETREF3) AS AMOUNTREF3, SUM(QTYINVOICEDREF3) AS QTYREF3, SUM(WEIGHT_REF3) AS WEIGHTREF3, SUM(COSTREF3) AS COSTREF3, + C_CURRENCY_CONVERT(SUM(LINENETAMT), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COST) WHEN SUM(COSTEDAMT) = 0 THEN 0 ELSE SUM(COST)*SUM(LINENETAMT)/SUM(COSTEDAMT) END AS CONVCOST, + C_CURRENCY_CONVERT(SUM(LINENETREF), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF) WHEN SUM(COSTEDAMTREF) = 0 THEN 0 ELSE SUM(COSTREF)*SUM(LINENETREF)/SUM(COSTEDAMTREF) END AS CONVCOSTREF, + C_CURRENCY_CONVERT(SUM(LINENETREF2), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF2, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF2) WHEN SUM(COSTEDAMTREF2) = 0 THEN 0 ELSE SUM(COSTREF2)*SUM(LINENETREF2)/SUM(COSTEDAMTREF2) END AS CONVCOSTREF2, + C_CURRENCY_CONVERT(SUM(LINENETREF3), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNTREF3, + CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(COSTREF3) WHEN SUM(COSTEDAMTREF3) = 0 THEN 0 ELSE SUM(COSTREF3)*SUM(LINENETREF3)/SUM(COSTEDAMTREF3) END AS CONVCOSTREF3, + TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, SUM(AA.COSTCALCULATED) as COSTCALCULATED, + C_CURRENCY_CONVERT(SUM(COSTEDAMT), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamt, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF2), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref2, + C_CURRENCY_CONVERT(SUM(COSTEDAMTREF3), TRCURRENCYID, ?, TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamtref3 + FROM (SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( ?))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char( ?))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char( ?)) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char( ?))) AS ADDRESS, + C_INVOICELINE.LINENETAMT, C_INVOICELINE.QTYINVOICED, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COST, + 0 AS COSTREF, + 0 AS COSTREF2, + 0 AS COSTREF3, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMT, + 0 AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 0=0 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN ('7') + AND 1=1 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( ?))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char( ?))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char( ?)) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char( ?))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + C_INVOICELINE.LINENETAMT AS LINENETREF, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF, + 0 AS COSTREF2, + 0 AS COSTREF3, + 0 AS COSTEDAMT, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 3=3 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('14') + AND 2=2 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( ?))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char( ?))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char( ?)) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char( ?))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + C_INVOICELINE.LINENETAMT AS LINENETREF2, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF2, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF2, + 0 AS LINENETREF3, 0 AS QTYINVOICEDREF3, 0 AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + 0 AS COSTREF, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF2, + 0 AS COSTREF3, + 0 AS COSTEDAMT, + 0 AS COSTEDAMTREF, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF2, + 0 AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 5=5 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('38') + AND 4=4 + UNION ALL SELECT to_char(AD_ORG.NAME) AS ORG, to_char(C_BP_GROUP.NAME) AS PARTNERGROUP ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( ?))) AS PARTNER ,to_char(M_PRODUCT_CATEGORY.NAME) AS PRODCATEGORY ,to_char(AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char( ?))|| CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' ('||uomsymbol||')') END) AS PRODUCT ,to_char(C_INVOICE.DOCUMENTNO) AS DOCUMENTNO ,to_char(AD_USER.FIRSTNAME||' '||' '||AD_USER.LASTNAME) AS CONTACT , to_char(CASE WHEN AD_USER.AD_USER_ID IS NOT NULL THEN AD_COLUMN_IDENTIFIER(to_char('Ad_User'), to_char( AD_USER.AD_USER_ID), to_char( ?)) ELSE '' END) AS SALESREP ,to_char(C_PROJECT.NAME) AS PROJECT ,to_char(AD_COLUMN_IDENTIFIER(to_char('C_Bpartner_Location'), to_char( M_INOUT.C_BPARTNER_LOCATION_ID), to_char( ?))) AS ADDRESS, + 0 AS LINENETAMT, 0 AS QTYINVOICED, 0 AS WEIGHT, + 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, + 0 AS LINENETREF2, 0 AS QTYINVOICEDREF2, 0 AS WEIGHT_REF2, + C_INVOICELINE.LINENETAMT AS LINENETREF3, C_INVOICELINE.QTYINVOICED AS QTYINVOICEDREF3, C_INVOICELINE.QTYINVOICED*M_PRODUCT.WEIGHT AS WEIGHT_REF3, + C_UOM.UOMSYMBOL, + C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, + TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, + C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, + C_INVOICELINE.AD_ORG_ID AS TRORGID, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 + END AS COSTCALCULATED, + 0 AS COST, + 0 AS COSTREF, + 0 AS COSTREF2, + CASE WHEN (M_PRODUCT.ISSTOCKED='Y' AND M_PRODUCT.PRODUCTTYPE='I') THEN (CASE WHEN trx.movementqty = 0 THEN 0 ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(trxcost.cost/abs(trx.movementqty)*c_invoiceline.qtyinvoiced, C_GET_CURRENCY_PRECISION(trxcost.c_currency_id, 'C')), trxcost.c_currency_id,?,trx.movementdate,NULL,trx.ad_client_id,trx.ad_org_id,'C'), 0) END) + ELSE (COALESCE(M_GET_NO_TRX_PRODUCT_COST(M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, 'STA', ad_org.ad_org_id, null, C_INVOICE.C_CURRENCY_ID), 0)*C_INVOICELINE.QTYINVOICED) + END AS COSTREF3, + 0 AS COSTEDAMT, + 0 AS COSTEDAMTREF, + 0 AS COSTEDAMTREF2, + CASE WHEN trxcost.cost is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 + ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE='ARC' THEN C_INVOICELINE.LINENETAMT*-1 ELSE C_INVOICELINE.LINENETAMT END + END AS COSTEDAMTREF3 + FROM C_INVOICELINE + join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID + join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID + join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID + join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID + left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID + left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID + left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID + left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID=C_DOCTYPE.C_DOCTYPE_ID + left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID + left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID + left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID + left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID + left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID + left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id + left join (SELECT SUM(cost) as cost, m_transaction_id, c_currency_id + FROM m_transaction_cost + GROUP BY m_transaction_id, c_currency_id + ) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id + WHERE C_INVOICE.ISSOTRX = 'Y' + AND C_INVOICE.PROCESSED = 'Y' + AND 7=7 AND C_INVOICE.AD_ORG_ID IN ('1') + AND C_INVOICE.AD_CLIENT_ID IN('49') + AND 6=6 + ) AA + GROUP BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID + ) ZZ + GROUP BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, 1 + ORDER BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS, 1 + ]]></Sql> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="adOrgId" optional="true" type="replace" after="AND 0=0 AND C_INVOICE.AD_ORG_ID IN (" text="'1'"/> + <Parameter name="adUserClient" type="replace" optional="true" after="AND C_INVOICE.AD_CLIENT_ID IN (" text="'7'"/> + <Parameter name="dateFrom" optional="true" after="AND 1=1"><![CDATA[AND C_INVOICE.DATEINVOICED >= to_date(?)]]></Parameter> + <Parameter name="dateTo" optional="true" after="AND 1=1"><![CDATA[AND C_INVOICE.DATEINVOICED < to_date(?)]]></Parameter> + <Parameter name="cBpartnerGroupId" optional="true" after="AND 1=1"><![CDATA[AND C_BP_GROUP.C_BP_GROUP_ID = ?]]></Parameter> + <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 1=1"><![CDATA[AND C_BPARTNER.C_BPARTNER_ID IN]]></Parameter> + <Parameter name="mProductCategoryId" optional="true" after="AND 1=1"><![CDATA[AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = ?]]></Parameter> + <Parameter name="mProductId" optional="true" type="argument" after="AND 1=1"><![CDATA[AND M_PRODUCT.M_PRODUCT_ID IN]]></Parameter> + <Parameter name="salesrepId" optional="true" after="AND 1=1"><![CDATA[AND C_INVOICE.SALESREP_ID = ?]]></Parameter> + <Parameter name="partnerSalesrepId" optional="true" after="AND 1=1"><![CDATA[AND CB.C_BPARTNER_ID = ?]]></Parameter> + <Parameter name="cProjectId" optional="true" after="AND 1=1"><![CDATA[AND C_PROJECT.C_PROJECT_ID = ?]]></Parameter> + <Parameter name="producttype" optional="true" after="AND 1=1"><![CDATA[AND M_PRODUCT.PRODUCTTYPE = ?]]></Parameter> + <Parameter name="cDocTypeId" optional="true" type="argument" after="AND 1=1"><![CDATA[AND C_DOCTYPE.C_DOCTYPE_ID IN]]></Parameter> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="adOrgId" optional="true" type="replace" after="AND 3=3 AND C_INVOICE.AD_ORG_ID IN (" text="'1'"/> + <Parameter name="adUserClient" type="replace" optional="true" after="AND C_INVOICE.AD_CLIENT_ID IN(" text="'14'"/> + <Parameter name="dateFromRef" optional="true" after="AND 2=2"><![CDATA[AND C_INVOICE.DATEINVOICED >= to_date(?)]]></Parameter> + <Parameter name="dateToRef" optional="true" after="AND 2=2"><![CDATA[AND C_INVOICE.DATEINVOICED < to_date(?)]]></Parameter> + <Parameter name="cBpartnerGroupId" optional="true" after="AND 2=2"><![CDATA[AND C_BP_GROUP.C_BP_GROUP_ID = ?]]></Parameter> + <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 2=2"><![CDATA[AND C_BPARTNER.C_BPARTNER_ID IN]]></Parameter> + <Parameter name="mProductCategoryId" optional="true" after="AND 2=2"><![CDATA[AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = ?]]></Parameter> + <Parameter name="mProductId" optional="true" type="argument" after="AND 2=2"><![CDATA[AND M_PRODUCT.M_PRODUCT_ID IN]]></Parameter> + <Parameter name="salesrepId" optional="true" after="AND 2=2"><![CDATA[AND C_INVOICE.SALESREP_ID = ?]]></Parameter> + <Parameter name="partnerSalesrepId" optional="true" after="AND 2=2"><![CDATA[AND CB.C_BPARTNER_ID = ?]]></Parameter> + <Parameter name="cProjectId" optional="true" after="AND 2=2"><![CDATA[AND C_PROJECT.C_PROJECT_ID = ?]]></Parameter> + <Parameter name="producttype" optional="true" after="AND 2=2"><![CDATA[AND M_PRODUCT.PRODUCTTYPE = ?]]></Parameter> + <Parameter name="cDocTypeId" optional="true" type="argument" after="AND 2=2"><![CDATA[AND C_DOCTYPE.C_DOCTYPE_ID IN]]></Parameter> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="adOrgId" optional="true" type="replace" after="AND 5=5 AND C_INVOICE.AD_ORG_ID IN (" text="'1'"/> + <Parameter name="adUserClient" type="replace" optional="true" after="AND C_INVOICE.AD_CLIENT_ID IN(" text="'38'"/> + <Parameter name="dateFromRef2" optional="true" after="AND 4=4"><![CDATA[AND C_INVOICE.DATEINVOICED >= to_date(?)]]></Parameter> + <Parameter name="dateToRef2" optional="true" after="AND 4=4"><![CDATA[AND C_INVOICE.DATEINVOICED < to_date(?)]]></Parameter> + <Parameter name="cBpartnerGroupId" optional="true" after="AND 4=4"><![CDATA[AND C_BP_GROUP.C_BP_GROUP_ID = ?]]></Parameter> + <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 4=4"><![CDATA[AND C_BPARTNER.C_BPARTNER_ID IN]]></Parameter> + <Parameter name="mProductCategoryId" optional="true" after="AND 4=4"><![CDATA[AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = ?]]></Parameter> + <Parameter name="mProductId" optional="true" type="argument" after="AND 4=4"><![CDATA[AND M_PRODUCT.M_PRODUCT_ID IN]]></Parameter> + <Parameter name="salesrepId" optional="true" after="AND 4=4"><![CDATA[AND C_INVOICE.SALESREP_ID = ?]]></Parameter> + <Parameter name="partnerSalesrepId" optional="true" after="AND 4=4"><![CDATA[AND CB.C_BPARTNER_ID = ?]]></Parameter> + <Parameter name="cProjectId" optional="true" after="AND 4=4"><![CDATA[AND C_PROJECT.C_PROJECT_ID = ?]]></Parameter> + <Parameter name="producttype" optional="true" after="AND 4=4"><![CDATA[AND M_PRODUCT.PRODUCTTYPE = ?]]></Parameter> + <Parameter name="cDocTypeId" optional="true" type="argument" after="AND 4=4"><![CDATA[AND C_DOCTYPE.C_DOCTYPE_ID IN]]></Parameter> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="adLanguage"/> + <Parameter name="cCurrencyConv"/> + <Parameter name="adOrgId" optional="true" type="replace" after="AND 7=7 AND C_INVOICE.AD_ORG_ID IN (" text="'1'"/> + <Parameter name="adUserClient" type="replace" optional="true" after="AND C_INVOICE.AD_CLIENT_ID IN(" text="'49'"/> + <Parameter name="dateFromRef3" optional="true" after="AND 6=6"><![CDATA[AND C_INVOICE.DATEINVOICED >= to_date(?)]]></Parameter> + <Parameter name="dateToRef3" optional="true" after="AND 6=6"><![CDATA[AND C_INVOICE.DATEINVOICED < to_date(?)]]></Parameter> + <Parameter name="cBpartnerGroupId" optional="true" after="AND 6=6"><![CDATA[AND C_BP_GROUP.C_BP_GROUP_ID = ?]]></Parameter> + <Parameter name="cBpartnerId" optional="true" type="argument" after="AND 6=6"><![CDATA[AND C_BPARTNER.C_BPARTNER_ID IN]]></Parameter> + <Parameter name="mProductCategoryId" optional="true" after="AND 6=6"><![CDATA[AND M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID = ?]]></Parameter> + <Parameter name="mProductId" optional="true" type="argument" after="AND 6=6"><![CDATA[AND M_PRODUCT.M_PRODUCT_ID IN]]></Parameter> + <Parameter name="salesrepId" optional="true" after="AND 6=6"><![CDATA[AND C_INVOICE.SALESREP_ID = ?]]></Parameter> + <Parameter name="partnerSalesrepId" optional="true" after="AND 6=6"><![CDATA[AND CB.C_BPARTNER_ID = ?]]></Parameter> + <Parameter name="cProjectId" optional="true" after="AND 6=6"><![CDATA[AND C_PROJECT.C_PROJECT_ID = ?]]></Parameter> + <Parameter name="producttype" optional="true" after="AND 6=6"><![CDATA[AND M_PRODUCT.PRODUCTTYPE = ?]]></Parameter> + <Parameter name="cDocTypeId" optional="true" type="argument" after="AND 6=6"><![CDATA[AND C_DOCTYPE.C_DOCTYPE_ID IN]]></Parameter> + <Parameter name="having" type="replace" optional="true" after="GROUP BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS" text=", 1"/> + <Parameter name="orderby" type="replace" optional="true" after="ORDER BY ORG, PARTNERGROUP, PARTNER, PRODCATEGORY, PRODUCT, CONTACT, SALESREP, PROJECT, ADDRESS" text=", 1"/> + </SqlMethod> + </SqlClass> | |||||||||||
![]() |
|||||||||||||||
|
![]() |
|||
Date Modified | Username | Field | Change |
2014-09-09 16:05 | rafaroda | New Issue | |
2014-09-09 16:05 | rafaroda | Assigned To | => rafaroda |
2014-09-09 16:05 | rafaroda | OBNetwork customer | => No |
2014-09-09 16:05 | rafaroda | Modules | => Core |
2014-09-09 16:05 | rafaroda | Triggers an Emergency Pack | => No |
2014-09-09 16:07 | rafaroda | Relationship added | related to 0026935 |
2014-09-17 08:26 | rafaroda | Relationship added | depends on 0027133 |
2014-09-17 08:50 | rafaroda | Assigned To | rafaroda => rafademiguel |
2014-09-17 08:50 | rafaroda | Proposed Solution updated | |
2014-09-17 08:51 | rafaroda | File Added: ReportInvoiceCustomerDimensionalAnalysesComparativeXLS.jrxml.xls | |
2014-09-17 09:17 | rafaroda | File Added: SIDRComparativeExcel.diff |
Copyright © 2000 - 2009 MantisBT Group |