F03B08EditFiscalDatePattern

F03B08 Edit Fiscal Date Pattern

Minor Business Rule

Object Name: B03B0121

Parent DLL: CFIN

Location: Client/Server

Language: C

B03B0121
F03B08 Edit Fiscal Date Pattern

Functional Description

Purpose
This function ensures that when a date pattern is added from P03B08, that it does not overlap any
date patterns that already exist for the current company.  It will check both Date Fiscal Year Begins and
Ending Date to determine this.  If any dates overlap, it will return a Found Flag = "1".

The condition selects records in the F03B08 where the DATE01 passed in is greater than the DTBG in
F03B08 and less than DTEN. If any records meet this condition, then the found flag is set to "1" and
returned.

Mathematically, this is represented as follows:

Begin DateDate passed inEnding Date
DTBG<Date01<DTEN

Setup Notes and Prerequisites

Special Logic

Technical Specifications

Parameters
Data ItemDescriptionI/OReqNotes
COCompanyIYes
DATE01DateIYesThis is the date
the fiscal year begins when called from the FC, and the ending date when called from the grid.
EV01Found FlagOYes
FYFiscal YearONo
PNPeriod No General LedgerONo
CTRYCenturyONo

Related Tables
F03B08Credit/Collection Date Pattern

Related Business Functions

Processing
Select all records in the F03B08 where:
Begin DateDate passed inEnding Date
DTBG<    Date01<DTEN

If a record is found, set FoundFlag = "1";
Else, return FoundFlag = "0";

^

Data Structure

D03B0121 - F03B08 Edit Date Patterns

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCompany	CO	char	NONE	NONE
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.
jdDate	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
FoundFlag	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnFiscalYear1	FY	MATH_NUMERIC	NONE	NONE
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.
mnPeriodNoGeneralLedge	PN	MATH_NUMERIC	NONE	NONE
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.
mnCentury	CTRY	MATH_NUMERIC	NONE	NONE
The calendar century associated with the year. Enter is the first two digits of the year. For example, 19 indicates any year beginning with 19 (1998, 1999), 20 indicates any year beginning with 20 (2000, 2001), and so on.

Related Functions

None

Related Tables

F03B08 Credit/Collection Date Pattern