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

3 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
  3. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle Technical Financials , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Oracle Technical Financials . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/

    ReplyDelete