Kindly see below given scenario to understand how Trial balance calculated.
YTD: Year to Date
PTD: Period to Date
QTD: Quarter to Date
Opening Balance: This is balance amount which is carry
forward from previous month/year.
E.g. for Jan-16 opening balance will be Dec-15 closing
balance. For account 12345 Dec-15 closing balance is 1000 then it will be
opening balance for Jan-16 trial balance YTD Report.
|
Opening Balance
|
1000
|
||
|
Month
|
Debit
|
Credit
|
Total
|
|
Jan-16
|
500
|
300
|
200
|
|
Feb-16
|
800
|
500
|
300
|
|
Mar-16
|
1200
|
700
|
500
|
When we run trial balance with below given parameter.
1) PTD
Period Type: PTD
Period Name: Mar-16
Trial Balance for account 12345 will be 500
2) QTD
Period Type: QTD
Period Name: Mar-16
QTD Trial Balance for account 12345 will be sum of balances
for all month in Mar-16 quarter (i.e. 1st quarter)
Total balance (QTD): Jan-16 + Feb-16 +Mar-16
Total balance (QTD): 200+300+500=1000
3) YTD
Period Type: YTD
Period Name: Mar-16
YTD Trial Balance for account 12345 will be sum of beginning
balance with till date balance for the year.
Opening Balance: Jan-16 Opening Balance + Jan-16 TB + Feb-16
TB
Opening Balance: 1000+200+300=1500
Total balance (YTD): Opening Balance + Current Month Balance
(Mar-16) PTD
Total balance (YTD): 1500+500=2000
ReplyDeleteHello Everyone,
Hope you all are doing good.
I have one requirement to load all the History Data till date through Report script for auditing purpose.
So basically it should populate all the data when the cube was loaded.
Below is the script,so in ROW section,i have mentioned "Feb-2017".So instead of hard coding for every month and year,I want to automate it so that it can fetch all the history data till date.Please help.Thanks in advance !
//ESS_LOCALE English_UnitedStates.Latin1@Binary
{DECIMAL 2} {SUPBRACKETS} {NOINDENTGEN } {ROWREPEAT} {SUPMISSINGROWS} {MISSINGTEXT "0.00"} {SUPZEROROWS}
{SUPHEADING} {SUPCOMMAS} {TABDELIMIT} <SUPSHARE
<PAGE("SalesChannel","LineOfBusiness","SRC_TYPE","Products")
"REPORTING CHANNEL"
"NOT REPORTED"
"SRC_SYS"
<ROW("Scenario_Src","Period")
//&CM
"Feb-2017"
// Selection rules and output options for Scenario_Src
{OUTMBRNAMES}
<Link (<GEN("Products","Gen2,Products") AND NOT <IDESCENDANTS ("ALT_Cricket"))
<Link (<LEV("Scenario_Src", "Lev0,Scenario_Src") AND <DESCENDANTS ("ACT"))
<Link( <CHILDREN("PRIMLOB"))
"INITADD"
"MRRCSCMIGAIN"
"MRRCSCMIGAOUT"
"NOIREC"
"NOIDIS"
// Selection rules and output options for MEASURES
!
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Project Portfolio Management Cloud. Actually, I was looking for the same information on internet for
ReplyDeleteOracle PPM Cloud Training and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle Cloud Applications
.
how to get calculate YTD in oracle Financials BI report ? can anyone help on this?
ReplyDelete