Sunday, December 5, 2010

What is PTD, QTD and YTD in GL?

Your Ad Here



(period-to-date) is the period activity for the concerned period
Period_net_dr – period_net_cr

QTD (quarter-to-date) is
(Quarter_to_date_dr – Quarter_to_date_cr) + (period_net_dr- period_net_cr)

YTD (year-to-date) is
 (Begin-balance_dr- begin_balance_cr) + (period_net_dr- period_net_cr)

All below columns are stored in GL_BALANCES table with CCID and Period Name

period_net_cr
period_net_dr
quarter_to_date_dr
quarter_to_date_cr
begin_balance_dr
beging_balance_cr
Your Ad Here

2 comments:

  1. Hi.. This above is the Period Activity Balance..how to calculate the Beginning Balance for PTD, QTD and YTD?

    ReplyDelete
  2. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete