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

    Making data from 1 line as separate records

      Hello,

       

      What I would like get from the sample report below is this:

      [font="courier"]04-01-04  11:11:38  1234  TOMMIE T TUTONE JR  15.00

      04-01-04  11:11:38  1234  TOMMIE T TUTONE JR  16.00

      04-01-04  11:11:38  1234  TOMMIE T TUTONE JR  17.00

      04-01-04  11:11:38  1234  TOMMIE T TUTONE JR  17.00

       

      |

      |  etc.

      v

       

      04-01-04  09:44:53  1112  Jacob S Jacobs     200.00

      04-01-04  09:17:50  12345 Madge B Doe        447.49

      04-01-04  09:17:50  12345 Madge B Doe        316.38[/font][/quote]I would like each check amount as a separate record for each MEM#.  Not all MEM# have checks and a MEM# record can be split on different pages. I tried splitting the checks into 3 columns, but the spacing between check amounts are not even.

       

      Any help would be greatly appreciated,

      Jeff

       

       

      SAMPLE REPORT:

      [font="courier"]----


           

      ABC CREDIT UNION                                      MEMBER HISTORY REPORT                                               04-02-04    

      MHST 04-02-04 12:41:51                              04-01-04 through 04-01-04                                             PAGE   8    

      -


                                                                                       

      MEM#:        1234TU   TUTONE, TOMMIE T JR        TIN: 123-12-1234                                                                     

           04-01-04 11:11:38        1234    FOR TOMMIE T TUTONE JR         443  11:14:30                                                     

             RECEIVED              334.00   IN CASH                                                                               

      RECEIVED              262.00   IN 10 CHECKS                                                                               

      15.00                     16.00                     17.00                                                          

                          17.00                     32.00                     69.00                                                          

                          16.00                     14.00                     16.00                                                          

                          50.00                                                                               

      DEPOSIT OF            596.00   TO ACCT    2                                                                               

      MEM#:        1112JA   JACOBS, JACOB S            TIN: 111-22-3333                                                                      

           04-01-04 09:44:53        1112    FOR Jacob S Jacobs             194  09:50:34                                                     

             RECEIVED              200.00   IN 1 CHECK                                                                               

      200.00                                                                               

      PAYMENT OF            200.00   TO LOAN  143                                                                               

      PRINCIPAL       132.26  INTEREST         67.74  LATE CHARGE       0.00                                                                               

      MEM#:        54321CO  CONNORS, KENNETH T         TIN: 333-11-2222                                                                      

           04-01-04 10:22:43        54321   FOR Kenneth T Connors          112  10:28:14                                                     

             WITHDRAWAL OF         600.00   FR ACCT    1                                                                               

      DISBURSAL             600.00   CASH                                                                               

      MEM#:        12345DO  DOE, MADGE B               TIN: 333-22-4444                                                                      

           04-01-04 09:17:50        12345   FOR Madge B Doe                353  09:23:18                                                     

             RECEIVED              447.49   IN 1 CHECK                                                                               

      447.49                                                                               

      DEPOSIT OF             47.49   TO ACCT    1                                                                               

      DISBURSAL             400.00   CASH                                                                               

      04-01-04 14:06:04        12345   FOR Madge B Doe                301  14:05:40                                                     

             RECEIVED              316.38   IN 1 CHECK                                                                               

      316.38                                                                               

      DEPOSIT OF            216.38   TO ACCT    1                                                                               

      DISBURSAL             100.00   CASH                                                                               

      /font[/quote]

        • Making data from 1 line as separate records
          Grant Perkins

          Hi JSR,

           

          This looks (at first sight) like a really ideal report for V7's multi column processing. 3 columns, left position of the first column starting at 1, width 26 seems to work from the sample I created using C&P from your posting.

           

          However, the check amounts really need to be the detail here to give you what you want as a final output. That means the Mem#'s without checks would not appear in the list. How do you need to handle that? What do you need to report for those without checks?

           

          My initial feeling on this is that you may need a 2 stage process. Stage 1 gets the Mem#'s and checks listed. Stage 2 gets a record for each Mem# and adds in any Mem#'s which don't have checks - or something like that depending on which way is the easiest and most suitable.

           

          Easier to do with V7 Pro of course - is that what you have available?

           

          Grant

          • Making data from 1 line as separate records

            Grant,

            Thanks for the quick response!!! Yes, I am using V7.  I was using V3 before, so I am still learning all that I can do now with V7.

             

            I did the columns as you suggested and it worked great!  V7 ROCKS! Simply Awesome!

             

            Thanks so much for the help,

            Jeff

            • Making data from 1 line as separate records
              Grant Perkins

              Originally posted by JSR:

                V7 ROCKS! Simply Awesome!

               

              /b[/quote]So, you quite like it then!     

               

              Quite a big step from V3 - especially if you have the Pro version. Great fun and tremendous capability though.

               

              Grant