details: /erp/devel/pi/rev/d60f21a50638
changeset: 8564:d60f21a50638
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Tue Oct 19 09:24:18 2010 +0200
summary: Fixes issue 14908
Now C_Invoice_Post takes dynamically the doc base type elements that works with
the invoice documents
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 7 ++++++-
1 files changed, 6 insertions(+), 1 deletions(-)
diffs (17 lines):
diff -r 632808419bb4 -r d60f21a50638
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Tue Oct 19
17:13:17 2010 +0530
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Tue Oct 19
09:24:18 2010 +0200
@@ -422,7 +422,12 @@
SELECT COUNT(*) INTO v_Count
FROM C_INVOICE C,
C_DOCTYPE
- WHERE C_DOCTYPE.DocBaseType IN ('ARI', 'API','ARC','APC')
+ WHERE C_DOCTYPE.DocBaseType IN (
+ select docbasetype
+ from c_doctype
+ where ad_table_id='318'
+ and isactive='Y'
+ and ad_client_id=C.AD_Client_ID)
AND C_DOCTYPE.IsSOTrx=C.ISSOTRX
AND Ad_Isorgincluded(C.AD_Org_ID,C_DOCTYPE.AD_Org_ID, C.AD_Client_ID)
<> -1
AND C.C_DOCTYPETARGET_ID = C_DOCTYPE.C_DOCTYPE_ID
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
