RetrieveUpdateARConstants

Retrieve/Update A/R Constants

Major Business Rule

Object Name: B03B0026

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function will Retrieve or Update the A/R constants by Company.

Setup Notes and Prerequisites
The cInquireorRevise flag will determine the mode of the function. 1 = Inquire, 0 = Revise.

Special Logic
None

Technical Specification



Parameters


ItemDescriptionI/OReq?Notes


DNLTcDeliquencyLetterI/ONDelinquency Notice (Y/N)


ATCScAutoCashI/ONAuto Receipt (Y/N)


STMTcPrintStatementynI/ONPrint Statement (Y/N)


ALGMszAutoCashAlgorithmI/ONAuto Receipt Algorighm Method


DAGjdDateAgeAsOfI/ONDate - Age as of


AGEMcAgingMethodI/ONAging method (1,2,3)


AGEcBaseAgingDateI/ONAging - Date Based On (I/D/G)


AGR1mnAgingDaysar001I/ONAging Days - A/R 1


AGR2mnAgingDaysar002I/ONAging Days - A/R 2


AGR3mnAgingDaysar003I/ONAging Days - A/R 3


AGR4mnAgingDaysar004I/ONAging Days - A/R 4


AGR5mnAgingDaysar005I/0NAging Days - A/R 5


AGR6mnAgingDaysar006I/0NAging Days - A/R 6


AGR7mnAgingDaysar007I/0NAging Days - A/R 7


EV01cInquireorReviseIYOneWorld Event Point01


COszCompanyIYCompany


CRDYmnAgingDaysarcurrentI/ONAging Days - A/R Current








Related Tables


F0010- Company Constants





Related Functions


B9800100Get Audit Information





Processing


If cInquireorRevise = 1 


 set the key to the F0010 table = szCompany


 Open the F0010 table


 If table not opened successfully


 Return ER_ERROR


 Fetch record from F0010 table


 If the record is fetched successfully


Load cDelinquencyLetter, cAutoCash, cPrintStatementym, cAgingMethod, cBaseAgingDate, 

szAutoCashalgorighm,  jdDateAgeAsOf, mnAgingDaysarcurrent and all of the aging days variables


    Else


 IdReturnCode1 = ER_ERROR


Else


 set the key to the F0010 table = szCompany


 Open the F0010 table


 If table not opened successfully


 Return ER_ERROR


 Else


Load the F0010 Columns with cDelinquencyLetter, cAutoCash, cPrintStatementym, 

cAgingMethod, cBaseAgingDate, szAutoCashalgorighm,  jdDateAgeAsOf, mnAgingDaysarcurrent and all of 

the aging days variables


Update the F0010 table


If the update is unsuccessful


 IdReturnCode1 = ER_ERROR

Data Structure

D03B0026 - Retrieve/Update A/R Constants

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

cDelinquencyLetter DNLT char NONE NONE

An option that specifies whether to print delinquency notices for the customer or company based on the notification instructions that are set
up for the policy that you assign to the customer. On Print delinquency notices. Off Do not print delinquency notices. Note: This option exists in
both the Customer Master Information program (P03013) and the Accounts Receivable Constants program (P0000). In the Accounts
Receivable Constants program, the option controls whether notices are printed for invoices that are entered for a specific company. In the Customer
Master Information program, the option controls whether notices are printed for a customer.

cAutoCash ATCS char NONE NONE

An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the
automatic receipt processing programs. On Receipts can be processed automatically for the customer or company. Off Receipts cannot be
processed automatically for the customer or company. The option must be activated for both the customer and the company in the Accounts
Receivable constants for the system to process automatic receipts.

cPrintStatementyn STMT char NONE NONE

An option that specifies whether to print statements for the customer or company. Valid settings are: On Print statements. Off Do not print
statements. Note: This option exists in both the Customer Master Information program (P03013) and the Accounts Receivable Constants program
(P0000). In the Accounts Receivable Constants program, the option controls whether statements are printed for invoices entered for a specific
company. In the Customer Master Information program, the option controls whether statements are printed for invoices entered for the
customer.

