Create Automatic Email for Late EDI Acknowledgments

EXTOL RPGLE 997 reporting program - Create automatic email for Late EDI Acknowledgments for Invoices

     FEXLLMUSC  IF   E           K DISK
     FQPRINT    O    F  198        PRINTER OFLIND(*INOF) FORMLEN(66) FORMOFL(64)
     F                                     USROPN
      *-------------------------------------------------------------------------
     D USADAT          S               D   DATFMT(*USA) INZ(*SYS)
     D ACKED           S              5  0
     D COUNT           S              5  0
     D SENTTM          S              4  0
      *-------------------------------------------------------------------------
      * get 1st records for yesterdays date & save values
     C     YESTERDAY     CHAIN     @LLMUSC                            10
     C                   EXSR      @NEWTPC

     C                   DOW       *IN10 = *OFF

     C                   IF        LMGPC1 = 'IN'

     C                   IF        LITPCD <> TPCSAV AND COUNT > 0
      * send email for previous trading partner
     C                   EXSR      @SENDEMAIL
     C                   EXSR      @NEWTPC
     C                   ENDIF

      * print acknowledgement details
     C     LMASTM        COMP      'A'                                    11
     C     LMASTM        COMP      'E'                                    12
     C     LMASTM        COMP      'P'                                    13
     C     *YMD0         MOVE      LIINDT        USADAT
     C                   MOVE      LIINTM        SENTTM
     C                   EXCEPT    #INVOICES
     C                   ENDIF

      * accumulate counts
     C                   IF        *IN11 OR *IN12
     C                   ADD       1             ACKED
     C                   ENDIF
      *
     C                   ADD       1             COUNT
     C                   ENDIF
      *
     C     YESTERDAY     READE     @LLMUSC                                10
     C                   ENDDO

      * send email if last trading partner not sent
     C     COUNT         CASGT     0             @SENDEMAIL
     C                   ENDCS

     C                   MOVE      *ON           *INLR
     C                   RETURN
      *-------------------------------------------------------------------------
     C     @NEWTPC       BEGSR
      *-------------------------------------------------------------------------
      * open splf, print heading & save values
     C                   OPEN      QPRINT
     C                   EXCEPT    #HEADER
     C                   MOVE      LITPCD        TPCSAV            6
     C                   MOVE      LMMSCL        MSCSAV           10

     C                   ENDSR
      *-------------------------------------------------------------------------
     C     @SENDEMAIL    BEGSR
      *-------------------------------------------------------------------------
      * print previous trading partner total, close & send splf via Keyesmail
     C                   EXCEPT    #TOTAL
     C                   CLOSE     QPRINT

     C                   EVAL      CMD = 'CHGSPLFA FILE(QPRINT) +
     C                             SPLNBR(*LAST) OUTQ(QUSRSYS/KMLOUTQ) +
     C                             USRDFNDTA(''¬Email KMLEDI/' + %TRIM(MSCSAV)+
     C                             ' ¬From [email protected] ¬Subj EDI 997 ACKNOWL+
     C                             EDGEMENT STATUS REPORT  ¬Temp *HTML'')'
     C                   CALL      'QCMDEXC'     KML                    13

     C                   Z-ADD     0             COUNT
     C                   Z-ADD     0             ACKED

     C                   ENDSR
      *-------------------------------------------------------------------------
     C     *INZSR        BEGSR
      *-------------------------------------------------------------------------
     C     KML           PLIST
     C                   PARM                    CMD             256
     C                   PARM      256           LEN              15 5

     C                   SUBDUR    1:*DAYS       USADAT
     C     *YMD0         MOVE      USADAT        YESTERDAY         6

     C                   ENDSR
      *-------------------------------------------------------------------------
     OQPRINT    E            #HEADER           1
     O                                              '<font face="Verdana">'
     O          E    20      #HEADER     1
     O                       USADAT
     O                                           +1 'invoices for'
     O                                              '<font size="+2"><b>'
     O                       TPTRNM              +1
     O                                              '</font></b><ol>'
     O          E    30      #HEADER     1
     O                       USADAT
     O                                           +1 'ship notices for'
     O                                              '<font size="+2"><b>'
     O                       TPTRNM              +1
     O                                              '</font></b><ol>'
      *---------
     O          E            #INVOICES   1
     O               12                             '<font color="blue">'
     O               13                             '<font color="red">'
     O                                              '<li type="square">'
     O                       LMREF2
     O               12                             'Acknowledged in error'
     O               13                             'NOT acknowledged since'
     O               13      SENTTM                 '  :  '
     O                                              '</li></font>'
     O          E            #NOTICES    1
     O               12                             '<font color="blue">'
     O               13                             '<font color="red">'
     O                                              '<li type="square">'
     O                       LMREF1
     O               12                             'Acknowledged in error'
     O               13                             'NOT acknowledged since'
     O               13      SENTTM              +1 '  :  '
     O                                              '</li></font>'
      *---------
     O          E            #TOTAL      2
     O                                              '</ol><u>'
     O                       COUNT         3
     O                                              '</u> Sent, <u>'
     O                       ACKED         3     +3
     O                                              '</u> Acknowledged'
     O          E            #TOTAL      3
     O                                              '*** END OF REPORT ***'
     O                                              '</font>'



By: on