ManPageW Dunning

From ADempiere ERP Wiki

Jump to: navigation, search

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Contents

Window: Dunning

Description : Maintain Dunning Levels

Help : The Dunning Window defines the parameters that will be used when generating Dunning Letters. Each customer can be associated with a Dunning Code.



Tab: Dunning

Description : Maintain Dunning Rules

Help : The Dunning Tab defines the parameters for a dunning level.

Table Name  : C_Dunning

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Default Default value The Default Checkbox indicates if this record will be used as a default value. IsDefault

CHAR(1)

YesNo

Send dunning letters Indicates if dunning letters will be sent The Send Dunning Letters checkbox indicates if dunning letters will be sent to Business Partners who use this dunning rule. SendDunningLetter

CHAR(1)

YesNo

Create levels sequentially Create Dunning Letter by level sequentially If selected, the dunning letters are created in the sequence of the dunning levels. Otherwise, the dunning level is based on the days (over)due. CreateLevelsSequentially

CHAR(1)

YesNo


Tab: Level

Description : Maintain Dunning Level

Help : The Dunning Level Tab defines the timing and frequency of the dunning notices.

Table Name  : C_DunningLevel

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Dunning Dunning Rules for overdue invoices The Dunning indicates the rules and method of dunning for past due payments. C_Dunning_ID

NUMBER(10)

TableDir

Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name

NVARCHAR2(60)

String

Description Optional short description of the record A description is limited to 255 characters. Description

NVARCHAR2(255)

String

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Days after due date Days after due date to dun (if negative days until due) The Days After Due Date indicates the number of days after the payment due date to initiate dunning. If the number is negarive, it includes not the not due invoices. DaysAfterDue

NUMBER(10)

Number

Show Not Due Show/print all invoices which are not due (yet). The dunning letter with this level incudes all not due invoices. IsShowNotDue

CHAR(1)

YesNo

Days between dunning Days between sending dunning notices The Days Between Dunning indicates the number of days between sending dunning notices. DaysBetweenDunning

NUMBER(10)

Integer

Show All Due Show/print all due invoices The dunning letter with this level incudes all due invoices. IsShowAllDue

CHAR(1)

YesNo

Charge fee Indicates if fees will be charged for overdue invoices The Charge Fee checkbox indicates if the dunning letter will include fees for overdue invoices ChargeFee

CHAR(1)

YesNo

Fee Amount Fee amount in invoice currency The Fee Amount indicates the charge amount on a dunning letter for overdue invoices. This field will only display if the charge fee checkbox has been selected. FeeAmt

NUMBER

Amount

Charge Interest Indicates if interest will be charged on overdue invoices The Charge Interest checkbox indicates if interest will be charged on overdue invoice amounts. ChargeInterest

CHAR(1)

YesNo

Interest in percent Percentage interest to charge on overdue invoices The Interest amount in percent indicates the interest to be charged on overdue invoices. This field displays only if the charge interest checkbox has been selected. InterestPercent

NUMBER

Number

Print Text The label text to be printed on a document or correspondence. The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. PrintName

NVARCHAR2(60)

String

Note Optional additional user defined information The Note field allows for optional entry of user defined information regarding this record Note

NVARCHAR2(2000)

Text

Dunning Print Format Print Format for printing Dunning Letters You need to define a Print Format to print the document. Dunning_PrintFormat_ID

NUMBER(10)

Table

Credit Stop Set the business partner to credit stop If a dunning letter of this level is created, the business partner is set to Credit Stop (needs to be manually changed). IsSetCreditStop

CHAR(1)

YesNo

Set Payment Term Set the payment term of the Business Partner If a dunning letter of this level is created, the payment term of this business partner is overwritten. IsSetPaymentTerm

CHAR(1)

YesNo

Payment Term The terms of Payment (timing, discount) Payment Terms identify the method and timing of payment. C_PaymentTerm_ID

NUMBER(10)

TableDir


Tab: Translation

Description : Dunning Level Translation

Help :

Table Name  : C_DunningLevel_Trl

Fields

Name Description Help Technical Data
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID

NUMBER(10)

TableDir

Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID

NUMBER(10)

TableDir

Dunning Level C_DunningLevel_ID

NUMBER(10)

TableDir

Language Language for this entity The Language identifies the language to use for display and formatting AD_Language

VARCHAR2

Table

Active The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive

CHAR(1)

YesNo

Print Text The label text to be printed on a document or correspondence. The Label to be printed indicates the name that will be printed on a document or correspondence. The max length is 2000 characters. PrintName

NVARCHAR2(60)

String

Note Optional additional user defined information The Note field allows for optional entry of user defined information regarding this record Note

NVARCHAR2(2000)

Text

Translated This column is translated The Translated checkbox indicates if this column is translated. IsTranslated

CHAR(1)

YesNo

Contributions

Personal tools