My Oracle Support Banner

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:

Oracle Financial Services Balance Computation Engine - Version 8.1.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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