0 Replies Latest reply: May 15, 2014 10:05 AM by Guy Chowning RSS

    Trapping a variable row

    Guy Chowning

      A sample page from the report is shown below.

       

       

      SHIPDATE   VEHICLE ID  SHIPMENT    Y INVENTRY P.CONTRACT LN FOB SHIPPER       PURCHASE     ACCRUED     ACCRUED     ACCRUED   ACCRUAL   

      TICKET NO  FRT CARRIER SHIPMENT BR D   CODE   S.CONTRACT LN FOB CUSTOMER      - COST -   -FREIGHT-   -INVCOST-   - SALES -  -CODES-                                                                               

      11/11/09  INO  96029   504426  NP F 100      RS09574FNP 01  M1                    .00                     .00         .00             

      MACHLO    INGR90 01    504426  HQ            RS09574FNP 01  S1 GALGHR            0 LBS    8500.00           0            0            

      11/18/09  INO  71056   508265  NP F 100      RS09574FNP 01  M1                    .00                     .00   336732.15             

      MADTYK    INGR90 01    508265  HQ            RS09574FNP 01  S1 GALGHR            0 LBS    8500.00           0      3017120            

                                               G/L ACCOUNT     SRC D/C                                                                       

           PRODUCT CLASS TOTALS F100 NP        420-024-5701.00 f/a D    17000.00         .00    17000.00         .00   336732.15             

                                               400-002-1040.00 f/a C    17000.00           0    LBS                0     3017120             

                                               400-001-2020.00 s/a D   336732.15         .00 TNS                 .00     1346.93             

                                               420-024-5111.00 s/a C   336732.15                                                                               

      11/06/09  TKNP TABDAD  502150  NP F 110      NP-028837Z 01  M1                    .00                     .00    24847.20             

      TABDAD    CLAR70 01    502150  HQ            RMR028837Z 01  S1 ALLCHM            0 LBS     726.00           0        42840            

      11/10/09  TKNP MABWPK  503454  NP F 110      NP-9110632 01  M3                    .00                     .00    23446.08             

      MABWPK                 503454  HQ            RMR9110632 01  S3 AUDHEM            0 LBS        .00           0        41868            

      11/09/09  TKNP TABOCN  503493  NP F 110      NP-028870Z 01  M1                    .00                     .00    26232.80             

      TABOCN    STMSHP 02    503493  HQ            RMR028870Z 01  S1 CHOCHM            0 LBS    2100.00           0        43360            

                 CCIC50 03    503493                                                              150.00                                     

                 BOHA50 04    503493                                                              150.00                                                                               

      11/10/09  TKNP TABWMF  503693  NP F 110      NP-028870Z 01  M1                    .00                     .00    26196.50             

      TABWMF    STMSHP 02    503693  HQ            RMR028870Z 01  S1 CHOCHM            0 LBS    2100.00           0        43300            

                 CCIC50 03    503693                                                              150.00                                     

                 BOHA50 04    503693                                                              150.00                                                                               

      11/13/09  TKNP TACUPL  505911  NP F 110      NP-0029562 01  M1                    .00                     .00    24194.88             

      TACUPL    CLAR70 01    505911  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        39024            

      11/17/09  TKNP TADNYV  507619  NP F 110      NP-0029562 01  M1                    .00                     .00    25121.16             

      TADNYV    CLAR70 01    507619  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        40518            

      11/20/09  TKNP TAEDHC  509663  NP F 110      NP-0029562 01  M1                    .00                     .00    24920.28             

      TAEDHC    CLAR70 01    509663  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        40194            

      11/23/09  TKNP TAENDR  510558  NP F 110      NP-0029562 01  M1                    .00                     .00    24161.40             

      TAENDR    CLAR70 01    510558  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        38970            

      11/23/09  TKNP TAESLN  510930  NP F 110      NP-0029562 01  M1                    .00                     .00    25701.48             

      TAESLN    CLAR70 01    510930  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        41454            

      11/23/09  TKNP TAESWP  510975  NP F 110      NP-0029562 01  M1                    .00                     .00    25065.36             

      TAESWP    CLAR70 01    510975  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        40428            

      11/24/09  TKNP TAEUZY  511325  NP F 110      NP-0029562 01  M1                    .00                     .00    25489.44             

      TAEUZY    CLAR70 01    511325  HQ            RMR0029562 01  S1 OMNISOURC         0 LBS     565.00           0        41112            

      11/25/09  TKNP TAFFXG  512808  NP F 110      NP-9110632 01  M3                    .00                     .00    23284.80             

       

      /CODE