CalculatePeriodFiscalYearOffsets

Calculate Period and Fiscal Year Offsets

Minor Business Rule

Object Name: B8300001

Parent DLL: CAEC

Location: Client/Server

Language: C

Functional Description
Calculates a target period number and fiscal year based upon any offsets to the fiscal year or period
number. Will return the prior fiscal year relative to the baseline fiscal year if the
cCalculatePriorFiscalYear is passed as a '1'. Determines whether to use the processing option values or the Financial
Reporting Date from the F0010 as the reports baseline date. Can use the Financial Reporting Date or
the 52 Period Financial Reporting date based upon the cUse52PeriodDates parameter. Returns all AAI GLG
items required to perform sign reversal and account balance calculations.
Purpose
Provide target period and fiscal year, GLG AAI's, and normal number of periods to the Financial
Reporting smart field functions.
Setup Notes and Prerequisites

Special Logic

Technical Specification
Fetch company driven data from the CompanyInfoCache.

If procesing option period or date are blank use the Financial Reporting Date or the 52 Period
Reporting Date.

If cProcessingMode is = '1', calculate the target fiscal year and period number using the baseline
date and any fiscal year offset. Blank in fiscal year indicates no offsets.

If cProcessingMode is = '2', calculate the target fiscal year and period number using both the period
number and fiscal year offsets.

Return target period number and fiscal year, normal number of periods, and GLG AAI's.

^

Data Structure

D8300001 - Calculate Period and Fiscal Year Offsets

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cProcessingMode	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szBCCompany	CO	char	OPT	INPUT
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
mnPOPeriodNumber	PN	MATH_NUMERIC	OPT	INPUT
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the preparation of financial reports.
szPOFiscalYear	FYOW	char	OPT	INPUT
A four-digit number that identifies the fiscal year. You can enter a number in this field or leave the field blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 2005, and ends September 30, 2006. The end of the first period is October 31, 2005. Specify the year 2005 rather than 2006.
szLTPeriodNumberOffset	PNOF	char	OPT	INPUT
The period number on which you want to base this column. Do one of the following actions: leave the field blank to use the current period, enter a specific period number, such as 6, or enter a number that is an offset to the current period number, such as +1 or -1.
szLTFiscalYearOffset	FYOF	char	OPT	INPUT
The fiscal year on which you want to base this column. Do one of the following actions: leave the field blank to use the current period, enter the last two digits of a specific fiscal year, such as 98, or enter a number that is an offset to the current fiscal year, such as +1 or -1.
mnBCFiscalYear	FY	MATH_NUMERIC	OPT	INPUT
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
iBucketPosition	INT01	integer	OPT	OUTPUT
Number of Days in Future to Query for Responses Due.
mnTargetFiscalYear	FY	MATH_NUMERIC	OPT	OUTPUT
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
szBegPL	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
szEndPL	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
szBegBS	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
szEndBS	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
cCalculatePriorFiscalYear	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
mnTargetFiscalYearLessOne	FY	MATH_NUMERIC	OPT	OUTPUT
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal year (as defined on the Company Setup form). Specify the year at the end of the first period rather than the year at the end of the fiscal period. For example, a fiscal year begins October 1, 1998 and ends September 30, 1999. The end of the first period is October 31, 1998. Specify the year 98 rather than 99.
cUse52PeriodDates	EV03	char	OPT	INPUT
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX, and IZ types. Or, select Derivative Lots Only to display only those transactions that may have created new derivative lot.
mnNormalNumberPeriods	MATH07	MATH_NUMERIC	OPT	OUTPUT
Event point for Math Numeric.
szBeginCOGS	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
szBeginOtherExpense	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
szBeginOtherIncome	DESC	char	OPT	OUTPUT
A description, remark, name, or address.
cFiscalDatePattern	DTPN	char	OPT	OUTPUT
A code that identifies date patterns. You can use one of 15 codes. You must set up special codes (letters A through N) for 4-4-5, 13-period accounting, or any other date pattern unique to your environment. An R, the default, identifies a regular calendar pattern.

Related Functions

B83GETCO Get Company Information - (Financial Reporting)

Related Tables

None