4 Replies Latest reply: Aug 21, 2014 6:14 PM by Thanos A RSS

    clear Parent Currency

    2614987

      Hello - I am hoping someone would be able to help me answer this issue.  I only have data loaded and consolidated up to July.  However, there seems to be derived data for the future months.  I have removed all future period Fx rates as well.  I have loaded a statement below and consolidated Aug-Dec but it doesn't seem to work.  This only affects the P&L accounts for Parent Currency.  There is no data for Entity Currency.  Thanks.

       

      if HS.Value.Member = "<Parent Currency>" and HS.Year.Member > "2013" and HS.Period.Number > "7" then

               

       

                HS.Clear "A#All"

       

      End If

       

      End Sub