details: https://code.openbravo.com/erp/devel/pi/rev/cdaa760eb486
changeset: 20156:cdaa760eb486
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Fri Apr 19 18:21:54 2013 +0200
summary: Fixes issue 23012
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml |
2 +-
src-db/database/sourcedata/AD_TAB.xml |
24 +++++-----
2 files changed, 13 insertions(+), 13 deletions(-)
diffs (123 lines):
diff -r c09f69635bed -r cdaa760eb486
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
Fri Apr 19 18:16:45 2013 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
Fri Apr 19 18:21:54 2013 +0200
@@ -55,7 +55,7 @@
<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
<!--1EA4A3F31A27483A8C6E93176AE912D3--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--1EA4A3F31A27483A8C6E93176AE912D3--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'30721072789F410E9606D2235CB2A226' and e.recordID =
@FIN_Doubtful_Debt.id@]]></HQLWHERECLAUSE>
-<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--1EA4A3F31A27483A8C6E93176AE912D3-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
diff -r c09f69635bed -r cdaa760eb486 src-db/database/sourcedata/AD_TAB.xml
--- a/src-db/database/sourcedata/AD_TAB.xml Fri Apr 19 18:16:45 2013 +0200
+++ b/src-db/database/sourcedata/AD_TAB.xml Fri Apr 19 18:21:54 2013 +0200
@@ -12181,7 +12181,7 @@
<!--1B49A74CF8314D02B7F41B6595A169D4-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--1B49A74CF8314D02B7F41B6595A169D4--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--1B49A74CF8314D02B7F41B6595A169D4--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'224' and e.recordID = @FinancialMgmtGLJournal.id@]]></HQLWHERECLAUSE>
-<!--1B49A74CF8314D02B7F41B6595A169D4-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--1B49A74CF8314D02B7F41B6595A169D4-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--1B49A74CF8314D02B7F41B6595A169D4-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--1B49A74CF8314D02B7F41B6595A169D4-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--1B49A74CF8314D02B7F41B6595A169D4-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -12239,7 +12239,7 @@
<!--21587C5E538E48758ED0C59B621DA91B-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--21587C5E538E48758ED0C59B621DA91B--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--21587C5E538E48758ED0C59B621DA91B--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'323' and e.recordID = @MaterialMgmtInternalMovement.id@]]></HQLWHERECLAUSE>
-<!--21587C5E538E48758ED0C59B621DA91B-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--21587C5E538E48758ED0C59B621DA91B-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--21587C5E538E48758ED0C59B621DA91B-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--21587C5E538E48758ED0C59B621DA91B-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--21587C5E538E48758ED0C59B621DA91B-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -12678,7 +12678,7 @@
<!--38A56E62067242B39D3815E434D5BC48-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--38A56E62067242B39D3815E434D5BC48--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--38A56E62067242B39D3815E434D5BC48--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'D1A97202E832470285C9B1EB026D54E2' and e.recordID =
@FIN_Payment.id@]]></HQLWHERECLAUSE>
-<!--38A56E62067242B39D3815E434D5BC48-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--38A56E62067242B39D3815E434D5BC48-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--38A56E62067242B39D3815E434D5BC48-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--38A56E62067242B39D3815E434D5BC48-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--38A56E62067242B39D3815E434D5BC48-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -13676,7 +13676,7 @@
<!--6EE02C9681A74406A129F1D96D022BA4-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--6EE02C9681A74406A129F1D96D022BA4--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--6EE02C9681A74406A129F1D96D022BA4--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'318' and e.recordID = @Invoice.id@]]></HQLWHERECLAUSE>
-<!--6EE02C9681A74406A129F1D96D022BA4-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--6EE02C9681A74406A129F1D96D022BA4-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--6EE02C9681A74406A129F1D96D022BA4-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--6EE02C9681A74406A129F1D96D022BA4-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--6EE02C9681A74406A129F1D96D022BA4-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -13766,7 +13766,7 @@
<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--7309F57E84264F6BB8F2A5E4A976ED93--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--7309F57E84264F6BB8F2A5E4A976ED93--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'D1A97202E832470285C9B1EB026D54E2' and e.recordID =
@FIN_Payment.id@]]></HQLWHERECLAUSE>
-<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--7309F57E84264F6BB8F2A5E4A976ED93-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -14209,7 +14209,7 @@
<!--89F074E609E841A7ACD0D4A19B6AF476-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--89F074E609E841A7ACD0D4A19B6AF476--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--89F074E609E841A7ACD0D4A19B6AF476--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'800060' and e.recordID = @FinancialMgmtAmortization.id@]]></HQLWHERECLAUSE>
-<!--89F074E609E841A7ACD0D4A19B6AF476-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--89F074E609E841A7ACD0D4A19B6AF476-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--89F074E609E841A7ACD0D4A19B6AF476-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--89F074E609E841A7ACD0D4A19B6AF476-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--89F074E609E841A7ACD0D4A19B6AF476-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -14357,7 +14357,7 @@
<!--93787F9E92BD433EA7FD0E61227BC126-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--93787F9E92BD433EA7FD0E61227BC126--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--93787F9E92BD433EA7FD0E61227BC126--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'321' and e.recordID = @MaterialMgmtInventoryCount.id@]]></HQLWHERECLAUSE>
-<!--93787F9E92BD433EA7FD0E61227BC126-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--93787F9E92BD433EA7FD0E61227BC126-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--93787F9E92BD433EA7FD0E61227BC126-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--93787F9E92BD433EA7FD0E61227BC126-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--93787F9E92BD433EA7FD0E61227BC126-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -14523,7 +14523,7 @@
<!--A399D7976DD74832A0D56586E46D149A-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--A399D7976DD74832A0D56586E46D149A--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--A399D7976DD74832A0D56586E46D149A--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'318' and e.recordID = @Invoice.id@]]></HQLWHERECLAUSE>
-<!--A399D7976DD74832A0D56586E46D149A-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--A399D7976DD74832A0D56586E46D149A-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--A399D7976DD74832A0D56586E46D149A-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--A399D7976DD74832A0D56586E46D149A-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--A399D7976DD74832A0D56586E46D149A-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -14997,7 +14997,7 @@
<!--B1A51802BAF64D34BC59B91EA36D5064-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--B1A51802BAF64D34BC59B91EA36D5064--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--B1A51802BAF64D34BC59B91EA36D5064--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'472' and e.recordID = @ProcurementReceiptInvoiceMatch.id@]]></HQLWHERECLAUSE>
-<!--B1A51802BAF64D34BC59B91EA36D5064-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--B1A51802BAF64D34BC59B91EA36D5064-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--B1A51802BAF64D34BC59B91EA36D5064-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--B1A51802BAF64D34BC59B91EA36D5064-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--B1A51802BAF64D34BC59B91EA36D5064-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -15085,7 +15085,7 @@
<!--B67386FF3EA94579BA9BA22353B5B897-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--B67386FF3EA94579BA9BA22353B5B897--> <UIPATTERN><![CDATA[ED]]></UIPATTERN>
<!--B67386FF3EA94579BA9BA22353B5B897--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'319' and e.recordID = @MaterialMgmtShipmentInOut.id@]]></HQLWHERECLAUSE>
-<!--B67386FF3EA94579BA9BA22353B5B897-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--B67386FF3EA94579BA9BA22353B5B897-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--B67386FF3EA94579BA9BA22353B5B897-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--B67386FF3EA94579BA9BA22353B5B897-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--B67386FF3EA94579BA9BA22353B5B897-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -15291,7 +15291,7 @@
<!--C68533256F40484C89006BF00F669CD5-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--C68533256F40484C89006BF00F669CD5--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--C68533256F40484C89006BF00F669CD5--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'319' and e.recordID = @MaterialMgmtShipmentInOut.id@]]></HQLWHERECLAUSE>
-<!--C68533256F40484C89006BF00F669CD5-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--C68533256F40484C89006BF00F669CD5-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--C68533256F40484C89006BF00F669CD5-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--C68533256F40484C89006BF00F669CD5-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--C68533256F40484C89006BF00F669CD5-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
@@ -15613,7 +15613,7 @@
<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--D7B93F8414E643DD8C1103D6FEF0B568--> <UIPATTERN><![CDATA[SR]]></UIPATTERN>
<!--D7B93F8414E643DD8C1103D6FEF0B568--> <HQLWHERECLAUSE><![CDATA[e.table.id =
'325' and e.recordID =
@MaterialMgmtProductionTransaction.id@]]></HQLWHERECLAUSE>
-<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, debit desc,
credit desc, value]]></HQLORDERBYCLAUSE>
+<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<HQLORDERBYCLAUSE><![CDATA[accountingSchema.name, accountingDate, abs(debit)
desc, credit desc, value]]></HQLORDERBYCLAUSE>
<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
<!--D7B93F8414E643DD8C1103D6FEF0B568-->
<EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
