How to Compare Current PTD Actuals to Prior Year's PTD Actuals in an FSG report
Last updated on MAY 14, 2017
Applies to:Oracle General Ledger - Version 220.127.116.11 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
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms