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

    Non persistent memo field for record

    BillB _

      Hi

      I have a report that lists a fixed set of transaction detail fields on one line, and then on a second line reports any descriptive text comment that was attached to the entry. the problem is - the second text line is not required and therefore does not appear with every record.

      Here's an example:

      TR NUM  TR DATE  ENT DATE JV NUMBER       SRC PROJECT NUMBER           BEG BALANCE    DEBIT          CREDIT         END BALANCE  

      -


      -


      -


      -


      -- -


      -


      -


      -


      -


                                                                                      ACCT NUMBER: 1-10-000-0000-1007       Cash - Operating                    -4225384.64                                            

         70010 03/01/07 03/02/07 SJV-101          AR                                               75339.51                             

         70059 03/01/07 03/08/07                  RA                                                           -8203829.07              

               ACCRUAL TRANSACTION FOR THIS REVERSAL IS:    69906                                                                       

         70081 03/02/07 03/09/07 SJV-101          AR                                              711203.59                             

         70091 03/09/07 03/16/07 SJV-101          AR                                              696633.11                             

         70093 03/08/07 03/20/07                  GL                                                              36753.18              

               WIRE PAYMENT TO FUNLOC 130218                                                                               

      70102 03/19/07 03/22/07 SJV-WIRE         GL                                                             192478.65              

               WIRE PAYMENT TO FUNLOC 130915                                                                               

      I don't know if this posts clearly enough to see what I'm describing....

      In any case, line 70010 has no text descrip line, but line 70059 does.

      I've tried dealing with this with both an append and footer template. both don't get me there. both assign a description to a line that does not have one.

      The result I'd like would be line this - where there is no description for line 70010.

      GL ACCT     ACCT NAME     TRANS #     TRAN DATE     ENTRY DATE     JV NUMBER     SOURCE     DEBIT     CREDIT     DESCRIP

      1-10-000-0000-1007     Cash - Operating     70010     03/01/07     03/02/07     SJV-101     AR     75,339.51           

      1-10-000-0000-1007     Cash - Operating     70059     03/01/07     03/08/07          RA          (8,203,829.07)     ACCRUAL TRANSACTION FOR THIS REVERSAL IS:    69906

       

      thanks for any help you can give!

        • Non persistent memo field for record
          Grant Perkins

          Quick posting to re-format the report layout for ease of reading - more to follow.

           

            Originally posted by BillB:

          Hi

          I have a report that lists a fixed set of transaction detail fields on one line, and then on a second line reports any descriptive text comment that was attached to the entry. the problem is - the second text line is not required and therefore does not appear with every record.

          Here's an example:[quote][font="courier"] TR NUM  TR DATE  ENT DATE JV NUMBER       SRC PROJECT NUMBER           BEG BALANCE    DEBIT          CREDIT         END BALANCE  

          -


          -


          -


          -


          -- -


          -


          -


          -


          -


                                                                                          ACCT NUMBER: 1-10-000-0000-1007       Cash - Operating                    -4225384.64                                            

             70010 03/01/07 03/02/07 SJV-101          AR                                               75339.51                             

             70059 03/01/07 03/08/07                  RA                                                           -8203829.07              

                   ACCRUAL TRANSACTION FOR THIS REVERSAL IS:    69906                                                                       

             70081 03/02/07 03/09/07 SJV-101          AR                                              711203.59                             

             70091 03/09/07 03/16/07 SJV-101          AR                                              696633.11                             

             70093 03/08/07 03/20/07                  GL                                                              36753.18              

                   WIRE PAYMENT TO FUNLOC 130218                                                                               

          70102 03/19/07 03/22/07 SJV-WIRE         GL                                                             192478.65              

                   WIRE PAYMENT TO FUNLOC 130915                                             /font[/quote]I don't know if this posts clearly enough to see what I'm describing....

          In any case, line 70010 has no text descrip line, but line 70059 does.

          I've tried dealing with this with both an append and footer template. both don't get me there. both assign a description to a line that does not have one.

          The result I'd like would be line this - where there is no description for line 70010.

          [font="courier"]GL ACCT     ACCT NAME     TRANS #     TRAN DATE     ENTRY DATE     JV NUMBER     SOURCE     DEBIT     CREDIT     DESCRIP

          1-10-000-0000-1007     Cash - Operating     70010     03/01/07     03/02/07     SJV-101     AR     75,339.51           

          1-10-000-0000-1007     Cash - Operating     70059     03/01/07     03/08/07          RA          (8,203,829.07)     ACCRUAL TRANSACTION FOR THIS REVERSAL IS:    69906 /font[/quote]thanks for any help you can give! [/b][/quote][url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000736#000000"]This[/url] previous similar problem may offer a solution.

           

          I have not yet checked it and was thinking of something similar but slightly different to identify whether or not there is a field to report for the Append Template but knowing the source of this sugestion I reckon it should give you what you want.

           

          HTH.

           

           

          Grant

          • Non persistent memo field for record
            Grant Perkins

            Hi Bill,

             

            The suggestion in the link above works fine.

             

            The other option is to do the same thing but instead of using the advanced function "Start Field On" set to 'After last field in template' use the one before it for 'Preceding string' and set a string of blanks - up to 8 but certainly more that 3 I think. Be sure to make the field wide enough for the max width entry that may come your way!

             

            You will need another append to pick up the Account info from the header line.

             

            In you data table simply move the column with the description field to wherever you want it to appear relative to the other columns. Click to highlight it first and then click and drag across the columns for example but there are other ways as well.

             

            HTH.

             

             

            Grant

             

            Edit to add: I checked these solutions using V7. I am fairly sure the preceding blanks idea would work for V6 as well but have this niggling thought that there may have been some subtle differences in play during the V6 releases that slightly affected the way the preceding string worked when blanks were used. Probably easier for you to try than for me as I think I only have a V6.02 system around if I can find it.

             

            [size="1"][ April 13, 2007, 08:44 PM: Message edited by: Grant Perkins ][/size]