5 Replies Latest reply: May 15, 2014 10:05 AM by bmartuch _ RSS

    Address Blocks in Version 9

    bmartuch _

      I am having trouble with the address blocks.  My report is not formatted the same way that they are in the users guide.  There are no blank lines after the address.  The next record start immediately.

       

       

      PREPARED  9/21/09  9:18:38                          1099 VENDOR DETAIL FOR 2006                                           PAGE     1

      PROGRAM: ABCD1234                                         FROM VENDOR MASTER

      CITY OF City State                                   1099-MISC: MISCELLANEOUS

      -


      VENDOR  VENDOR                             FEDERAL

         NO    NAME                               TAX ID     Nonemployee Compensation

      -


            5  COMPANY A                           99-9999999                         55,555.26

               3649 STREET A

               CITY, MI  99999

           12  COMPANY B                           88-8888888                          6,666.21

               DRAWER #88888

               PO BOX 44444

               OLD CITY, MI  55555

           13  COMPANY C                           77-7777777                         55,555.19

               6666 STREET C

               NEW CITY, MI  55555

           14  ANOTHER COMPANY                     66-6666666                            222.78

               7901 BIG STREET

      PREPARED  9/21/09  9:18:38                          1099 VENDOR DETAIL FOR 2006                                           PAGE     2

      PROGRAM: ABCD1234                                         FROM VENDOR MASTER

      CITY OF CITY, STATE                                  1099-MISC: MISCELLANEOUS

      -


      VENDOR  VENDOR                             FEDERAL

         NO    NAME                               TAX ID     Nonemployee Compensation

      -


               THAT CITY, MI  33333

           18  COMPANY 555                         88-8888888                          7,777.77

               DRAWER 698569

               PO BOX 44444

               OLD CITY, MI  55555[/CODE]   

       

      [EMAIL="bmartuch@Saginaw-mi.com"]bmartuch@Saginaw-mi.com[/EMAIL]

        • Address Blocks in Version 9
          Data Kruncher

          Hi bmartuch. Welcome to the forum.

           

          Using your sample, I built two templates: the detail, and a page header.

           

          For the detail template, using a one line sample, I simply trapped on a numeric vendor number, and painted the fields. I named the Vendor information "A" and on the Advanced tab, selected End Field on "End of left Justification".

           

          For the page header, I trapped on "PREPARED" for a 7 line sample. I did not paint any fields to capture, however.

           

          The page header template being defined helps Monarch to know that the lines that follow, if they don't match the detail (or append) template definition, belong to the last detail record. In your sample case, that means that "THAT CITY" belongs to vendor 14.

           

          Then in the Table window use the Address block on field A as described in the tutorial. This should get you to:

          A                                                         TAXID      COMPENSATION  VENDORNUM VENDORLINE1       VENDORLINE2     VENDORLINE3  VENDORCIT VENDORREGION VENDORPOSTALCOD VENDORERRORCODE

          COMPANY A 3649 STREET A CITY, MI  99999                   99-9999999     55555.26          5 COMPANY A         3649 STREET A                CITY      MI           99999           0             

          COMPANY B DRAWER #88888 PO BOX 44444 OLD CITY, MI  55555  88-8888888      6666.21         12 COMPANY B         DRAWER #88888   PO BOX 44444 OLD CITY  MI           55555           0             

          COMPANY C 6666 STREET C NEW CITY, MI  55555               77-7777777     55555.19         13 COMPANY C         6666 STREET C                NEW CITY  MI           55555           0             

          ANOTHER COMPANY 7901 BIG STREET THAT CITY, MI  33333      66-6666666       222.78         14 ANOTHER COMPANY   7901 BIG STREET              THAT CITY MI           33333           0             

          COMPANY 555 DRAWER 698569 PO BOX 44444 OLD CITY, MI  5555 88-8888888      7777.77         18 COMPANY 555       DRAWER 698569   PO BOX 44444 OLD CITY  MI           55555           0             

          /code

           

          Questions?

           

          HTH,

           

          Kruncher

            • Address Blocks in Version 9
              Olly Bond

              Hi bmartuch,

               

              Belt and braces, perhaps, but if you defined a seven line header template that took the data from PREPARED... to the second row of -


              , this would cover for any cases where the detail data was broken over two pages.

               

              Best wishes,

               

              Olly

              • Address Blocks in Version 9
                bmartuch _

                Kruncher, that got pretty close but some of them are still wrong.  For Company B,

                Drawer #88888 /Bis correctly in Address 1

                There is nothing in Address 2

                PO[/B] is in City

                Box[/B] is in Region

                55555[/B] is correctly in Postal Code

                 

                Obviously, I'm still doing something wrong.

                  • Address Blocks in Version 9
                    Data Kruncher

                    First, make sure that your inital field is wide enough. I've got the template width for the field set at 20.

                     

                    With the Address Block, I selected the first three address lines, City, Region, Postal Code and Error Code.

                     

                    It's a good practice to always include the error code. Then it's easy to double-check Monarch's work (it's good, OK very very good, but not always perfect) by creating a filter for ErrorCode<>0.

                     

                    Is that any better for you?

                      • Address Blocks in Version 9
                        bmartuch _

                        Hey Kruncher,

                            After much searching to find out what the bad records had in common, I finally found it.  They all had improper formatting on the zip codes.  Instead of Zip+4 looking like 99999-9999, it looked like 99999-999.  Either the data was entered into the system where someone entered the dash in a field that was only meant for 9 digits or the report only displayed 9 characters.  On one of the reports, I deleted the last four characters of the zip code to see if that would solve the problem and it did.

                         

                            Thanks a lot for all of your help.  I wouldn't have known to set the End of Field to "End of left Justification" on the advanced tab.

                         

                        Bob