3 Replies Latest reply: May 15, 2014 9:57 AM by Grant Perkins RSS

    Footer Templates

    LB _

      I have a report file below which I am having difficulties with setting up the templates on. Beside the Detail template, I believe Footer templates are what I need to capture all of the other variable data pieces with.  However, I believe I may need some direction as to how best to set up my footer templates so to pull in the correct pieces with the correct customer. 

       

      Could you please help!!

       

      INST  : xxx                                                                                                PAGE:          1

      REPORT: LAS/xxxx-030 19.05.1                                          LOAN ACCOUNTING SYSTEM                                                  RUN DATE: 06/xx/2xxx

      SYSTEM: 06/xx/20xx  21:00                                                      PAST DUE NOTES                                                     PROCESSED THRU: 06/xx/2xxx

                                                                                      - - -  P A S T   D U E  - - -

               NOTE NUM    BR - - - - - - - - - NAME - - - - - - - - -                                 CL MPI   RSP      S/U PYMTS MADE     BALANCE      AMOUNT    DATE     PYMTS  DAYS

       

            xxxxxx5003    20 CROBERT x XXX XXX XXXXX                  01 1M    TCS      U    60     4               .00 N          3,072.08  08/05/99*    56  2867

                                                                    LST PYMT: 05/29/07                                                   PAYOFF:       3,072.08

                              COLLATERAL:  UNSECURED                                          LINE:           343.59

       

             xxxxxxx002    18 NANCY x XXXXXXXXX                             01 1M    TCS      S    30     5               .00 N          1,138.67  10/25/99*    25  2786

                                                                    LST PYMT: 05/29/07                                                   PAYOFF:       1,138.67

                              H:XXX-XXX-0526

                              COLLATERAL:  UNSECURED                                          LINE:              .00

       

             xxxxxxx001    01 JANELLE XXXXXXX                                    01 1M    TCS      S    50     4               .00 N          3,041.22  03/29/01*    46  2265

                                                                    LST PYMT: 05/29/07                                                   PAYOFF:       3,041.22

                              H:XXX-XXX-XXXX                                                                        STATUS: BANKRUPTCY

                              COLLATERAL:  98 FORD WINDSTAR #xxxx                 LINE:              .00

       

               xxxxx269    01 ANGELA x XXXXX                                         26 1M    UCA      U    12     2               .00 N            503.28  04/08/01*    10  2255

                                                                    LST PYMT: 09/27/06                                                   PAYOFF:         503.28

                                                                                      STATUS: BANKRUPTCY

                              COLLATERAL:  UNSECURED                                          LINE:         6,109.85

       

            xxxxxxx016    17 JARED x XXXXXXXXXX                               01 1X    TCS      U     1     0               .00N            166.61  01/17/02     1  1971

                                                                    LST PYMT: 01/17/06                                                   PAYOFF:         166.61

                                             B:XXX-XXX-4125

                              COLLATERAL:  UNSECURED                                          LINE:        52,156.75

       

                xxxxx23     01 MICHAEL XXXXXXXXX                               26 1M    TCS      U    12     0               .00 N             11.36  01/20/02*    12  1968

                                                                    LST PYMT: 05/29/07                                                   PAYOFF:          11.36

                              H:XXX-XXX-7361 B:XXX-XXX-3422

                              COLLATERAL:  UNSECURED                                          LINE:              .00

       

             xxxxxxx4     17 WILLIAM XXXXXX                                      01 1X    TCS      U     1     0               .00N            271.62  03/14/02     1  1915

                                                                    LST PYMT: 07/26/06                                                   PAYOFF:         271.62

                              H:XXX-XXX-XXXX

                              COLLATERAL:  UNSECURED                                          LINE:              .00

       

             xxxxx585     17 SHANTEL x XXXXXXX                                  01 1X    TCS      U     1     0               .00N            408.31  03/14/02     1  1915

                                                                    LST PYMT: 12/27/06                                                   PAYOFF:         408.31

                              COLLATERAL:  UNSECURED                                          LINE:              .00

       

             xxxxxxx4    18 JACQUELYN x XXXXXXXX                          01 1X    UCA      U     1     0               .00N             68.79  06/25/02     1  1812

                                                                    LST PYMT: 03/14/07                                                   PAYOFF:          68.79

                              H:xxx-XXX-XXXX B:xxx-XXX-XXXX                                                         STATUS: BANKRUPTCY

                              COLLATERAL:  UNSECURED                                          LINE:        11,743.97

       

                xxxxx4    01 JIM XXXXXXXXX                                              01 1M    IHC      S    41     2               .00 N            795.26  07/31/02*   39  1776

                                                                    LST PYMT: 05/29/07                                                   PAYOFF:         795.26

                              H:XXX-XXX-9863

                              COLLATERAL:  91 DODGExxxx  #xxxx/85 BUICK E   LINE:              .00

                                           LEC #xxxx

       

              xxxxxx9    06 REBECCA x XXXXXXX                                   01 1X     IHC      U     1     0                .00N            217.34  03/20/03    1  1544

                                                                    LST PYMT: 04/19/07                                                   PAYOFF:         217.34

                              COLLATERAL:  UNSECURED                                          LINE:         6,095.81

       

              xxxxxx4    35 MICHELLE XXXXXXXXXX                           39 1M    VET     U    60     5          34,043.68       34,238.00  05/01/03    50  1502

                              S/P: D 555555               LST PYMT: 04/18/03                                                  L/C BAL:  1,015.00             SCHED:         684.76

                              H:XXX-XXX-7575                                                   NET:              .00

                              COLLATERAL:  UNSECURED                                          LINE:        48,065.16

                                                                                      NET LINE:              .00

        • Footer Templates
          Grant Perkins

          LB, welcome to the forum.

           

          Can you confirm that format of the actual report looks something very much like this?

           

          Grant

           

          Originally posted by LB:

          [font="courier"]INST  : xxx                                                                                                PAGE:          1

          REPORT: LAS/xxxx-030 19.05.1                                          LOAN ACCOUNTING SYSTEM                                                  RUN DATE: 06/xx/2xxx

          SYSTEM: 06/xx/20xx  21:00                                                      PAST DUE NOTES                                                     PROCESSED THRU: 06/xx/2xxx

                                                                                          - - -  P A S T   D U E  - - -

                   NOTE NUM    BR - - - - - - - - - NAME - - - - - - - - -                                 CL MPI   RSP      S/U PYMTS MADE     BALANCE      AMOUNT    DATE     PYMTS  DAYS

           

                xxxxxx5003    20 CROBERT x XXX XXX XXXXX                  01 1M    TCS      U    60     4               .00 N          3,072.08  08/05/99*    56  2867

                                                                        LST PYMT: 05/29/07                                                   PAYOFF:       3,072.08

                                  COLLATERAL:  UNSECURED                                          LINE:           343.59

           

                 xxxxxxx002    18 NANCY x XXXXXXXXX                             01 1M    TCS      S    30     5               .00 N          1,138.67  10/25/99*    25  2786

                                                                        LST PYMT: 05/29/07                                                   PAYOFF:       1,138.67

                                  H:XXX-XXX-0526

                                  COLLATERAL:  UNSECURED                                          LINE:              .00

           

                 xxxxxxx001    01 JANELLE XXXXXXX                                    01 1M    TCS      S    50     4               .00 N          3,041.22  03/29/01*    46  2265

                                                                        LST PYMT: 05/29/07                                                   PAYOFF:       3,041.22

                                  H:XXX-XXX-XXXX                                                                        STATUS: BANKRUPTCY

                                  COLLATERAL:  98 FORD WINDSTAR #xxxx                 LINE:              .00

           

                   xxxxx269    01 ANGELA x XXXXX                                         26 1M    UCA      U    12     2               .00 N            503.28  04/08/01*    10  2255

                                                                        LST PYMT: 09/27/06                                                   PAYOFF:         503.28

                                                                                          STATUS: BANKRUPTCY

                                  COLLATERAL:  UNSECURED                                          LINE:         6,109.85

           

                xxxxxxx016    17 JARED x XXXXXXXXXX                               01 1X    TCS      U     1     0               .00N            166.61  01/17/02     1  1971

                                                                        LST PYMT: 01/17/06                                                   PAYOFF:         166.61

                                                 B:XXX-XXX-4125

                                  COLLATERAL:  UNSECURED                                          LINE:        52,156.75

           

                    xxxxx23     01 MICHAEL XXXXXXXXX                               26 1M    TCS      U    12     0               .00 N             11.36  01/20/02*    12  1968

                                                                        LST PYMT: 05/29/07                                                   PAYOFF:          11.36

                                  H:XXX-XXX-7361 B:XXX-XXX-3422

                                  COLLATERAL:  UNSECURED                                          LINE:              .00

           

                 xxxxxxx4     17 WILLIAM XXXXXX                                      01 1X    TCS      U     1     0               .00N            271.62  03/14/02     1  1915

                                                                        LST PYMT: 07/26/06                                                   PAYOFF:         271.62

                                  H:XXX-XXX-XXXX

                                  COLLATERAL:  UNSECURED                                          LINE:              .00

           

                 xxxxx585     17 SHANTEL x XXXXXXX                                  01 1X    TCS      U     1     0               .00N            408.31  03/14/02     1  1915

                                                                        LST PYMT: 12/27/06                                                   PAYOFF:         408.31

                                  COLLATERAL:  UNSECURED                                          LINE:              .00

           

                 xxxxxxx4    18 JACQUELYN x XXXXXXXX                          01 1X    UCA      U     1     0               .00N             68.79  06/25/02     1  1812

                                                                        LST PYMT: 03/14/07                                                   PAYOFF:          68.79

                                  H:xxx-XXX-XXXX B:xxx-XXX-XXXX                                                         STATUS: BANKRUPTCY

                                  COLLATERAL:  UNSECURED                                          LINE:        11,743.97

           

                    xxxxx4    01 JIM XXXXXXXXX                                              01 1M    IHC      S    41     2               .00 N            795.26  07/31/02*   39  1776

                                                                        LST PYMT: 05/29/07                                                   PAYOFF:         795.26

                                  H:XXX-XXX-9863

                                  COLLATERAL:  91 DODGExxxx  #xxxx/85 BUICK E   LINE:              .00

                                               LEC #xxxx

           

                  xxxxxx9    06 REBECCA x XXXXXXX                                   01 1X     IHC      U     1     0                .00N            217.34  03/20/03    1  1544

                                                                        LST PYMT: 04/19/07                                                   PAYOFF:         217.34

                                  COLLATERAL:  UNSECURED                                          LINE:         6,095.81

           

                  xxxxxx4    35 MICHELLE XXXXXXXXXX                           39 1M    VET     U    60     5          34,043.68       34,238.00  05/01/03    50  1502

                                  S/P: D 555555               LST PYMT: 04/18/03                                                  L/C BAL:  1,015.00             SCHED:         684.76

                                  H:XXX-XXX-7575                                                   NET:              .00

                                  COLLATERAL:  UNSECURED                                          LINE:        48,065.16

                                                                                          NET LINE:              .00 /font[/quote][/b][/quote]

          • Footer Templates
            LB _

            The format is very similar to my original report example, however the spacig of the detail under some of the column headings is off.

            • Footer Templates
              Grant Perkins

              Originally posted by LB:

              The format is very similar to my original  report example, however the spacig of the detail under some of the column headings is off. /b[/quote]OK.

               

              The 'coded' output is just what you originally posted but with the 'code' tags around it which, most of the time but not always, re-presents the posted text as it was originally. There can be glitches!

               

              If I assume that the horizontal positioning of fields should be consistent but happens not to be here that will be fine for our purpose. (Unless some of the assumed 'shift' you warned about obscures something about the line - for example that one part of it may be used for different data depending upon the status of the record contents. In which case we have some potentially interesting processing to work out.

               

              Slightly more problematic is that the report seems to have different number of lines per record (if I am reading it correctly).

               

              Each record appear to have at least 3 lines. Line 1 and 2 always appear and the third line (is this the one you envisage as the footer?) may drop to the 4th line. In fact it mostly drops to the 4th line with somtimes an extension to the 5th line.

               

              The third line, when it exists, seems to be highly variable in content which could make it difficult to trap using normal techniques. Is it this line that you see as the main problem or are there other factors which I have yet to notice?

               

              Currently I think the first 2 lines seem to be your detail and the 'Collateral' line the basis for you footer.

               

              There may also be an option to make the 'Collateral' line part of the detail template using the advanced field propoerty 'Start field after ...' a preceding string of, for example "collateral". We could expect this to pick out the data from the line with collateral on it on a line anywhere between the first line of its record and the beginning of the next record.

               

              For the variable 'third' line it looks like it may be possible to use a similar method to that suggested above but utilising an APPEND template which shares the same trap as the detail template. If the fields reported on that third line can be very variable and, possibly, overlap fields from other versions of the line you may need to have more than one append template in odrder to be sure to extract everything.

               

              All this may sound complicated but it is in fact easier to do than to describe. How familiar are you with the less commonly used features that Monarch offers? The sort of things I have referred to above? If the answer is 'I use them regularly' you will probably already be thinking ahead on applying them for this need. But if you have no idea what I am referring to it may be easier for me to do a little patching to your posted sample and create a model that works with it then send both to you so you can see what is does and adapt the techniques to your actual report.

               

              Even better would be if you can send me the small anonymised file you posted ( I assume the fields are in the correct positions before posting?) and the model you have so far and I will work from those, plus the information about what you are still missing from the report, to provide something that illustrates a way forward.

               

              If you contact me though the forum using a Private Message and provide you email address I will send you my email contact address for you to send the files.

               

              Will this help you?

               

               

              Grant