How to Compare Current PTD Actuals to Prior Year's PTD Actuals in an FSG report (Doc ID 1050478.6)

Last updated on MAY 14, 2017

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Executable:RGRARG - Financial Statement Generator
Form:RGXAUCP.FMB - AutoCopy
Form:RGXGDAXS.FMB - Define Axis Set ( Row Set and Column Set Definition)
Form:RGXGDCON.FMB - Content Set
Form:RGXGDORD.FMB - Define Row Order

Goal

You would like to know how to design a Financial Statement Generator (FSG) report that includes:

-- A column for the Actuals for each period in your calendar year, up to the reporting period.

-- A column for the current year's period-to-date (PTD) actual totals

-- A column for last year's period-to-date actual totals

-- A column for the variance between this year's PTD and last year's PTD totals.

For example, if your accounting year is Jan through Dec and your reporting period is May 1998, then the current year period-to-date actual total would include the Actuals for the periods Jan through May 1998.

Therefore, your report would include the columns: Jan'98 ...... May'98, This Year's PTD totals, Last Year's PTD totals, and Variance between This Year & Last Year's PTD totals

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms