B03B0049
F03B26 Get Notification Policy
Functional Description
Purpose
This business function will locate the proper policy based on the information passed in. If this
function locates a policy successfully, the flags associated with that policy will also be returned.
A notification policy is considered to be broken when the total late open amount is greater than the
minimum amount in the aging bucket being considered, and the total amount of the aging bucket being
considered and the older buckets is greater than the threshold percentage of the total late open amount.
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq? Notes
PLYPolicy NumberIYes
AG1Amount Aging Categories 1IYes
AG2Amount Aging Categories 2I Yes
AG3Amount Aging Categories 3IYes
AG4Amount Aging Categories 4IYes
AG5Amount Aging Categories 5IYes
AG6Amount Aging Categories 6IYes
AG7Amount Aging Categories 7IYes
LFCJDate Last Fee CalculatedIYes
DAGDate Age As OfIYes
LTNALetter NameONo
LTTYLetter TypeONo
STCLSend To CollectionsONo
CMARColl Mgr Approval ReqONo
NTCMNotify Collection ManagerONo
MACLCollection Mgr Review ReqONo
HDARAR Hold InvoicesONo
TSTATemporary Credit MessageONo
LNIDLine NumberONo
AIPRPriority Action ItemONo
AGCAging CategoryONo
EV01Create Notices FlagONo
Related Tables
F03B26A/R Delinquency Policy Notification
Related Business Functions
Processing
Return if the policy number is 0.
Calculate total open amount (add all amounts in each aging category).
If mnSubtotal is equal to 0, return with an error.
Calculate the number of days different between Date Last Fee Calculated and Date Age As Of and put
it in the mnDateDiff variable.
Select from F03B26 sorted by aging category.
While JDBReturn = JDEDB_PASSED and cOkFine = 'N',
If the total open amount is greater than the minimum amount in this policy (just fetched),
Last Fee Calculated is null,
If idReturnCode = ER_SUCCESS,
function.
cOkFine = 'Y'
I_D03B0049_B03B0049_AgingCalculation
Based on the aging category fetched from F03B26, total the amounts from that aging category and
older aging categories until the oldest aging category.
If the total amount is greater than the threshold percentage of the total open amount,
^
D03B0049 - F03B26 Get Notification Policy
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnPolicynumber | PLY | MATH_NUMERIC | NONE | NONE |
A number that the system assigns to each policy record to identify it. | ||||
mnAmtagingcategories1 | AG1 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the first category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtagingcategories2 | AG2 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the second category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtagingcategories3 | AG3 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the third category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtagingcategories4 | AG4 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fourth category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtagingcategories5 | AG5 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fifth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtagingcategories6 | AG6 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the sixth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtagingcategories7 | AG7 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
| ||||
jdDatelastfeecalculated | LFCJ | JDEDATE | NONE | NONE |
The most recent date on which the fees were calculated. The system uses this date for further fee calculations, by determining the number
| ||||
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
| ||||
szLettername | LTNA | char | NONE | NONE |
A field that identifies a predefined letter in the Letter Text table (F03B28). This field is case sensitive, so you must enter the letter name as it
| ||||
cLettertype | LTTY | char | NONE | NONE |
A code that is used to identify and organize the text that prints on statements or delinquency notices. The value that you specify must exist in
| ||||
cSendtocollections | STCL | char | NONE | NONE |
An option that specifies whether past-due invoices for the aging category or severity level specified are eligible for external collection.
| ||||
cCollectionmanagerapprovalrequ | CMAR | char | NONE | NONE |
An option in Fee Instructions and Notification Instructions that specifies the status that the system assigns to a delinquency fee or notice.
| ||||
cNotifycollectionmanager | NTCM | char | NONE | NONE |
An option that indicates whether you want the system to send a workflow message to the collection manager when an invoice becomes
| ||||
cCollectionmanagerreviewrequir | MACL | char | NONE | NONE |
An option that specifies whether to require the collection manager to review the customer's account when it has past-due amounts. Valid
| ||||
cArholdinvoices | HDAR | char | NONE | NONE |
An option that allows you to prevent anyone from entering invoices manually. Valid values are:
On
Hold invoices. The system issues an
| ||||
szTempcreditmessage | TSTA | char | NONE | NONE |
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
| ||||
mnLinenumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
cPriorityactionitem | AIPR | char | NONE | NONE |
A code that specifies the order in which the system displays activity messages that it generates when you run statements, notices, fees,
| ||||
cAgingcategory | AGC | char | NONE | NONE |
A number that represents an aging category or severity level depending on the setting of the Determine Severity Level processing option
| ||||
cCreateNoticationFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnGracePeriodDays | GPD | MATH_NUMERIC | OPT | NONE |
A number that the system adds to the invoice due date to extend it for collection purposes. Generally, you specify the number of days
| ||||
mnPayByDays | PBDY | MATH_NUMERIC | OPT | NONE |
The number of days to add to the aging date, which is defined in the processing options of the Credit Analysis Refresh program (R03B525),
| ||||
jdPayByDate | DTPB | JDEDATE | OPT | NONE |
The due date for the past-due invoices that print on the delinquency notice when you are using the Tiered Delinquency Notice Print
| ||||
cGlobalRemindersFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSeverityFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnTotalSentReminders | RMDS | MATH_NUMERIC | OPT | NONE |
This field specifies the number of delinquency notices that have been generated for an invoice pay item. | ||||
mnAmountOpen | AAP | MATH_NUMERIC | OPT | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
jdDateofLastSentReminderJU | RDDJ | JDEDATE | OPT | NONE |
The date of the most recent past-due notice to the customer. |
None |
F03B26 A/R Delinquency Policy Notification |