Sunday, December 5, 2010

What is PTD, QTD and YTD in GL?



(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
Posted by at

2 comments:

  1. Mithun AcharOctober 28, 2015 at 9:56 PM

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

    ReplyDelete
  2. AnonymousMay 19, 2017 at 1:28 PM

    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

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)