2 Replies Latest reply: May 15, 2014 10:03 AM by GuinnessDrinker _ RSS

    Data Trapping Problem

    GuinnessDrinker _

      Hello

      Can anyone help

       

      Vendor Invoice no   Doc Date Type         ICN          Reas AGC  TERM   Disc     Net        Amount       Discount      Balance      

      -


      -


      -


      -


      -


      -


      -


      -


      -


      -


      -


      -


                                                                                       

      BG56197              05/12/08  I               60990251      TS   E             30/01/09         749.60                      749.60  

      BG56431              11/12/08  I               60990290      TS   E             30/01/09         365.68                      365.68  

      BG59395              11/12/08  I               60990291      TS   E             30/01/09         218.88                      218.88  

      BG60308              11/12/08  I               60990292      TS   E             30/01/09         749.60                      749.60  

      MI-002935            04/12/08  I               60990347      TS   E             30/01/09       42109.72                    42109.72  

                              Doc Curr: EUR                           Rate:     1.4400000            60638.00                    60638.00  

      MI-002936            04/12/08  I               60990348      TS   E             30/01/09        7500.00                     7500.00  

                              Doc Curr: EUR                           Rate:     1.4400000            10800.00                    10800.00  

      MI-002945            08/12/08  I               60990349      TS   E             30/01/09         665.00                      665.00  

      MI-00295             08/12/08  I               60990350      TS   E             30/01/09        2115.00                     2115.00  

      MI-002966            17/12/08  I               60990351      TS   E             30/01/09       31348.45                    31348.45  

      BG60531              17/12/08  I               60990384      TS   E             30/01/09          21.00                       21.00  

      BG61917              17/12/08  I               60990385 ANGR TS   E             30/01/09         590.52                      590.52  

      00000                30/07/04  I               70840001      TS   E             30/08/04                                             

                              Doc Curr: EUR                           Rate:     1.5000000                                                  

      /CODE

      In tha above example of a report I need to trap all the dated data which is no problem

      The data that begins Rate needs to be attached to the line above, which I partially managed, in some cases the Rate line is added to more than the one line above can this be done

       

      Using v9.1 Pro