EditDate

Fiscal Date Edits +

Minor Business Rule

Object Name: X0903

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

Functional Description

Purpose
Edit the date passed to this function for PYEB (prior year end balance), PBCO (posted before cut
off), PACO (posted after cut off), and WACO (posted way after cut off).  Optionally return the fiscal
year, century and period number for the company and date passed in.

Setup Notes and Prerequisites

Special Logic

Technical Specification
• If Accounts Receivable (03), the current A/R begin fiscal year date and period is used.  If Accounts
Payable (04), the current A/P begin fiscal year date and period is used.  Otherwise, the current G/L
begin fiscal year date and period is used.
• If date passed is prior to current year, return PYEB.  If date passed is in current year, but prior
to current period, return PBCO.  If date passed is within current period or next period, no message is
returned.   If date passed is greater than next period end date, but less than or equal to period 14
end date of current year, return PACO.  If date passed is greater than next period end date, and
greater than period 14 end date of current year, return WACO.
• PACO and WACO are a WARNING only messages.  PBCO is a WARNING if constant is set to allow PBCO
posting, otherwise it is an error.  PYEB is a WARNING if document type is '##', otherwise it is an error.
• The error message number is returned as well as the type of warning, when applicable.  The type of
warnings are: 1 for PYEB, 2 for PBCO, 3 for PACO, and 4 for WACO.  In addition, you can choose to
suppress warnings by passing a '2', or choose to suppress errors and warnings by passing a '1'.
• Optionally you can have the fiscal period, fiscal year and century returned for the companied number
and date passed in.
• The date must fall within one of the Date Pattern records set up in F0008.

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	DGJ	JDEDATE	NONE	NONE
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the company to retrieve the appropriate fiscal period number, as well as to perform date validations.
szDocumentType	DCT	char	NONE	NONE
Special Input Expected If document type is not know, you may pass a blank in this field. However, PYEB is only allowed when document type is '##'. ^
szSystem	SY	char	NONE	NONE
Significant Data Values 03 - Accounts Receivable date edit 04 - Accounts Payable date edit blank - General Ledger date edit (default) ^
cSuppressFlag	EV01	char	NONE	NONE
Significant Data Values 1 - suppress all messages 2 - suppress only warning messages blank - do not suppress any messages ^
szErrorNumber	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cWarningType	EV02	char	NONE	NONE
Significant Data Values 1 - PYEB Warning 2 - PBCO Warning 3 - PACO Warning 4 - WACO Warning ^
mnReturnPeriodNumber	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.
mnReturnFiscalYear	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.
mnReturnCentury	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.
cFYPNFlag	EV03	char	NONE	NONE
Significant Data Values 1 - return fiscal year, century and period number blank - do not return fiscal year, century and period number

Data Structure

DXX00025 - Edit Date - PYEB, PBCO, PACO, WACO

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 DGJ JDEDATE NONE NONE

A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations.

szDocumentType DCT char NONE NONE

Special Input Expected
If document type is not know, you may pass a blank in this field.  However, PYEB is only allowed when
document type is '##'.
^

szSystem SY char NONE NONE

Significant Data Values
03    - Accounts Receivable date edit
04    - Accounts Payable date edit
blank - General Ledger date edit (default)

^

cSuppressFlag EV01 char NONE NONE

Significant Data Values
1     - suppress all messages
2     - suppress only warning messages
blank - do not suppress any messages

^

szErrorNumber DTAI char NONE NONE

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cWarningType EV02 char NONE NONE

Significant Data Values
1 - PYEB Warning
2 - PBCO Warning
3 - PACO Warning
4 - WACO Warning

^

mnReturnPeriodNumber 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.

mnReturnFiscalYear 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.

mnReturnCentury 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.

cFYPNFlag EV03 char NONE NONE

Significant Data Values
1     - return fiscal year, century and period number
blank - do not return fiscal year, century and period number

Related Functions

None

Related Tables

F0008 Date Fiscal Patterns

F0009 General Constants

F0010 Company Constants

ReturnDate
ReturnDate

Fiscal Date Edits +

Minor Business Rule

Object Name: X0903

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

4Functional Description

Purpose
Return the fiscal period end date for the company, period number, year, and century passed in.  The
date must be set up in the Date Pattern file (F0008).

Setup Notes and Prerequisites

Special Logic

Technical Specification

Data Structure

DXX00024 - Return Period End Date

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.

mnPeriodNumber 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.

mnFiscalYear 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.

jdPeriodEndDate DGJ JDEDATE NONE NONE

A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations.

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

F0008 Date Fiscal Patterns

F0009 General Constants

F0010 Company Constants

ReturnFYPN
ReturnFYPN

Fiscal Date Edits +

Minor Business Rule

Object Name: X0903

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

^

Data Structure

DXX00023 - Return Fiscal Yr and Period Number

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.

jdTransactionDate DGJ JDEDATE NONE NONE

A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
assign to the company record. The system compares the date that you enter on the transaction to the fiscal date pattern assigned to the
company to retrieve the appropriate fiscal period number, as well as to perform date validations.

mnReturnPeriodNumber 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.

mnReturnFiscalYear 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.

mnReturnCentury 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

F0008 Date Fiscal Patterns

F0009 General Constants

F0010 Company Constants

F0008 Date Fiscal Patterns
F0009 General Constants
F0010 Company Constants