6 Replies Latest reply: May 15, 2014 10:08 AM by Rusch Mauzy RSS

    Help Trapping Records

    Rusch Mauzy

      I need guidance trapping records on this report.  How can I ignore the records with the Heading of ZONE RECAP?

       

      Thank you,

       

      Rusch

       

       

       

      DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    6       TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633     LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    -- CHAIN -- CUSTOMER:116217 DADE JUVENILE DENTEN REB CODE:  982                REBDSC:      11.15   PROMO:        .00   BILCOD: 01     AF 51        18500 SW 424TH ST FLORIDA CITY    FL 33034   DSC CODE:            RETURN:        .00    ADJUST:        .00    ARTYPE: 1   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  153     2,450       557.55                 11.15       .22302      426.42       119.98               CUSTOMER TOTALS:                  153     2,450       557.55                 11.15                   426.42       119.98         ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 00     AVERAGE POINTS PER DELIVERY:         30      PRICE SCHEDULE: 0982          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    7       TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633     LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -     AF 51  ZONE RECAP   REBATE:        11.15    RETURNS:                 PROMOTION:                 ADJUSTS:                              - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  153     2,450       557.55                 11.15       .22302      426.42       119.98             FLAT REBATE                                                                                ZONE TOTALS:                  153     2,450       557.55               1475.20                   426.42       119.98                                             REBATE/DISCOUNT ROUNDING DIFF:               1464.05                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    -- CHAIN -- CUSTOMER:250453 OKEECHOBEE JUVENILE  REB CODE:  982                REBDSC:      13.20   PROMO:        .00   BILCOD: 01     AF 52        5050 NE 168TH STR OKEECHOBEE      FL 34972   DSC CODE:            RETURN:        .00    ADJUST:        .02    ARTYPE: 1   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  178     2,850       652.65                 13.05       .22442      496.04       143.56       4069  SKIM SLM PK    HPT                    2        31         7.32                   .15       .23129        4.90         2.27               CUSTOMER TOTALS:                  180     2,881       659.97                 13.20                   500.94       145.83         ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 01     AVERAGE POINTS PER DELIVERY:         36      PRICE SCHEDULE: 0982          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    8       TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633     LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -     AF 52  ZONE RECAP   REBATE:        13.20    RETURNS:                 PROMOTION:                 ADJUSTS:          .02                 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  178     2,850       652.65                 13.05       .22051      496.04       143.56       4069  SKIM SLM PK    HPT                    2        31         7.32                   .15       .23129        4.90         2.27             FLAT REBATE                                                                                ZONE TOTALS:                  180     2,881       659.97                 13.20                   500.94       145.83    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    -- CHAIN -- CUSTOMER:880827 LEVY COUNTY JAIL     REB CODE:  982                REBDSC:      13.74   PROMO:        .00   BILCOD: 01     AF 88   192  9150 NE 80TH AVE  BRONSON         FL 32621   DSC CODE:            RETURN:        .00    ADJUST:        .00    ARTYPE: 1   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  188     3,000       687.00                 13.74       .22442      505.41       167.85               CUSTOMER TOTALS:                  188     3,000       687.00                 13.74                   505.41       167.85         ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 01     AVERAGE POINTS PER DELIVERY:         37      PRICE SCHEDULE: 0982          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    -- CHAIN -- CUSTOMER:882081 CYPRESS CREEK CORE F REB CODE:  982                REBDSC:      17.40   PROMO:        .00   BILCOD: 01     AF 88        2855 W WOODLAND R LECANTO         FL 34461   DSC CODE:            RETURN:        .00    ADJUST:        .00    ARTYPE: 1   - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  238     3,800       870.20                 17.40       .22442      640.18       212.62               CUSTOMER TOTALS:                  238     3,800       870.20                 17.40                   640.18       212.62         ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 01     AVERAGE POINTS PER DELIVERY:         47      PRICE SCHEDULE: 0982          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    9       TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633     LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -     AF 88  ZONE RECAP   REBATE:        31.14    RETURNS:                 PROMOTION:                 ADJUSTS:                              - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  426     6,800     1,557.20                 31.14       .22086    1,145.59       380.47             FLAT REBATE                                                                                ZONE TOTALS:                  426     6,800     1,557.20                 31.14                 1,145.59       380.47    DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE   10       TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633     LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -     AF    CHAIN RECAP   REBATE:        55.49    RETURNS:                 PROMOTION:                 ADJUSTS:          .02                 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                               NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET       4030  2% SLM PK      HPT                  757    12,100     2,767.40                 55.34       .22414    2,068.05       644.01       4069  SKIM SLM PK    HPT                    2        31         7.32                   .15       .23129        4.90         2.27             FLAT REBATE                                                                                CHAIN TOTALS:                  759    12,131     2,774.72               1519.54                 2,072.95       646.28                                             REBATE/DISCOUNT ROUNDING DIFF:               1464.05                                         

      /CODE

        • Help Trapping Records
          Olly Bond

          Hello Rusch,

           

          It might be my browser (IE6 here) but the report formatting seems not to have honoured carriage returns.

           

          Is this what he data looks like?

           

          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    6      

          TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633    

          LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                        

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   

           

          -- CHAIN -- CUSTOMER:116217 DADE JUVENILE DENTEN

          REB CODE:  982                REBDSC:      11.15   PROMO:        .00   BILCOD: 01     AF 51       

          18500 SW 424TH ST FLORIDA CITY    FL 33034   DSC CODE:            RETURN:        .00    ADJUST:        .00    ARTYPE: 1  

           

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   

           

          PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                              

          NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET      

          4030  2% SLM PK      HPT                  153     2,450       557.55                 11.15       .22302      426.42       119.98              

          CUSTOMER TOTALS:                  153     2,450       557.55                 11.15                   426.42       119.98        

          ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 00     AVERAGE POINTS PER DELIVERY:         30      PRICE SCHEDULE: 0982         

           

          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    7      

          TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633    

          LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                         

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    

          AF 51  ZONE RECAP   REBATE:        11.15    RETURNS:                 PROMOTION:                 ADJUSTS:                             

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   

          PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                              

          NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET      

          4030  2% SLM PK      HPT                  153     2,450       557.55                 11.15       .22302      426.42       119.98            

          FLAT REBATE                                                                               

          ZONE TOTALS:                  153     2,450       557.55               1475.20                   426.42       119.98                                            

           

          REBATE/DISCOUNT ROUNDING DIFF:               1464.05                                         

           

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   

           

          -- CHAIN -- CUSTOMER:250453 OKEECHOBEE JUVENILE 

          REB CODE:  982                REBDSC:      13.20   PROMO:        .00   BILCOD: 01    AF 52       

          5050 NE 168TH STR OKEECHOBEE      FL 34972   DSC CODE:            RETURN:        .00    ADJUST:        .02    ARTYPE: 1  

           

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -   

           

          PRODUCT                                 - - - - - - SALES - - - - - - -                           AVERAGE                              

           

          NUMBER         DESCRIPTION               POINTS     UNITS       AMOUNT   DISCOUNT     REBATE    D/R PRICE        COST          NET      

           

          4030  2% SLM PK      HPT                  178     2,850       652.65                 13.05       .22442      496.04       143.56      

          4069  SKIM SLM PK    HPT                    2        31         7.32                   .15       .23129        4.90         2.27              

           

          CUSTOMER TOTALS:                  180     2,881       659.97                 13.20                   500.94       145.83        

           

          ACTUAL DELIVERIES: 05     SCHEDULED DELIVERIES: 01     AVERAGE POINTS PER DELIVERY:         36      PRICE SCHEDULE: 0982         

           

          DATE 07/02/10                                           VELDA FARMS DAIRIES                                            PAGE    8      

          TIME 00:11:56                                  MONTH CUSTOMER REBATE/DISCOUNT ANALYSIS                                 PGM: RAP633    

          LOCATION: VELDA FARMS, LLC                             MONTH ENDING: 06/30/10                                                         

          - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -    

           

          ...

           

          /CODE

           

          If the Zone Recap is an area of the report that you'll capture with an append template, then you'll need a filter, if it's in the detail template, then you could use the trap to avoid those records.

           

          Best wishes,

           

          Olly

            • Help Trapping Records
              Rusch Mauzy

              Ollie,

               

              Thank you; this is what he data looks like. 

               

              We tried to exclude the Zone Recap records from the detail, but could not find anything unique about the. 

               

              Thanks,

               

              Rusch

                • Help Trapping Records
                  Olly Bond

                  Hello Rusch,

                   

                  From the limited (2-3 page) sample in my post - what data do you need? What's the detail of each record?

                   

                  4030  2% SLM PK      HPT                  153     2,450       557.55 /CODE

                   

                  If so, then the ZONE RECAP append looks like it only appears for some records (I'm guessing from a tiny sample). You might be able to solve it with an Append that is set to clear on the next instance of another template, and then create another append like CustomerName to clear on. That would need v10, BTW.

                   

                  Best wishes,

                   

                  Olly