0 Replies Latest reply on Aug 4, 2014 8:25 PM by Joe V

    Help with query on Project Balance

    Joe V

      Can someone please help me with the query to get this extract.  I would to get these fields linking PA_PROJECTS_ALL and GL_BALANCES.
      ( I might be wrong).. but I need these fields.

       

      Project | Account| Opening YTD | PTD Additions | PTD Capitalized | Closing YTD (Column C + Column D)

       

      where...

      PTD Additions (Column D) would be the sum of transfer from Projects to GL + Pre-accounted expenditure batches that do not have to be transferred)

      PTD Capitalized(Column F) : Capitalized during the Period (i.e. transferred to Fixed Assets).

       

      Thanks for you time and help.

      Joe.