N03B0084
Delinquency Notice Processing
Functional Description
Purpose
This function writes the A/R Notification History (F03B20) record, and kick off a procedure to write
the A/R Notification History Detail (F03B21) records.
Setup Notes and Prerequisites
All of the data structure fields should be passed as the data is available. If the data is not
available, then it will have to be fetched from the proper source.
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
PLYPolicy NumberIYes
AGR1Aging Days A/R 001IYes
AGR2Aging Days A/R 002IYes
AGR3Aging Days A/R 003IYes
AGR4Aging Days A/R 004IYes
AGR5Aging Days A/R 005IYes
AGR6Aging Days A/R 006IYes
AGR7Aging Days A/R 007IYes
AGR8Aging Days A/R 008INoNot used at this time
CRDYAging Days AR CurrentIYes
CURRCurrent Amount DueIYes
AG1Amt. Aging Categories 1IYes
AG2Amt. Aging Categories 2 IYes
AG3Amt. Aging Categories 3IYes
AG4Amt. Aging Categories 4IYes
AG5Amt. Aging Categories 5IYes
AG6Amt. Aging Categories 6IYes
AG7Amt. Aging Categories 7IYes
AG8Amt. Aging Categories 8INoNot used at this time
DDJDate DueINo
LFCJDate Last Fee CalculatedIYes
DAGDate Age As OfIYes
AN8Address NumberIYes
COCompanyIYes
RAN8Remit to AddressINo
AGEMAging MethodINo
MODEProcessing ModeIYes
RNIDBatch Run IDIYes
STMPPAR Statement ProcessingINo
VERARVersionINo
DFEEAmount Delinquency FeesINo
NBR1No. Sent RemindersONo
DLQJDate - Last Dunning LetterI No
CLMGCollection ManagerINo
VC08AWhich RemittoI No
Related Tables
F03B20A/R Notification History
F03B21A/R Notification History Detail
F03B26A/R Delinquency Policy Notification
F0010Company Constants
F0101Address Book Master
Related Business Functions
B03B0049F03B26 Get Notification Policy
B03B0166F03B20 Fetch Next Unique ID
B9800100Get Audit Info
B0000128Retrieve Company Currency Code
B03B0112F03B21 Write Notification Detail
B03B0111Create Cache Table
Processing
Run F03B26 Get Notification Policy to get notification policy information
If the Delinquency Notices flag (output from F03B26 Get Notification Policy) is a 1.
Run Get Audit Information
If Process Mode is a 0 (Proof Mode), assign a 4 (proof) to the Notification Approval (NAPR)
If Process Mode is a 1 (Final Mode) and the Manager Approval Required flag (in the notification
policy) is a 1 (required), assign a 1 (pending) to the NAPR
If Process Mode is a 1 and the Manager Approval Required flag is not a 1 (not required), assign a
2 (approved) to the NAPR. (NAPR is a field in F03B20)
If System Currency is on
If Which Remitto is not blank and equal to A,B,C,D,E,F
assigned to the Remit To Address field when F03B20 is written
To Address field when F03B20 is written
If the Which Remitto is blank, the Address Number of the Company will be assigned to the Remit
To Address field when F03B20 is written
Insert a F03B20 record
Run F03B21 Write Notification Details to insert a F03B21 record
D03B0084 - Delinquency Notice Processing
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. | ||||
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. | ||||
mnAgingDaysar008 | AGR8 | MATH_NUMERIC | NONE | NONE |
The specified number of days for the Accounts Receivable aging report. | ||||
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. | ||||
mnCurrentAmountDue | CURR | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the current aging category as defined in either the Accounts Receivable constants or the
| ||||
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
| ||||
mnAmtAgingCategories8 | AG8 | MATH_NUMERIC | NONE | NONE |
The amount retained on your books for the number of days indicated by the category number. The system automatically computes aging
| ||||
jdDateDue | DDJ | JDEDATE | NONE | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
| ||||
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
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
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
| ||||
mnRemitToAddressNumber | RAN8 | MATH_NUMERIC | NONE | NONE |
An Address Number that the system uses when the customer requests shipments to a variety of locations across the country but wants to
| ||||
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
| ||||
cProcessingMode | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
mnBatchRunID | RNID | MATH_NUMERIC | NONE | NONE |
This is an internally assigned number that groups transaction records with a batch header record based on a particular execution of the G/L
| ||||
szARStatementProcessing | STMPP | char | NONE | NONE |
The program selected to produce the statement or delinquency notice. | ||||
szVersion99 | VERAR | char | NONE | NONE |
The version of the statement print program that was used to print statements. The system uses the print program and version specified to
| ||||
mnAmountDelinquencyFees | DFEE | MATH_NUMERIC | NONE | NONE |
The total amount of the delinquency fee invoice records (RF). The system displays this information from either the A/R Statistical Summary
| ||||
mnNoSentReminders1 | NBR1 | MATH_NUMERIC | NONE | NONE |
The total number of delinquency notices that were sent to a customer. | ||||
jdDateLastDunningLetterJul | DLQJ | JDEDATE | NONE | NONE |
The date of the last deliquency notice that was sent to the customer. The system displays this information from either the A/R Statistical
| ||||
szCollectionManager | CLMG | char | NONE | NONE |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
szWhichRemitto | VC08A | char | OPT | NONE |
This is a generic field used as a work field. | ||||
mnAmountGross | AG | MATH_NUMERIC | OPT | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
mnAmountCurrency | ACR | MATH_NUMERIC | OPT | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
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
| ||||
szUBEName | KY | char | OPT | NONE |
A list of valid codes for a specific user defined code list. | ||||
cAgingCategory | AGC | char | OPT | NONE |
A number that represents an aging category or severity level depending on the setting of the Determine Severity Level processing option
| ||||
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. | ||||
mnTotalAmountOpen | AAP | MATH_NUMERIC | OPT | NONE |
The amount of an invoice or voucher pay item that is unpaid. | ||||
cAgingBasedOnDate | AGE | char | OPT | INPUT |
A code that specifies which date on the invoice record to use to calculate aging. The system compares the date specified on the invoice
|
None |
None |