EAAutoGenerateREFineDoc

This document was generated using Claude.ai

Overview

Automatically generates fine documents for overdue real estate payments. Finds committed contracts with unpaid installments past their due dates (considering grace periods) and creates or updates fine documents with calculated penalties based on late days and configured fine rates.

When This Action Runs

Manual execution or scheduled batch processing for penalty calculation. Typically used monthly to generate fines for overdue rental payments, sales installments, and other real estate payment obligations that have exceeded their grace periods.

How It Works

Parses fine parameters - Extracts fine calculation settings from parameters
Identifies contract types - Determines which contract types to process (default: all real estate contracts)
Finds overdue payments - Queries for committed contracts with unpaid amounts past due date minus grace period
Fetches existing fines - Retrieves previously generated fines for the current month to update or replace
Processes each contract - Creates or updates fine documents in separate transactions
Calculates penalties - Computes fine amounts based on late days, rates, and outstanding amounts
Commits fine documents - Saves new fine documents with proper references and dimensions
Cleans up old fines - Deletes previously generated fines that are no longer needed

Parameters

Parameter 1: Fields Map (Required) - Field mapping for fine document creation (e.g., book="RF1", term="RFINE")

Parameter 2: Grace Period (Optional) - Number of days after due date before fines apply (default: 0)

Parameter 3: Add Grace Period To Fine (Optional) - true/false to include grace period in late days calculation (default: false)

Parameter 4: Fine Is Value Not Percent (Optional) - true for fixed amount, false for percentage (default: false)

Parameter 5: Fine Per (Required) - Time unit for fine calculation: "year", "month", or "day"

Parameter 6: Fine Percent/Value (Required) - Fine rate as percentage or fixed amount

Parameter 7: Fine Calculation Query (Optional) - Custom SQL query for complex fine calculations

Parameter 8: Contracts To Search In CSV (Optional) - Comma-separated contract types to process

Default Contract Types

RESalesDoc - Real estate sales documents
REOpeningSales - Opening sales documents
RERentContract - Rental contracts
REOpeningRentContract - Opening rental contracts

Fine Calculation Logic

Fine = Base Amount × Rate × Time Factor

Where:

Base Amount: Outstanding payment amount (or fixed value if configured)
Rate: Fine percentage or fixed amount from parameter 6
Time Factor: Late days adjusted by fine period (day=1, month=days/30, year=days/360)

Custom Query Variables

Custom fine calculation queries can use these variables:

{finePercent} - Fine percentage rate
{lateDays} - Number of days payment is overdue
{contract.fieldName} - Any field from the contract entity

Database Tables Affected

REFineDoc - Creates or updates fine documents
FineInstallmentLine - Creates detail lines for each overdue installment
Contract Tables - Reads payment details from various contract types (read-only)
Payment Lines - References overdue installments (read-only)

Important Warnings

⚠️ Grace Period Logic

Grace period subtracts days from due date comparison
Add grace period to fine determines if grace days count toward penalty calculation
May cause confusion if both settings don't align with business rules