2 Replies Latest reply: May 15, 2014 9:57 AM by Nick Osdale-Popa RSS

    Possible To Trap in one Model

    Nick Osdale-Popa

      I don't see an option to attach files, so I'll use what's available.

      Below are two types of reporting on Vendor Invoices.

      Report 1 is for over $250

      Report 2, under.

       

      I can easily trap the Invoice "header": Vendor, dates, etc.

      I have a Footer Template for Report 1 to trap Job/Phase/Cost Code.

      Obviously, this template does not work for Report 2.

       

      Since these lines are Line Numbers, there could be more than 1 line under each header. I only need Line 1. (Though I guess a filter can fix that)

      Will it be possible to create a model that will trap both scenarios?

       

      [font="courier"]RUN DATE 07/16/02 14:50:36                            COINS ACCOUNTS PAYABLE MODULE                                    PAGE   1        

      BIGBIG COMPANY                                        UNPOSTED VENDOR INVOICE LIST                                                     

      BATCH:  TW0715E                                              SORTED BY ENTRY                                                                               

      FOR ALL USER IDS                                                                               

      VENDOR   VENDOR NAME                    INVOICE    INV DATE DUE DATE  CO  DIV  APP  PAYABLES      DISC                                                                               

      FISC DT  DISC DT                  ACCOUNT       AMT                                                                               

      8048     XXXXXVENDORNAMEXXXXXXXXXXX     806501     07/09/02 09/07/02   1    1  Y       20100      6.54 AMOUNT:                326.88   

               XXXXXADDRESSXXXXXXXXXXXXXX P/O 01153-229  07/31/02 08/10/02                                   SALES TAX:               0.00   

               XXXXXADDRESSXXXXXXXXXXXXXX C/O 0000                                                           FREIGHT:                 0.00   

               XXXXXCITYSTZIPXXXXXXXXXXXX                                  DOCUMENT ID:                      INVOICE AMOUNT:        326.88                                                                               

      INVOICE LINE:    1                            TAX/DIR PAY:       N  N         P/O LINE:       1                           

                   JOB:           11.111                         TAX JURIS:         LA           QTY ORDERED:        30.00                   

                   PHASE:         PH                             CO/DIV/CTR:     1    1    1     QTY RECEIVED:       30.00                   

                   COST CODE:     CSCD                           G/L ACCOUNT:    15010           QTY PREV INV:        0.00                   

                   CATEGORY:      MA                             QTY INVOICED:         30.000    AMT PREV INV:        0.00                   

       

       

       

       

       

      <<<2nd Report>>>

       

      RUN DATE 07/16/02 14:50:57                            COINS ACCOUNTS PAYABLE MODULE                                    PAGE   1        

      BIGBIG COMPANY                                        UNPOSTED VENDOR INVOICE LIST                                                     

      BATCH:  TW0715F                                              SORTED BY ENTRY                                                                               

      FOR ALL USER IDS                                                                               

      VENDOR   VENDOR NAME                    INVOICE    INV DATE DUE DATE  CO  DIV  APP  PAYABLES      DISC                                                                               

      FISC DT  DISC DT                  ACCOUNT       AMT                                                                               

      8048     XXXXXVENDORNAMEXXXXXXXXXXX     806501     07/08/02 09/06/02   1    1  Y       20100      0.25 AMOUNT:                 12.69   

               XXXXXADDRESSXXXXXXXXXXXXXX                07/31/02 08/10/02                                   SALES TAX:               0.00   

               XXXXXADDRESSXXXXXXXXXXXXXX                20002-195                                           FREIGHT:                 0.00   

               XXXXXCITYSTZIPXXXXXXXXXXXX                                  DOCUMENT ID:                      INVOICE AMOUNT:         12.69                                                                               

      COST             INST     DIR TAX           USE TAX                 G/L                                              

      LINE JOB      PH CODE     CAT    QUANT TAX PAY JURIS          AMOUNT  CO DIV CTR ACCOUNT      QUANTITY       UNIT COST       AMOUNT   

          1 11.111   PH CSCD     MA      0.00 N   N   LA               0.00   1   1   1   15010         0.000         0.00000        12.69    /font[/quote]

       

      [size="1"][ July 22, 2002, 06:56 PM: Message edited by: Nick Osdale-Popa ][/size]

        • Possible To Trap in one Model
          Mike Urbonas

          Hi Nick, we are not ignoring you, honest! 

           

          I looked at your reports.  Odd how the report > $250 and < $250 have such different display format for the detail data...

           

          Although it MAY be possible to generate one mightily complex single model to get the data from both reports despite the different layouts, I suggest the benefit does not justify the effort.

           

          Instead I suggest simply creating one model for each report and append the results to the same Excel  or Access file.  Of course if you would like to then open that Excel or Access file in Monarch Pro, you can do that too  smile.gif[/img]

           

          Mike

          • Possible To Trap in one Model
            Nick Osdale-Popa

            Thanks. I did determine it was easier to use 2 models.  Both <250 and >250 information does get printed to the same report, so I am using 2 passes, 1 for each model. 

            Since almost all my Monarch usage is through Excel (or Access) via OLE the process is hidden from the user. My default VBA Class that I use for Monarch had to be slightly tweaked. Actually not so much the Class, as the routine that uses the Class.

            Thanks again!