3 Replies Latest reply: May 15, 2014 10:03 AM by jenny0531 _ RSS

    Help please- append continuing to blank fields

    jenny0531 _

      Hello- I am new to posting in the forum, but have gotten so much help from other posts. I haven't been able to find the answer to my problem though, and maybe I am not wording it correctly, so please point me to the right spot! I have been working with Monarch for about 9 years now, and I seem to learn something new each week- so more than willing to hear your thoughts!

       

      I am in Monarch Pro V7- working on an aged trial balance, and when I set the model up I am getting repeating lines where I don't want them. I have already checked to make sure that the radio button is filled in for "leave empty cells blank". I really think the problem is with my detail line... I think its because the detail line is there even if the append above it isn't, so it automatically picks the previous customer record as its append. I just don't know how to fix it.

       

      -


      DOCUMENT----


         PURGE     SVC        BILL

      INS TYPE R/S RESN DATE   NUMBER    CODE       DATE  CASH

                                                                                      Smith, A                   123456           LOC: 4 IN

         CARRIER TYPE      OO                               

      2117 INV  S    1 07/03/08         AAAAAAA 04/09/08    

             PURGE TOTAL                  51.80             

      CARRIER TYPE TOTAL                  51.80                                                                               

      CUSTOMER TOTAL                      51.80             

      INSURANCE TOTAL                    524.48             

      =======================================

        Smith, B                   ABCDEF           LOC: 4 IN

         CARRIER TYPE      OO                               

      2119 PAY  B   21 05/12/08 12345           04/08/08    

             PURGE TOTAL                  46.21-            

      2119 PAY  B   21 05/12/08 12345           04/08/08    

             PURGE TOTAL                  46.21             

      2119 INV  R    6 02/12/09         BBBBBBB 01/08/09    

             PURGE TOTAL                  40.91             

       

      Ok, here is the report(well, just the parts that matter- lol)- The Purge Total is my detail line. and the INV line is what I am grabbing as my append- the two dates and the purge code which I put as AAAAAAA and BBBBBBB for easier reference. Each line under Smith, B is being pulled and the PAY line purge totals are being matched with Smith, A's purge code.

       

      I tried using the Guru Trap, but, alas, I couldn't get it to work... Any ideas? Need more info??  Thank you soooo much!!

       

      Jenny :confused:

        • Help please- append continuing to blank fields
          Nick Osdale-Popa

          Would you mind reposting your sample report, but place the text between the code tags [/code]? This will keep the report structure intact.

           

          Thanks

          • Help please- append continuing to blank fields
            Gerhard _

            Hi Jenny,

             

            If I understand it right, changing your append template could be a solution.

             

            1. I guess you have the "INV" included in your append trap. If you use a trap which extracts not only the INV lines but also the PAY lines, you should have a correct matching. Now you know which "Purge total" is from a "PAY" line and which one is from an "INV" line.

             

            2. With the above extracted information you can create a filter in the table window to hide all "PAY" records.

             

            Hope this is what you want.

             

            Gerhard

              • Help please- append continuing to blank fields
                jenny0531 _

                Thanks Gerhard- I will try that!!

                 

                One of my concerns is that this is for someone in the field who has Monarch, but only uses the models- so, I want to make this as easy as I can for them!

                 

                Nick- thanks for the tip!!! Here it is

                 

                --


                DOCUMENT
                   PURGE     SVC   BILLED-AMT/            -
                AGED DOCUMENT TOTAL
                --


                   

                INS TYPE R/S RESN DATE   NUMBER   CODE       DATE  CASH-RECD     TAX       CURRENT  31- 60 DAY  61- 90 DAY  91-120 DAY OVER 120 DAYS 

                 

                 

                  Smith, A                   123456           LOC: 4 INS CODES: 1234 5678 9999   ID#S:                          TYP:B (215) 750-4151 

                   CARRIER TYPE      OO                                                                               

                2117 INV  S    1 07/03/08         AAAAAAA 04/09/08      51.80                                                                 51.80  

                       PURGE TOTAL                  51.80               51.80       .00         .00         .00         .00         .00       51.80  

                CARRIER TYPE TOTAL                  51.80               51.80       .00         .00         .00         .00         .00       51.80  

                 

                 

                 

                CUSTOMER TOTAL                      51.80               51.80       .00         .00         .00         .00         .00       51.80  

                INSURANCE TOTAL                    524.48              524.48       .00         .00         .00         .00         .00      524.48  

                 

                 

                 

                INSURANCE CODE      2119    CENTRAL STATE HEALTH&LIFE                                                                (800) 541-2363 

                ==================================================================================================================================== 

                  Smith, B                   ABCDEF           LOC: 4 INS CODES: 1234 5678 9999   ID#S:                          TYP:O (215) 925-8720 

                   CARRIER TYPE      OO                                                                               

                2119 PAY  B   21 05/12/08 12345           04/08/08      46.21-                                                                46.21- 

                       PURGE TOTAL                  46.21-              46.21-      .00         .00         .00         .00         .00       46.21- 

                2119 PAY  B   21 05/12/08 12345           04/08/08      46.21                                                                 46.21  

                       PURGE TOTAL                  46.21               46.21       .00         .00         .00         .00         .00       46.21  

                2119 INV  R    6 02/12/09         BBBBBBB 01/08/09      40.91                 40.91                                                  

                       PURGE TOTAL                  40.91               40.91       .00       40.91         .00         .00         .00              

                /code