FormatAgingColHdings

AR Aging - X0303

Minor Business Rule

Object Name: B03B0017

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

•
•
•
•

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cAgingmethod	AGEM	char	NONE	NONE
A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of Date field (DAG) and the value specified in the Date Aging Based On field (AGE) to calculate the aging for each invoice, and then assigns them to the aging category specified by this code. Valid codes are: 1 Aging days. The system assigns invoices to the aging categories specified in the Aging Days fields. The aging categories are user defined. 2 Fiscal periods. The system uses the fiscal periods defined by the date pattern assigned to the company record as the aging categories. 3 Calendar. The system uses each calendar month as an aging category.
mnTotalnumberofcolumns	NCOL	MATH_NUMERIC	NONE	NONE
Shows the total number of columns that are present in the current table.
mnBeginningAgingCategorydays	AGR8	MATH_NUMERIC	NONE	NONE
The specified number of days for the Accounts Receivable aging report.
mnCurrentAgingdays	AGR8	MATH_NUMERIC	NONE	NONE
The specified number of days for the Accounts Receivable aging report.
mnAgingDaysCategory1	AGR1	MATH_NUMERIC	NONE	NONE
A value used in conjunction with CRDY and AGR2 to define the current and first aging categories.
mnAgingDaysCategory2	AGR2	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories.
mnAgingDaysCategory3	AGR3	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories.
mnAgingDaysCategory4	AGR4	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories.
mnAgingDaysCategory5	AGR5	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories.
mnAgingDaysCategory6	AGR6	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories.
mnAgingDaysCategory7	AGR7	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR6 to define the sixth aging category.
szHeading1	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading2	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading3	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading4	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading5	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading6	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading7	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading8	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
szHeading9	VC30A	char	NONE	NONE
This is a generic field used as a work field in Everest.
cReturnedAgingCategory	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
jdWrkDateDAG1	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG2	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG3	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG4	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG5	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG6	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG7	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdWrkDateDAG8	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdDateAsOf	DATE01	JDEDATE	NONE	NONE
Event point for JDE Date.
jdDateForAging	DAG	JDEDATE	NONE	NONE
A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the invoice date, statement date, due date, or G/L date, which is defined by the value in the Date Aging Based On field (AGE), and then uses the value in the Aging Method field (AGEM) to determine which aging category to update. If you use method 1, the aging categories are defined in the Aging Days fields (CRDY, AGR1, AGR2, AGR3, AGR4, AGR5, AGR6, and AGR7) in the Accounts Receivable constants. If you leave this field blank, the system uses the current date. Note: The Sales Order Management system also uses this date for credit checks. Leave this field blank to ensure that the credit checks are always current.

•

•
•

•

•

•

•

•

•
•
•

•

•

•
•
•

•

•
•

•

•

•

•

•
•

•

Data Structure

D03B0017 - AR Aging - X0303

Parameter Name Data Item Data Type Req/Opt I/O/Both

cAgingmethod AGEM char NONE NONE

A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of
Date field (DAG) and the value specified in the Date Aging Based On field (AGE) to calculate the aging for each invoice, and then assigns
them to the aging category specified by this code. Valid codes are: 1 Aging days. The system assigns invoices to the aging categories
specified in the Aging Days fields. The aging categories are user defined. 2 Fiscal periods. The system uses the fiscal periods defined by the date
pattern assigned to the company record as the aging categories. 3 Calendar. The system uses each calendar month as an aging category.

mnTotalnumberofcolumns NCOL MATH_NUMERIC NONE NONE

Shows the total number of columns that are present in the current table.

mnBeginningAgingCategorydays AGR8 MATH_NUMERIC NONE NONE

The specified number of days for the Accounts Receivable aging report.

mnCurrentAgingdays AGR8 MATH_NUMERIC NONE NONE

The specified number of days for the Accounts Receivable aging report.

mnAgingDaysCategory1 AGR1 MATH_NUMERIC NONE NONE

