details: https://code.openbravo.com/erp/devel/pi/rev/2462f2ed8dae
changeset: 14881:2462f2ed8dae
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Thu Dec 15 16:54:17 2011 +0100
summary: Fixes issue 19131: Fields that depends on other field.
The solution is simple, before take the values of fixmonthday fields, the field
isduefixed is revised if it is checked or not
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
| 24 ++++++---
1 files changed, 16 insertions(+), 8 deletions(-)
diffs (54 lines):
diff -r cca0a2e1bf1e -r 2462f2ed8dae
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Tue Dec 13 11:08:35 2011 +0100
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
Thu Dec 15 16:54:17 2011 +0100
@@ -238,8 +238,10 @@
FROM (
SELECT line, percentage, onremainder, excludetax,
COALESCE(paymentrule, v_paymentrule) AS paymentrule,
- fixmonthday, fixmonthday2, fixmonthday3, netdays,
- fixmonthoffset, netday, isnextbusinessday
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday END)
AS fixmonthday,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday2 END)
AS Fixmonthday2,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday3 END)
AS fixmonthday3,
+ netdays, fixmonthoffset, netday, isnextbusinessday
FROM c_paymenttermline
WHERE c_paymentterm_id=v_paymentterm
AND isactive = 'Y'
@@ -247,16 +249,20 @@
-- Header of paymentTerm is processed at last
SELECT 9999 AS line, 100 AS percentage, 'Y' AS onremainder, 'N' AS
excludetax,
v_paymentRule AS paymentrule,
- fixmonthday, fixmonthday2, fixmonthday3, netdays,
- fixmonthoffset, netday, isnextbusinessday
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday END)
AS fixmonthday,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday2 END)
AS Fixmonthday2,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday3 END)
AS fixmonthday3,
+ netdays, fixmonthoffset, netday, isnextbusinessday
FROM c_paymentterm
WHERE c_paymentterm_id=v_paymentterm) a;
FOR cur_payments IN (
SELECT line, percentage, onremainder, excludetax,
COALESCE(paymentrule, v_paymentrule) AS paymentrule,
- fixmonthday, fixmonthday2, fixmonthday3, netdays,
- fixmonthoffset, netday, isnextbusinessday
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday END)
AS fixmonthday,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday2 END)
AS Fixmonthday2,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday3 END)
AS fixmonthday3,
+ netdays, fixmonthoffset, netday, isnextbusinessday
FROM c_paymenttermline
WHERE c_paymentterm_id=v_paymentterm
AND isactive = 'Y'
@@ -264,8 +270,10 @@
-- Header of paymentTerm is processed at last
SELECT 9999 AS line, 100 AS percentage, 'Y' AS onremainder, 'N' AS
excludetax,
v_paymentRule AS paymentrule,
- fixmonthday, fixmonthday2, fixmonthday3, netdays,
- fixmonthoffset, netday, isnextbusinessday
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday END)
AS fixmonthday,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday2 END)
AS Fixmonthday2,
+ (CASE isduefixed WHEN 'N' THEN null ELSE fixmonthday3 END)
AS fixmonthday3,
+ netdays, fixmonthoffset, netday, isnextbusinessday
FROM c_paymentterm
WHERE c_paymentterm_id=v_paymentterm
ORDER BY line
------------------------------------------------------------------------------
10 Tips for Better Server Consolidation
Server virtualization is being driven by many needs.
But none more important than the need to reduce IT complexity
while improving strategic productivity. Learn More!
http://www.accelacomm.com/jaw/sdnl/114/51507609/
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