szAutoCashAlgorithm ALGM char NONE NONE

A code that specifies how receipts are applied during the batch receipts process.

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

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.

cBaseAgingDate AGE char NONE NONE

A code that specifies which date on the invoice record to use to calculate aging. The system compares the date specified on the invoice
record to the date entered in the Age as of Date field (DAG) to determine the aging, and then updates the aging category based on the method
specified in the Aging Method field (AGEM). Valid values are: I Invoice date D Due date G G/L date S Statement date

mnAgingdaysar001 AGR1 MATH_NUMERIC NONE NONE

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

mnAgingdaysar002 AGR2 MATH_NUMERIC NONE NONE

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

mnAgingdaysar003 AGR3 MATH_NUMERIC NONE NONE

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

mnAgingdaysar004 AGR4 MATH_NUMERIC NONE NONE

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

mnAgingdaysar005 AGR5 MATH_NUMERIC NONE NONE

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

mnAgingdaysar006 AGR6 MATH_NUMERIC NONE NONE

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

mnAgingdaysar007 AGR7 MATH_NUMERIC NONE NONE

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

cInquireorRevise EV01 char NONE NONE

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

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.

mnAgingdaysarcurrent CRDY MATH_NUMERIC NONE NONE

A value used in conjunction with the value of AGR1 to define the number of days in the current aging category.

Related Functions

B9800100 Get Audit Information

Related Tables

F0010 Company Constants

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cDelinquencyLetter	DNLT	char	NONE	NONE
An option that specifies whether to print delinquency notices for the customer or company based on the notification instructions that are set up for the policy that you assign to the customer. On Print delinquency notices. Off Do not print delinquency notices. Note: This option exists in both the Customer Master Information program (P03013) and the Accounts Receivable Constants program (P0000). In the Accounts Receivable Constants program, the option controls whether notices are printed for invoices that are entered for a specific company. In the Customer Master Information program, the option controls whether notices are printed for a customer.
cAutoCash	ATCS	char	NONE	NONE
An option that specifies whether a customer or company is eligible to process receipts in the Accounts Receivable system using the automatic receipt processing programs. On Receipts can be processed automatically for the customer or company. Off Receipts cannot be processed automatically for the customer or company. The option must be activated for both the customer and the company in the Accounts Receivable constants for the system to process automatic receipts.
cPrintStatementyn	STMT	char	NONE	NONE
An option that specifies whether to print statements for the customer or company. Valid settings are: On Print statements. Off Do not print statements. Note: This option exists in both the Customer Master Information program (P03013) and the Accounts Receivable Constants program (P0000). In the Accounts Receivable Constants program, the option controls whether statements are printed for invoices entered for a specific company. In the Customer Master Information program, the option controls whether statements are printed for invoices entered for the customer.
szAutoCashAlgorithm	ALGM	char	NONE	NONE
A code that specifies how receipts are applied during the batch receipts process.
jdDateAgeAsOf	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.
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.
cBaseAgingDate	AGE	char	NONE	NONE
A code that specifies which date on the invoice record to use to calculate aging. The system compares the date specified on the invoice record to the date entered in the Age as of Date field (DAG) to determine the aging, and then updates the aging category based on the method specified in the Aging Method field (AGEM). Valid values are: I Invoice date D Due date G G/L date S Statement date
mnAgingdaysar001	AGR1	MATH_NUMERIC	NONE	NONE
A value used in conjunction with CRDY and AGR2 to define the current and first aging categories.
mnAgingdaysar002	AGR2	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories.
mnAgingdaysar003	AGR3	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories.
mnAgingdaysar004	AGR4	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories.
mnAgingdaysar005	AGR5	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories.
mnAgingdaysar006	AGR6	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories.
mnAgingdaysar007	AGR7	MATH_NUMERIC	NONE	NONE
A value used in conjunction with AGR6 to define the sixth aging category.
cInquireorRevise	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
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.
mnAgingdaysarcurrent	CRDY	MATH_NUMERIC	NONE	NONE
A value used in conjunction with the value of AGR1 to define the number of days in the current aging category.