A value used in conjunction with CRDY and AGR2 to define the current and first aging categories.

mnAgingDaysCategory2 AGR2 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories.

mnAgingDaysCategory3 AGR3 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories.

mnAgingDaysCategory4 AGR4 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories.

mnAgingDaysCategory5 AGR5 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories.

mnAgingDaysCategory6 AGR6 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories.

mnAgingDaysCategory7 AGR7 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR6 to define the sixth aging category.

szHeading1 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading2 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading3 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading4 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading5 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading6 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading7 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading8 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading9 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

cReturnedAgingCategory EV01 char NONE NONE

An option that specifies the type of processing for an event.

jdWrkDateDAG1 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG2 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG3 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG4 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG5 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG6 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG7 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG8 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdDateAsOf DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdDateForAging DAG JDEDATE NONE NONE

A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
invoice date, statement date, due date, or G/L date, which is defined by the value in the Date Aging Based On field (AGE), and then uses the
value in the Aging Method field (AGEM) to determine which aging category to update. If you use method 1, the aging categories are defined in
the Aging Days fields (CRDY, AGR1, AGR2, AGR3, AGR4, AGR5, AGR6, and AGR7) in the Accounts Receivable constants. If you leave this
field blank, the system uses the current date. Note: The Sales Order Management system also uses this date for credit checks. Leave this
field blank to ensure that the credit checks are always current.

Related Functions

B0000041 Return Period End Dates

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

Related Tables

F0010 Company Constants

SelectAgingCategoryforTrans
SelectAgingCategoryforTrans

AR Aging - X0303

Minor Business Rule

Object Name: B03B0017

Parent DLL: CALLBSFN

Location: Client/Server

Language: C

B03B0017
F0010 Get Aging Categories for Transactions

Functional Description

Purpose
This function can be used to determine which aging category (bucket) a transaction falls into.
The calling application should pass in  an Aging Method ('1' - Days, '2' - Fiscal Periods, '3' -
Calendar Months) and a transaction date.
If using method '1',  pass in Aging Category Days and an As Of Date.
If using method '2' or '3', and the heading format function has already been called, pass in the
Aging Category Dates it returned. Save the Aging Category Dates returned from this function, and pass them
back in - unchanged - on subsequent calls.

The caller can choose which transaction date to use in the comparison - either the invoice date, GL
date, due date, or statement date, and pass in the appropriate - non zero - value.

Setup Notes and Prerequisites
Ensure all mandatory parameters are passed to the function, and the necessary fiscal periods are
defined when aging by fiscal periods.

Special Logic
This function will return cReturnedAgingCategory indicating which Aging Category a transaction
belongs to. Possible values are:
'F' - Future
'0' - Current
'1' -Category 1
'2' -Category 2
'3' -Category 3
'4' -Category 4
'5' -Category 5
'6' -Category 6
'7' -doesn't belong to any of the above categories

Technical Specifications

Parameters
ItemDescriptionI/OReq?Notes
AGEM   cAgingmethodI
NCOL   mnTotalnumberofcolumnsI
DATE01 jdDateAsOfIYes
DAG    jdDateForAgingIYes
AGR8   mnBeginningAgingCategorydaysI
AGR8   mnCurrentAgingdaysI
AGR1   mnAgingDaysCategory1I
AGR2   mnAgingDaysCategory2I
AGR3   mnAgingDaysCategory3I
AGR4   mnAgingDaysCategory4I
AGR5   mnAgingDaysCategory5I
AGR6   mnAgingDaysCategory6I
AGR7   mnAgingDaysCategory7I
VC30A  szHeading1Not Used
VC30A  szHeading2Not Used
VC30A  szHeading3Not Used
VC30A  szHeading4Not Used
VC30A  szHeading5Not Used
VC30A  szHeading6Not Used
VC30A  szHeading7Not Used
VC30A  szHeading8Not Used
VC30A  szHeading9Not Used
EV01   cReturnedAgingCategoryO
DATE01 jdWrkDateDAG1I
DATE01 jdWrkDateDAG2I
DATE01 jdWrkDateDAG3I
DATE01 jdWrkDateDAG4I
DATE01 jdWrkDateDAG5I
DATE01 jdWrkDateDAG6I
DATE01jdWrkDateDAG7I
DATE01jdWrkDateDAG8I

