BCE:811 Calculation Of MTD/QTD/YTD And Averages At The Beginning Of The New Fiscal Period (New Year) (Doc ID 2917892.1)

Last updated on DECEMBER 29, 2022

Applies to:

Goal

MTD,QTD,YTD balances (including LCY) should be calculated fresh when month/quarter/YEAR changes at the beginning of the new fiscal period without adding previous month/quarter/YEAR balance.  GL-Types "Asset","Liability","Owners Equity" MTD/QTD/YTD are getting calculated as

MTD/QTD/YTD of first day = (Debit-Credit of first day) + MTD/QTD/YTD of the last day of the previous month/quarter/YEAR.

For example:

If MTD/QTD/YTD on 31-DEC-22 is 50 and on 01-JAN-23 , debit is 5000 and credit is 0 then for
01-Jul
MTD=50+5000=5050
QTD=50+5000=5050
YTD=50+5000=5050

Since this is beginning of the month/quarter/Year the MTD/QTD/YTD should be only 5000.

Fiscal year starts on 01-Jan and ends on 31-Dec.
Q1 Jan to March
Q2 Apr to Jun
Q3 July to Sep
Q4 Oct to Dec

Same goes with MTD,QTD, YTD average balances as well (Including LCY). 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.