3 Replies Latest reply: May 15, 2014 10:12 AM by Olly Bond RSS

    Guru Trap Help

    mlally _

      I am fairly new to Monarch. I read the different forum entries on using a guru trap. I was able to trap the first Suspense Reserve amount of 2300.00 for loan 0596897122 using this type of trap. My problem is I also need to capture the second amount of 807.67 for this loan. Everything I know to try hasn't worked. I am using Monarch Pro is 10.5.

       

      SR410UR-02                                            ########## Mortgage LLC                                      12/16/11  1:12:080260000001102   

      MISOPS                                                     TRIAL BALANCE                         AS OF 12/15/11     JOB DT: 12/16/110260000001A01   

      SERVICER 222222222                                                                                PAGE:      10260000001A02   

      INVESTOR 026       HUDSON SAVINGS BANK             POOL 0000001 MIXED    INTEREST RATE MIXED    SRV FEE RATE MIXED     STATE VARIOUS0260000001A02   

        INVESTOR   SERVICER   INT    S/F  PRINCIPAL     ESCROW      ESCROW  NXT DUE      P&I      TOT PMT    SUSPENSE          ACCRUED  LN0260000001A01   

        LOAN NBR   LOAN NBR  RATE   RATE    BALANCE    BALANCE     ADVANCE IF DEL/PP  CONSTANT     AMOUNT     RESERVE TYP     INTEREST  TP0260000001A02   

      200054     0596897051 07250  .5000   78326.00    5019.04         .00 B            709.46    1930.32                       236.61  010260000001A01   

      200087     0596897054 06500  .5000  156087.76    1550.05         .00 B 120111    1399.86    2307.20                      1266.72  010260000001A00                                                                               

      2162.66 25                 0260000001A01   

      200106     0596897055 06750  .5000  107576.28    4103.55         .00 B            955.00    1983.71                       302.56  010260000001A01   

      200114     0596897056 07500  .5000   83936.44        .00     8342.42 B 040110     736.75    1225.92                     10974.33  010260000001A01   

      200032     0596897114 07500  .5000   91580.63    2192.67         .00 B            861.79    1711.27                       286.19  010260000001A01   

      200041     0596897116 07500  .5000   86127.41        .00    43308.06 B 120105     671.95    1068.77                     36967.48  010260000001A00                                                                               

      3342.33 23                 0260000001A01   

      200135     0596897118 07500  .8750   43929.27     328.25         .00 B 120111     398.91    1026.53                       411.45  010260000001A01   

      200058     0596897119 07500  .5000  124700.42    2696.38         .00 B 120111    1389.69    2468.22                      1167.16  010260000001A01   

      200170     0596897122 07000  .5000  144267.24        .00    29139.49 B 080109    1150.65    2045.11                     24025.63  010260000001A00                                                                               

      2300.00 25                 0260000001A01                                                                               

      807.67 24                 0260000001A01   

      200174     0596897123 07500 1.0000   43669.92     208.03         .00 B 120111     387.72     790.50                       409.05  010260000001A01   

      200204     0596897124 07000  .5000  176023.07        .00    11110.00 B 070110    1448.70    2572.80                     18584.01  010260000001A00                                                                               

      89.96 24                 0260000001A01   

      200717     0596897125 07500 1.0000   23906.44     599.27         .00 B            495.85     851.89                        74.71  010260000001A01   

      200255     0596897127 07375 1.1250   40702.85    2694.09         .00 B            350.87    1018.80                       125.08  010260000001A01   

      200243     0596897128 07000  .6250   75236.80    1925.41         .00 B            633.37    1026.78                       219.44  010260000001A01   

      200458     0596897130 07250 1.0000  152866.63    3438.16         .00 B           1481.35    2603.65                       461.78  010260000001A01   

      200737     0596897131 06750  .5000   90246.58        .00    10091.53 B 070110     705.03    1388.59                      9205.72  010260000001A01   

      200739     0596897132 06750  .5000  120821.70        .00     1323.53 B 080111     970.63    1691.54                      3717.32  010260000001A00                                                                               

      1300.46 24                 0260000001A01   

      200860     0596897133 07000  .5000   62650.92    6350.16         .00 B            895.17    1883.98                       182.73  010260000001A01   

      200736     0596897134 07250 1.0000  107222.23    2791.02         .00 B            903.55    1639.90                       323.90  010260000001A01   

      200891     0596897137 07250 1.0000   54342.00     788.85         .00 B            555.30    1018.56                       164.16  010260000001A01   

      201028     0596897151 07250  .7500  122247.96    2669.03         .00 B           1014.74    1985.46                       369.29  010260000001A01   

      201268     0596897153 08000 1.0000  107002.05    1293.49         .00 B 120111    1027.64    1605.47                      1068.98  010260000001A01   

      201321     0596897154 07875  .7500  145632.66        .00     4986.43 B 120110    1219.93    2038.27                     12751.86  010260000001A01   

      201442     0596897155 08000  .6250  149707.54        .00    29009.31 B 100108    1211.45    1892.41                     38245.11  010260000001A01   

      201601     0596897156 07875  .5000   89157.88    1603.68         .00 B 120111     754.08    1500.17                       877.09  010260000001A01   

      202417     0596897606 07000  .5000  108015.10     979.16         .00 B            851.53    1279.53                       315.04  010260000001A01                                                                               

      0260000001A02                                                                               

      4462.66 25                 0260000001A01                                                                               

      3342.33 23                 0260000001A01                                                                               

      2198.09 24                 0260000001A01   

      POOL 0000001 TOTAL LOANS   26      2585983.78   41230.29   137310.77 CURRENT    23180.97   42555.35     10003.08       162733.40    0260000001A01   

                                                      24494.69  .500 S/F RATE                                                             0260000001C21   

                                                           .00  .375 S/F RATE                                                             0260000001A01   

                                                      16735.60  OTHER S/F RATE                                                            0260000001A01                                                                               

      0260000001XXX   

      /code

       

      The following are the results I'm expecting:

      Job Date     Investor     Investor Loan     Servicer Loan     Interest Rate     Service Fee Rate     PI Constant     Total Payment     Actual UPB     Next Due Date     Escrow     Susp1 Amount     Susp1 Type     Susp2 Amount     Susp2 Type

      12/16/2011     026     200054     596897051     7.2500     0.5000     709.46     1,930.32     78,326.00          5,019.04                    

      12/16/2011     026     200087     596897054     6.5000     0.5000     1,399.86     2,307.20     156,087.76     12/1/2011     1,550.05     2,162.66     25          

      12/16/2011     026     200106     596897055     6.7500     0.5000     955.00     1,983.71     107,576.28          4,103.55                    

      12/16/2011     026     200114     596897056     7.5000     0.5000     736.75     1,225.92     83,936.44     4/1/2010     0.00                    

      12/16/2011     026     200032     596897114     7.5000     0.5000     861.79     1,711.27     91,580.63          2,192.67                    

      12/16/2011     026     200041     596897116     7.5000     0.5000     671.95     1,068.77     86,127.41     12/1/2005     0.00     3,342.33     23          

      12/16/2011     026     200135     596897118     7.5000     0.8750     398.91     1,026.53     43,929.27     12/1/2011     328.25                    

      12/16/2011     026     200058     596897119     7.5000     0.5000     1,389.69     2,468.22     124,700.42     12/1/2011     2,696.38                    

      12/16/2011     026     200170     596897122     7.0000     0.5000     1,150.65     2,045.11     144,267.24     8/1/2009     0.00     2,300.00     25     807.67     24

      12/16/2011     026     200174     596897123     7.5000     1.0000     387.72     790.50     43,669.92     12/1/2011     208.03                    

      12/16/2011     026     200204     596897124     7.0000     0.5000     1,448.70     2,572.80     176,023.07     7/1/2010     0.00     89.96     24          

      12/16/2011     026     200717     596897125     7.5000     1.0000     495.85     851.89     23,906.44          599.27                    

      12/16/2011     026     200255     596897127     7.3750     1.1250     350.87     1,018.80     40,702.85          2,694.09                    

      12/16/2011     026     200243     596897128     7.0000     0.6250     633.37     1,026.78     75,236.80          1,925.41                    

      12/16/2011     026     200458     596897130     7.2500     1.0000     1,481.35     2,603.65     152,866.63          3,438.16                    

      12/16/2011     026     200737     596897131     6.7500     0.5000     705.03     1,388.59     90,246.58     7/1/2010     0.00                    

      12/16/2011     026     200739     596897132     6.7500     0.5000     970.63     1,691.54     120,821.70     8/1/2011     0.00     1,300.46     24          

      12/16/2011     026     200860     596897133     7.0000     0.5000     895.17     1,883.98     62,650.92          6,350.16                    

      12/16/2011     026     200736     596897134     7.2500     1.0000     903.55     1,639.90     107,222.23          2,791.02                    

      12/16/2011     026     200891     596897137     7.2500     1.0000     555.30     1,018.56     54,342.00          788.85                    

      12/16/2011     026     201028     596897151     7.2500     0.7500     1,014.74     1,985.46     122,247.96          2,669.03                    

      12/16/2011     026     201268     596897153     8.0000     1.0000     1,027.64     1,605.47     107,002.05     12/1/2011     1,293.49                    

      12/16/2011     026     201321     596897154     7.8750     0.7500     1,219.93     2,038.27     145,632.66     12/1/2010     0.00                    

      12/16/2011     026     201442     596897155     8.0000     0.6250     1,211.45     1,892.41     149,707.54     10/1/2008     0.00                    

      12/16/2011     026     201601     596897156     7.8750     0.5000     754.08     1,500.17     89,157.88     12/1/2011     1,603.68                    

      12/16/2011     026     202417     596897606     7.0000     0.5000     851.53     1,279.53     108,015.10          979.16                    

      /code

       

      Any help would be greatly appreciated.

        • Guru Trap Help
          Olly Bond

          Hello MLally, and welcome,

           

          You don't need the guru trap in this example.

           

          Define a footer template that traps the line under the data, before the subtotals, so the middle line of these three:

           

          202417     0596897606 07000  .5000  108015.10     979.16         .00 B            851.53    1279.53                       315.04  010260000001A01                                                                               

          0260000001A02                                                                               

          4462.66 25                 0260000001A01    /CODE

           

          Use a trap with BBBBBB in the left hand six columns, and BBBBBB where the SUSP amounts appear. Confrim when Monarch prompts that yes, no fields need be defined for this FOOTER template.

           

          Now, define a detail template on one line using NNNNNN as the trap characters in the first 6 columns. Autodefine the usual fields that appear in that line.

           

          Define two additional fields in the space where the SUSP and TYPE fields appear, but define them as MEMO type and set them in Advanced Field Properties to end on "none of the above".

           

          In the Table, define calculated fields:

           

          SUSP1 = val(intrim(textline(SUSP;2)))

          TYPE1 = intrim(textline(TYPE;2))

           

          SUSP2 = val(intrim(textline(SUSP;3)))

          TYPE2 = intrim(textline(TYPE;3))

           

          Repeat for more if needed.

           

          HTH

           

          Olly

            • Guru Trap Help
              mlally _

              Olly, thank you very much. This will save my department a lot of time and effort.

                • Guru Trap Help
                  Olly Bond

                  Hello mlally,

                   

                  Thanks for the feedback - delighted to hear you got it working.

                   

                  That technique - of using fields which stop on "none of the above", combined with an empty template as a footer, crops up fairly often.

                   

                  Just watch out for the limits in Monarch - 254 fields, 4000 characters total data length per line - if you start using to deal with data that has lots of possible sub-postings.

                   

                  If you do need to handle bigger data, then a two pass solution would be more scaleable.

                   

                  Best wishes,

                   

                  Olly