Understanding the A/R Delinquency Fee Journal Program

The system automatically runs these programs when you run the Delinquency Fees program (R03B525):

  • Delinquency Fee Journal Program (R03B22).

  • A/R Delinquency Fee Journal program (R74P3B22).

  • Late Payment Delinquency Fee program (R03B21).

The system reads the A/R Fee Journal History Detail table (F74P3B23) and generates a report that lists the standard information that the system includes in the report for the Delinquency Fee Journal program plus selected information from the F74P3B23 table.

This table describes the fields in the F74P3B23 table:

Heading

Descriptions

Included in R74P3B22 Report

Policy Number/Line Number

Lists the policy name used to determine the delinquency fee calculations and the line number if multiple lines for the policy are generated. The policy number appears in the standard report; the line number is specific to the Polish process.

Yes

Delinquency Fee Date Used (data item P74DBEG)

When using the 30-day rule method, the system calculates the beginning date on the latest of the invoice date, the shipment date, or the delivery date, plus 30 days.

This field contains a 1 if the beginning date of the calculation is based on the invoice date plus 30 days, contains 2 if the beginning date is based on the shipment date plus 30 days, and contains 3 if the beginning date is based on the delivery date plus 30 days.

Yes

Period Number (data item P74PN)

When using the 30-day rule method, the system indicates when more than one receipt is processed during the period for which an interest rate is effective. For the first receipt within the effective date range of an interest rate, the system writes 1 to this field, for the second receipt, the system writes 2, and so on.

No

Begin Period (data item P74BPE) and End Period (data item P74EPE)

When using the 30-day rule method, the system generates periods for each receipt in the date range and writes the beginning date and ending date that is used for the delinquency fee calculation.

Yes

Number of Rule (data item P74NRUL)

If the invoice has past due or open amounts that span more than one interest rate period (rule), the system indicates for which period the record is written.

The system writes 1 if the record is created for the first rule, writes 2 if the record is created for the second rule, and so on.

No

Date From Fee Calculated (data item P74FFC) and Date Thru Fee Calculated (data item P74TFC)

The system writes the beginning and ending dates for the period for which the fees are calculated.

Yes