2 Replies Latest reply: May 15, 2014 10:09 AM by Grant Perkins RSS

    Templetes

    Ray Seth

      I am trying to set up templetes on the below data.  As you can see, not all projects have a balance in every account.  For example, the second and third project number don't have account number 30-2137-00.  I expected to see that it would show either null or zero for this templete line but istead it is picking up the last 30-2137 account number that had a balance.  I checked off the box to leave blank but doesn't seem to help.  Any suggestions would be greatly appreciated.

       

       

      3552211003 - Ackerman Gosciewski Ma

                                          

      30-2130-00                 500.00      

      30-2131-00                   10.00    

      30-2132-00                     5.00  

      30-2133-00                    (2.50)   

      30-2134-00                     5.00  

      30-2135-00                     5.00  

      30-2136-00                     5.00  

      30-2137-00                     7.00  

      30-2138-00                     2.00  

      30-2139-00                   (6.00)    

                                          

      3552211015 - Aime H. Doucette Schol

                                          

      30-2130-00               1000.00        

      30-2131-00                   50.00    

      30-2132-00                   25.00    

      30-2133-00                  (10.00)     

      30-2134-00                     5.00    

      30-2135-00                     7.00  

      30-2136-00                   10.00  

      30-2138-00                   12.00   

      30-2139-00                   (8.00)     

                                          

      3552211025 - Anna Filley Bequest  

                                          

      30-2130-00              12000.00      

      30-2131-00                  100.00     

      30-2132-00                    37.00    

      30-2133-00                   (20.00)    

      30-2134-00                    10.00   

      30-2135-00                      5.00 

      30-2138-00                      6.00 

      30-2139-00                    (4.00)

        • Templetes
          elginreigner _

          Without having a template to stop it, Monarch will keep reading up/down depending on template, until it gets a value. You can have it cleared by the detail line, or create a blank template inbetween detail values to stop it.

            • Templetes
              Grant Perkins

              Welcome to the forum Ray.

               

              Can you provide some indication of what you required output will look like and how you have set up your model templates so far?

               

              Also  - is there a maximum population of account numbers that might appear in a report and if so what is the number?

               

              Grant