Related Tables
F0010Company Constants

Related Business Functions
B0000041Return Period End Dates
X0005Get User Defined Codes
X0903Fiscal Date Edits

Processing
• If processing aging by Fiscal or Calendar
•
Check if dates have been loaded by FormatAgingColHdings, if not run now.
• Compare date for aging to the dates and load flag if date falls within.

• else
•
If this is a future trans

•
Load future flag

•
else

•
Determine the number of aging categories the caller provided
• Start by defaulting in the last possible category
• Compare days difference to aging categories

• Return ER_SUCCESS

Data Structure

D03B0017 - AR Aging - X0303

Parameter Name Data Item Data Type Req/Opt I/O/Both

cAgingmethod AGEM char NONE NONE

A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of
Date field (DAG) and the value specified in the Date Aging Based On field (AGE) to calculate the aging for each invoice, and then assigns
them to the aging category specified by this code. Valid codes are: 1 Aging days. The system assigns invoices to the aging categories
specified in the Aging Days fields. The aging categories are user defined. 2 Fiscal periods. The system uses the fiscal periods defined by the date
pattern assigned to the company record as the aging categories. 3 Calendar. The system uses each calendar month as an aging category.

mnTotalnumberofcolumns NCOL MATH_NUMERIC NONE NONE

Shows the total number of columns that are present in the current table.

mnBeginningAgingCategorydays AGR8 MATH_NUMERIC NONE NONE

The specified number of days for the Accounts Receivable aging report.

mnCurrentAgingdays AGR8 MATH_NUMERIC NONE NONE

The specified number of days for the Accounts Receivable aging report.

mnAgingDaysCategory1 AGR1 MATH_NUMERIC NONE NONE

A value used in conjunction with CRDY and AGR2 to define the current and first aging categories.

mnAgingDaysCategory2 AGR2 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories.

mnAgingDaysCategory3 AGR3 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories.

mnAgingDaysCategory4 AGR4 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories.

mnAgingDaysCategory5 AGR5 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories.

mnAgingDaysCategory6 AGR6 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories.

mnAgingDaysCategory7 AGR7 MATH_NUMERIC NONE NONE

A value used in conjunction with AGR6 to define the sixth aging category.

szHeading1 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading2 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading3 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading4 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading5 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading6 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading7 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading8 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

szHeading9 VC30A char NONE NONE

This is a generic field used as a work field in Everest.

cReturnedAgingCategory EV01 char NONE NONE

An option that specifies the type of processing for an event.

jdWrkDateDAG1 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG2 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG3 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG4 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG5 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG6 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG7 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdWrkDateDAG8 DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdDateAsOf DATE01 JDEDATE NONE NONE

Event point for JDE Date.

jdDateForAging DAG JDEDATE NONE NONE

A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
invoice date, statement date, due date, or G/L date, which is defined by the value in the Date Aging Based On field (AGE), and then uses the
value in the Aging Method field (AGEM) to determine which aging category to update. If you use method 1, the aging categories are defined in
the Aging Days fields (CRDY, AGR1, AGR2, AGR3, AGR4, AGR5, AGR6, and AGR7) in the Accounts Receivable constants. If you leave this
field blank, the system uses the current date. Note: The Sales Order Management system also uses this date for credit checks. Leave this
field blank to ensure that the credit checks are always current.

Related Functions

B0000041 Return Period End Dates

X0005 Get User Defined Codes

X0903 Fiscal Date Edits +

Related Tables

F0010 Company Constants

B0000041 Return Period End Dates
X0005 Get User Defined Codes
X0903 Fiscal Date Edits +