-SET &ECHO=ALL; DYNAM ALLOC FILE DTFILE DA D.WIP.WHS.DATE.FILE SHR REUSE -RUN -READ DTFILE &CYY.A4. &CMM.A2. &CDD.A2. &FIL.A8. &CFY.A4. &DFY.A4. -SET &CURDT = &CMM | '/' | &CDD | '/' | &CYY; -IF &demand = 'M' THEN GOTO MONTHLY; -** YEARLY -SET &LFY = ASIS(&CFY) - 1; -SET &BDT = &LFY | '-07-01'; -SET &EDT = &CFY | '-06-30'; -GOTO HEADSET -MONTHLY -SET &LMM = IF ASIS(&CMM) - 1 EQ 0 THEN '12' ELSE - IF ASIS(&CMM) - 1 EQ 11 THEN '11' ELSE - IF ASIS(&CMM) - 1 EQ 10 THEN '10' ELSE - IF ASIS(&CMM) - 1 EQ 10 THEN '10' ELSE - IF ASIS(&CMM) - 1 EQ 9 THEN '09' ELSE - IF ASIS(&CMM) - 1 EQ 8 THEN '08' ELSE - IF ASIS(&CMM) - 1 EQ 7 THEN '07' ELSE - IF ASIS(&CMM) - 1 EQ 6 THEN '06' ELSE - IF ASIS(&CMM) - 1 EQ 5 THEN '05' ELSE - IF ASIS(&CMM) - 1 EQ 4 THEN '04' ELSE - IF ASIS(&CMM) - 1 EQ 3 THEN '03' ELSE - IF ASIS(&CMM) - 1 EQ 2 THEN '02' ELSE - IF ASIS(&CMM) - 1 EQ 1 THEN '01' ELSE ' '; -SET &LYY = IF &CMM EQ '12' THEN ASIS(&CYY) - 1 ELSE &CYY; -SET &BDT = &LYY || '-' | &LMM || '-01'; -SET &LDD = - DECODE '&LMM'('01' '31', '02' '28', '03' '31', '04' '30', '05' '31', - '06' '30', '07' '31', '08' '31', '09' '30', '10' '31', - '11' '30', '12' '31'); -SET &LDD = IF &LMM EQ '02' AND (&LYY EQ '2012' OR &LYY EQ '2016' OR - &LYY EQ '2020' OR &LYY EQ '2024') THEN '29' ELSE &LDD; -SET &EDT = &LYY || '-' | &LMM || '-' | &LDD; -HEADSET -SET &HEAD1 = 'Pre-Audit Invoice Summary'; -SET &HEAD2 = &BDT |' to '| &EDT; -SET &FLAIR = 'Y'; -SET &MFMP = 'Y'; -SET &PCARD = 'Y'; -SET &PREAUD = 'Y'; -SET &WHERE1 = 'WHERE POSTING_DT GE '|''''|&BDT||''''|' AND ' - |'POSTING_DT LE '|''''|&EDT||''''|';'; -SET &FLGT = 'Y'; -SET &FLLT = 'Y'; -SET &MFGT = 'Y'; -SET &MFLT = 'Y'; -**
FOCUS 7.3.4 09.26.52 05/16/2012 PREADSUM LINE 9 6395.07 DYNAM ALLOC FILE DTFILE DA D.WIP.WHS.DATE.FILE SHR REUSE -READ DTFILE &CYY.A4. &CMM.A2. &CDD.A2. &FIL.A8. &CFY.A4. &DFY.A4. -SET &CURDT = 05 | '/' | 15 | '/' | 2012; -IF M = 'M' THEN GOTO MONTHLY; -MONTHLY -SET &LMM = IF ASIS(05) - 1 EQ 0 THEN '12' ELSE - IF ASIS(05) - 1 EQ 11 THEN '11' ELSE - IF ASIS(05) - 1 EQ 10 THEN '10' ELSE - IF ASIS(05) - 1 EQ 10 THEN '10' ELSE - IF ASIS(05) - 1 EQ 9 THEN '09' ELSE - IF ASIS(05) - 1 EQ 8 THEN '08' ELSE - IF ASIS(05) - 1 EQ 7 THEN '07' ELSE - IF ASIS(05) - 1 EQ 6 THEN '06' ELSE - IF ASIS(05) - 1 EQ 5 THEN '05' ELSE - IF ASIS(05) - 1 EQ 4 THEN '04' ELSE - IF ASIS(05) - 1 EQ 3 THEN '03' ELSE - IF ASIS(05) - 1 EQ 2 THEN '02' ELSE - IF ASIS(05) - 1 EQ 1 THEN '01' ELSE ' '; -SET &LYY = IF 05 EQ '12' THEN ASIS(2012) - 1 ELSE 2012; -SET &BDT = 2012 || '-' | 04 || '-01'; -SET &LDD = - DECODE '04'('01' '31', '02' '28', '03' '31', '04' '30', '05' '31', - '06' '30', '07' '31', '08' '31', '09' '30', '10' '31', - '11' '30', '12' '31'); (FOC283) IMPROPER USE OF 'GOTO'
quote:-IF &demand = 'M' THEN GOTO MONTHLY;
-IF &demand EQ 'M' THEN GOTO MONTHLY;
-IF &demand = 'M' THEN GOTO MONTHLY; to -IF '&demand.EVAL' EQ 'M' GOTO MONTHLY;
-SET &LDD = - DECODE '&LMM.EVAL'('01' '31', '02' '28', '03' '31', '04' '30', '05' '31', - '06' '30', '07' '31', '08' '31', '09' '30', '10' '31', - '11' '30', '12' '31' ELSE 'XX');
-SET &LEAP_YR1 = (&FY / 4) * 100; -SET &LEAP_YR2 = EDIT(&LEAP_YR1,'$$$99'); -SET &LEAP_YR3 = IF &LEAP_YR2 EQ '00' THEN 'February 29 ' ELSE 'February 28 '; -SET &X_MONTH = DECODE &FP ( - 01 'July 31 ' - 02 'August 31 ' - 03 'September 30 ' - 04 'October 31 ' - 05 'November 30 ' - 06 'December 31 ' - 07 'January 31 ' - 08 '&LEAP_YR3.EVAL' - 09 'March 31 ' - 10 'April 30 ' - 11 'May 31 ' - 12 'June 30 ' - 13 'June 30 ' - 14 'June 30 ' - ELSE ' ');This message has been edited. Last edited by: Tom Flynn,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |