1 Reply Latest reply: May 15, 2014 9:57 AM by Grant Perkins RSS

    Append entry missing in table view

    PIERRE _

      Dear Colleagues

       

      I have a report with an Append and below the detail entries. An append is e.g. a Project. Now I want to get all appends (Projects) in my table view no matter if detail entries (postings) have been made to this append or not. Below example shall illustrate the situation. The append lines marked with X do not appear in the table.

       

      720    720    720837646 AE20   200206 200206

      331001     COIN CR  41352      24.06.2002 31

      331001     COIN KR  102571     20.06.2002 31

      720    720    720837647 AE20   200206 200206  X

      720    720    720837649 AE20   200206 200206  X

      720    720    720837650 AE20   200206 200206

      331001     COIN BE  520646     11.07.2002 15

      720    720    720837651 AE20   200206 200206

      331001     COIN BE  520646     11.07.2002 15

      311111     COIN KR  102571     20.06.2002 31

      311111     COIN CR  41352      24.06.2002 31

      720    720    720837653 AE20   200206 200206  X

      720    720    720837654 AE20   200206 200206

      592211     KOAO     383973     29.07.2002 31

      311311     COIN DR  723072726  20.06.2002 29

      331001     COIN BE  520646     11.07.2002 15

      592111     KOAO     383973     29.07.2002 31

       

      For sure somebody can give me a hint how to solve this problem.

       

      Many thanks in advance

       

      Pierre

        • Append entry missing in table view
          Grant Perkins

          Originally posted by PIERRE:

          [font="courier"]720    720    720837646 AE20   200206 200206

          331001     COIN CR  41352      24.06.2002 31

          331001     COIN KR  102571     20.06.2002 31

          720    720    720837647 AE20   200206 200206  X

          720    720    720837649 AE20   200206 200206  X

          720    720    720837650 AE20   200206 200206

          331001     COIN BE  520646     11.07.2002 15

          720    720    720837651 AE20   200206 200206

          331001     COIN BE  520646     11.07.2002 15

          311111     COIN KR  102571     20.06.2002 31

          311111     COIN CR  41352      24.06.2002 31

          720    720    720837653 AE20   200206 200206  X

          720    720    720837654 AE20   200206 200206

          592211     KOAO     383973     29.07.2002 31

          311311     COIN DR  723072726  20.06.2002 29

          331001     COIN BE  520646     11.07.2002 15

          592111     KOAO     383973     29.07.2002 31[/font][/quote][/b][/quote]Hi Pierre,

           

          The problem is that the append lines you have marked do not have any detail lines associated with them. So with no detail line to attach to they are not included in the report.

           

          In some cases this could be a benefit but perhaps not for you.

           

          If you need to report all projects, even if there are no activity lines to report, the Project lines must be made the detail by some method.

           

          How you do this will depend to some extent upon whcih version of Monarch you have and to a large extent on whether you have a Pro version with the external lookup capability.

           

          With that information, and a description of what you need the data to look like when extracted, it would be possible to come up with a way for you extract what you need using one of several possible approaches.

           

          Let us know and I am sure that quite a few people will be pleased to make some suggestions.

           

          Grant