Table "Reminder Line"
Stores individual line items on a reminder document including overdue entries, text, and fees.
Properties
| Name | Value |
|---|---|
| Caption | Reminder Line |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Reminder No." | Code[20] | Specifies the reminder document to which this line belongs. |
| "Line No." | Integer | Specifies the sequential line number within the reminder document. |
| "Attached to Line No." | Integer | Specifies the line number to which this line is attached, such as for extended text. |
| Type | Enum Microsoft.Sales.Reminder."Reminder Source Type" | Specifies the type of content on this line: customer ledger entry, G/L account, text, or line fee. |
| "Entry No." | Integer | Specifies the customer ledger entry number that this reminder line references. |
| "No. of Reminders" | Integer | Specifies how many times the customer has been reminded about this entry. |
| "Posting Date" | Date | Specifies the posting date of the original document being reminded. |
| "Document Date" | Date | Specifies the document date of the original document being reminded. |
| "Due Date" | Date | Specifies the due date of the original document being reminded. |
| "Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Specifies the document type of the original entry, such as invoice or credit memo. |
| "Document No." | Code[20] | Specifies the document number of the original entry being reminded. |
| Description | Text[100] | Specifies a description of the reminder line content. |
| "Original Amount" | Decimal | Specifies the original amount of the document being reminded. |
| "Remaining Amount" | Decimal | Specifies the amount still owed on the document being reminded. |
| "No." | Code[20] | Specifies the number of the G/L account, standard text, or fee account for this line. |
| Amount | Decimal | Specifies the fee or interest amount calculated for this reminder line. |
| "Interest Rate" | Decimal | Specifies the interest rate percentage used to calculate finance charges on this line. |
| "Gen. Prod. Posting Group" | Code[20] | Specifies the general product posting group for VAT and cost allocation. |
| "VAT %" | Decimal | Specifies the VAT percentage applied to this line. |
| "VAT Calculation Type" | Enum Microsoft.Foundation.Enums."Tax Calculation Type" | Specifies how VAT is calculated for this line. |
| "VAT Amount" | Decimal | Specifies the VAT amount calculated for this line. |
| "Tax Group Code" | Code[20] | Specifies the tax group code for sales tax calculation. |
| "VAT Prod. Posting Group" | Code[20] | Specifies the VAT product posting group for determining VAT rates and accounts. |
| "VAT Identifier" | Code[20] | Specifies the VAT identifier for reporting and grouping VAT entries. |
| "Line Type" | Enum Microsoft.Sales.Reminder."Reminder Line Type" | Specifies the purpose of the line, such as beginning text, reminder line, or additional fee. |
| "VAT Clause Code" | Code[20] | Specifies a VAT clause code for special VAT treatments that must appear on documents. |
| "Applies-to Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Specifies the document type that the line fee applies to. |
| "Applies-to Document No." | Code[20] | Specifies the document number that the line fee applies to. |
| "Detailed Interest Rates Entry" | Boolean | Indicates whether this line contains detailed interest rate calculation information. |
| "System-Created Entry" | Boolean | Indicates whether this line was automatically created by the system during reminder generation. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
CalcFinanceCharge
Calculates the finance charge amount for this reminder line based on overdue days and interest terms.
procedure CalcFinanceCharge()GetReminderHeader
Retrieves the reminder header for this line and validates required fields.
procedure GetReminderHeader()GetCurrencyCodeFromHeader
Gets the currency code from the associated reminder header.
procedure GetCurrencyCodeFromHeader(): Code[10]Returns
| Type | Description |
|---|---|
| Code[10] |
The currency code from the header, or blank if not found. |
GetNoOfReminderForCustLedgEntry
Gets the number of reminders that have been issued for a customer ledger entry.
procedure GetNoOfReminderForCustLedgEntry(EntryNo: Integer): IntegerParameters
| Name | Type | Description |
|---|---|---|
| EntryNo | Integer |
The customer ledger entry number. |
Returns
| Type | Description |
|---|---|
| Integer |
The count of issued reminders for the entry. |
CumulateDetailedEntries
Calculates cumulative interest amount from detailed customer ledger entries.
procedure CumulateDetailedEntries(var CumAmount: Decimal; UseDueDate: Date; UseCalcDate: Date; UseInterestRate: Decimal; UseInterestPeriod: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| CumAmount | Decimal |
Returns the cumulative interest amount. |
| UseDueDate | Date |
The due date to use for calculation. |
| UseCalcDate | Date |
The calculation date to use. |
| UseInterestRate | Decimal |
The interest rate to apply. |
| UseInterestPeriod | Decimal |
The interest period in days. |
LookupDocNo
Opens a lookup page to select a document number from customer ledger entries.
procedure LookupDocNo()CalcFinanceChargeInterestRate
Calculates the applicable finance charge interest rate based on the date range and terms.
procedure CalcFinanceChargeInterestRate(var FinanceChargeInterestRate: Record "Finance Charge Interest Rate"; var UseDueDate: Date; var UseInterestRate: Decimal; var UseCalcDate: Date)Parameters
| Name | Type | Description |
|---|---|---|
| FinanceChargeInterestRate | Table Microsoft.Sales.FinanceCharge."Finance Charge Interest Rate" |
The finance charge interest rate record to use. |
| UseDueDate | Date |
Returns the due date to use for calculation. |
| UseInterestRate | Decimal |
Returns the interest rate to apply. |
| UseCalcDate | Date |
Returns the calculation date to use. |
CreateMulitplyInterestRateEntries
Creates additional reminder lines for multiple interest rate periods when rates change over time.
procedure CreateMulitplyInterestRateEntries(var ExtraReminderLine: Record "Reminder Line"; var FinanceChargeInterestRate: Record "Finance Charge Interest Rate"; var UseDueDate: Date; var UseInterestRate: Decimal; var UseCalcDate: Date; var CumAmount: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| ExtraReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The extra reminder line record to create. |
| FinanceChargeInterestRate | Table Microsoft.Sales.FinanceCharge."Finance Charge Interest Rate" |
The finance charge interest rate record. |
| UseDueDate | Date |
The due date to use for calculation. |
| UseInterestRate | Decimal |
The interest rate to apply. |
| UseCalcDate | Date |
The calculation date to use. |
| CumAmount | Decimal |
The cumulative amount for interest calculation. |
Events
OnAfterCopyFromCustLedgEntry
Raised after copying values from a customer ledger entry to the reminder line.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromCustLedgEntry(var ReminderLine: Record "Reminder Line"; CustLedgerEntry: Record "Cust. Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| CustLedgerEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
The source customer ledger entry. |
OnAfterCalcFinChrg
Raised after calculating the finance charge for the reminder line.
[IntegrationEvent(False,False)]
local procedure OnAfterCalcFinChrg(var ReminderLine: Record "Reminder Line"; var ReminderHeader: Record "Reminder Header")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
OnAfterFillLineWithGLAccountData
Raised after filling the reminder line with G/L account data.
[IntegrationEvent(False,False)]
local procedure OnAfterFillLineWithGLAccountData(var ReminderLine: Record "Reminder Line"; ReminderHeader: Record "Reminder Header"; GLAccount: Record "G/L Account")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| GLAccount | Table Microsoft.Finance.GeneralLedger.Account."G/L Account" |
The source G/L account record. |
OnAfterSetCustLedgEntryView
Raised after setting the view filters on customer ledger entry for lookup.
[IntegrationEvent(False,False)]
local procedure OnAfterSetCustLedgEntryView(ReminderHeader: Record "Reminder Header"; ReminderLine: Record "Reminder Line"; var CustLedgEntry: Record "Cust. Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| CustLedgEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
The customer ledger entry record with filters. |
OnBeforeCalcFinChrg
Raised before calculating the finance charge for the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeCalcFinChrg(var ReminderLine: Record "Reminder Line"; var ReminderHeader: Record "Reminder Header"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| IsHandled | Boolean |
Set to true to skip default calculation. |
OnBeforeLookupDocNo
Raised before the document number lookup on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeLookupDocNo(var ReminderLine: Record "Reminder Line"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| IsHandled | Boolean |
Set to true to skip default lookup. |
OnBeforeLookupEntryNo
Raised before the entry number lookup on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeLookupEntryNo(var ReminderLine: Record "Reminder Line"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| IsHandled | Boolean |
Set to true to skip default lookup. |
OnBeforeValidateDocumentNo
Raised before validating the document number on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateDocumentNo(var ReminderLine: Record "Reminder Line"; var xReminderLine: Record "Reminder Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| xReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The previous reminder line values. |
| CurrentFieldNo | Integer |
The current field number being validated. |
| IsHandled | Boolean |
Set to true to skip default validation. |
OnBeforeValidateDocumentType
Raised before validating the document type on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateDocumentType(var ReminderLine: Record "Reminder Line"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| IsHandled | Boolean |
Set to true to skip default validation. |
OnBeforeValidateEntryNo
Raised before validating the entry number on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateEntryNo(var ReminderLine: Record "Reminder Line"; var xReminderLine: Record "Reminder Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| xReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The previous reminder line values. |
| CurrentFieldNo | Integer |
The current field number being validated. |
| IsHandled | Boolean |
Set to true to skip default validation. |
OnCalcFinChrgOnAfterCalcShouldSkipCalcFinChrg
Raised after determining whether to skip finance charge calculation.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnAfterCalcShouldSkipCalcFinChrg(var ReminderLine: Record "Reminder Line"; var ReminderHeader: Record "Reminder Header"; var CustLedgerEntry: Record "Cust. Ledger Entry"; var ShouldSkipCalcFinChrg: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| CustLedgerEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
The customer ledger entry. |
| ShouldSkipCalcFinChrg | Boolean |
Indicates whether to skip calculation. |
OnCalcFinChrgOnBeforeValidatePostingGroups
Raised before validating posting groups during finance charge calculation.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnBeforeValidatePostingGroups(var ReminderLine: Record "Reminder Line"; var ReminderHeader: Record "Reminder Header"; var Amount: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| Amount | Decimal |
The calculated finance charge amount. |
OnValidateVATProdPostingGroupOnAfterVATPostingSetupGet
Raised after retrieving the VAT posting setup during VAT product posting group validation.
[IntegrationEvent(False,False)]
local procedure OnValidateVATProdPostingGroupOnAfterVATPostingSetupGet(var VATPostingSetup: Record "VAT Posting Setup"; ReminderLine: Record "Reminder Line")Parameters
| Name | Type | Description |
|---|---|---|
| VATPostingSetup | Table Microsoft.Finance.VAT.Setup."VAT Posting Setup" |
The VAT posting setup record. |
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
OnGetNoOfReminderForCustLedgEntryOnAfterReminderEntrySetFilters
Raised after setting filters on reminder entries when counting reminders for a customer ledger entry.
[IntegrationEvent(False,False)]
local procedure OnGetNoOfReminderForCustLedgEntryOnAfterReminderEntrySetFilters(var ReminderEntry: Record "Reminder/Fin. Charge Entry")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderEntry | Table Microsoft.Sales.FinanceCharge."Reminder/Fin. Charge Entry" |
The reminder/finance charge entry record with filters. |
OnBeforeGetNoOfReminderForCustLedgEntry
Raised before getting the number of reminders for a customer ledger entry.
[IntegrationEvent(False,False)]
local procedure OnBeforeGetNoOfReminderForCustLedgEntry(var ReminderLine: Record "Reminder Line"; var NoOfReminders: Integer; EntryNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| NoOfReminders | Integer |
Returns the number of reminders. |
| EntryNo | Integer |
The customer ledger entry number. |
| IsHandled | Boolean |
Set to true to skip default counting logic. |
OnAfterLookupDocNo
Raised after the document number lookup on the reminder line.
[IntegrationEvent(False,False)]
local procedure OnAfterLookupDocNo(var ReminderLine: Record "Reminder Line"; xRecReminderLine: Record "Reminder Line")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| xRecReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The previous reminder line values. |
OnCalcFinChrgOnBeforeCalcFinanceChargeInterestRate
Raised before calculating the finance charge interest rate.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnBeforeCalcFinanceChargeInterestRate(var ReminderLine: Record "Reminder Line"; var ReminderHeader: Record "Reminder Header"; var FinanceChargeTerms: Record "Finance Charge Terms"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
| ReminderHeader | Table Microsoft.Sales.Reminder."Reminder Header" |
The reminder header record. |
| FinanceChargeTerms | Table Microsoft.Sales.FinanceCharge."Finance Charge Terms" |
The finance charge terms record. |
| IsHandled | Boolean |
Set to true to skip default interest rate calculation. |
OnCalcFinChrgOnAfterDetailedCustLedgEntrySetFilters
Raised after setting filters on detailed customer ledger entries during finance charge calculation.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnAfterDetailedCustLedgEntrySetFilters(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; ReminderLine: Record "Reminder Line")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCustLedgEntry | Table Microsoft.Sales.Receivables."Detailed Cust. Ledg. Entry" |
The detailed customer ledger entry record with filters. |
| ReminderLine | Table Microsoft.Sales.Reminder."Reminder Line" |
The reminder line record. |
OnCalcFinChrgOnAfterReminderEntrySetFilters
Raised after setting filters on reminder/finance charge entries during finance charge calculation.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnAfterReminderEntrySetFilters(var ReminderFinChargeEntry: Record "Reminder/Fin. Charge Entry")Parameters
| Name | Type | Description |
|---|---|---|
| ReminderFinChargeEntry | Table Microsoft.Sales.FinanceCharge."Reminder/Fin. Charge Entry" |
The reminder/finance charge entry record with filters. |
OnCalcFinChrgOnAfterCalcInterest
Raised after calculating the interest amount during finance charge calculation.
[IntegrationEvent(False,False)]
local procedure OnCalcFinChrgOnAfterCalcInterest(var FinanceChargeTerms: Record "Finance Charge Terms"; var Amount: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| FinanceChargeTerms | Table Microsoft.Sales.FinanceCharge."Finance Charge Terms" |
The finance charge terms record. |
| Amount | Decimal |
The calculated interest amount. |
OnValidateAppliesToDocumentNoOnAfterCalcRemainingAmount
Raised after calculating the remaining amount during Applies-to Document No. validation.
[IntegrationEvent(False,False)]
local procedure OnValidateAppliesToDocumentNoOnAfterCalcRemainingAmount(var CustLedgerEntry: Record "Cust. Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| CustLedgerEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
The customer ledger entry with calculated remaining amount. |