ManPageW Dunning
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
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 |
