Table "Customer Posting Group"
Defines G/L account mappings for customer transactions including receivables and discounts.
Properties
| Name | Value |
|---|---|
| Caption | Customer Posting Group |
| LookupPageID | Page Microsoft.Sales.Customer."Customer Posting Groups" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| Code | Code[20] | Specifies the unique identifier for the customer posting group. |
| "Receivables Account" | Code[20] | Specifies the G/L account for posting accounts receivable transactions from customers in this group. |
| "Service Charge Acc." | Code[20] | Specifies the G/L account for posting service charges applied to customers in this group. |
| "Payment Disc. Debit Acc." | Code[20] | Specifies the G/L account for posting payment discount debit amounts granted to customers in this group. |
| "Invoice Rounding Account" | Code[20] | Specifies the G/L account for posting invoice rounding adjustments for customers in this group. |
| "Additional Fee Account" | Code[20] | Specifies the G/L account for posting additional fees from reminders and finance charge memos. |
| "Interest Account" | Code[20] | Specifies the G/L account for posting interest charges from reminders and finance charge memos. |
| "Debit Curr. Appln. Rndg. Acc." | Code[20] | Specifies the G/L account for posting debit rounding differences when applying entries in different currencies. |
| "Credit Curr. Appln. Rndg. Acc." | Code[20] | Specifies the G/L account for posting credit rounding differences when applying entries in different currencies. |
| "Debit Rounding Account" | Code[20] | Specifies the G/L account for posting debit rounding differences from remaining amounts. |
| "Credit Rounding Account" | Code[20] | Specifies the G/L account for posting credit rounding differences from remaining amounts. |
| "Payment Disc. Credit Acc." | Code[20] | Specifies the G/L account for posting payment discount credit amounts when discounts are reduced. |
| "Payment Tolerance Debit Acc." | Code[20] | Specifies the G/L account for posting payment tolerance debit amounts for sales transactions. |
| "Payment Tolerance Credit Acc." | Code[20] | Specifies the G/L account for posting payment tolerance credit amounts for sales transactions. |
| "Add. Fee per Line Account" | Code[20] | Specifies the G/L account for posting per-line additional fees from reminders. |
| Description | Text[100] | Specifies a description for the customer posting group to help identify its purpose. |
| "View All Accounts on Lookup" | Boolean | Indicates whether all G/L accounts are shown in lookups, or only those related to the relevant account category. |
| 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
GetReceivablesAccount
Gets the receivables G/L account for posting customer balances.
procedure GetReceivablesAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The receivables account code. |
GetPmtDiscountAccount
Gets the payment discount G/L account for debit or credit postings.
procedure GetPmtDiscountAccount(Debit: Boolean): Code[20]Parameters
| Name | Type | Description |
|---|---|---|
| Debit | Boolean |
True to get the debit account, false for credit account. |
Returns
| Type | Description |
|---|---|
| Code[20] |
The payment discount account code. |
GetPmtToleranceAccount
Gets the payment tolerance G/L account for debit or credit postings.
procedure GetPmtToleranceAccount(Debit: Boolean): Code[20]Parameters
| Name | Type | Description |
|---|---|---|
| Debit | Boolean |
True to get the debit account, false for credit account. |
Returns
| Type | Description |
|---|---|
| Code[20] |
The payment tolerance account code. |
GetRoundingAccount
Gets the rounding G/L account for debit or credit postings.
procedure GetRoundingAccount(Debit: Boolean): Code[20]Parameters
| Name | Type | Description |
|---|---|---|
| Debit | Boolean |
True to get the debit account, false for credit account. |
Returns
| Type | Description |
|---|---|
| Code[20] |
The rounding account code. |
GetApplRoundingAccount
Gets the application rounding G/L account for currency adjustments.
procedure GetApplRoundingAccount(Debit: Boolean): Code[20]Parameters
| Name | Type | Description |
|---|---|---|
| Debit | Boolean |
True to get the debit account, false for credit account. |
Returns
| Type | Description |
|---|---|
| Code[20] |
The application rounding account code. |
GetInvRoundingAccount
Gets the invoice rounding G/L account and validates its posting group.
procedure GetInvRoundingAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The invoice rounding account code. |
GetServiceChargeAccount
Gets the service charge G/L account for posting finance charge service fees.
procedure GetServiceChargeAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The service charge account code. |
GetAdditionalFeeAccount
Gets the additional fee G/L account for posting reminder and finance charge fees.
procedure GetAdditionalFeeAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The additional fee account code. |
GetAddFeePerLineAccount
Gets the additional fee per line G/L account for posting line-based reminder fees.
procedure GetAddFeePerLineAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The additional fee per line account code. |
GetInterestAccount
Gets the interest G/L account for posting finance charge interest.
procedure GetInterestAccount(): Code[20]Returns
| Type | Description |
|---|---|
| Code[20] |
The interest account code. |
SetAccountVisibility
Sets visibility flags for optional posting group account fields based on setup.
procedure SetAccountVisibility(var PmtToleranceVisible: Boolean; var PmtDiscountVisible: Boolean; var InvRoundingVisible: Boolean; var ApplnRoundingVisible: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| PmtToleranceVisible | Boolean |
Returns whether payment tolerance accounts should be visible. |
| PmtDiscountVisible | Boolean |
Returns whether payment discount accounts should be visible. |
| InvRoundingVisible | Boolean |
Returns whether invoice rounding account should be visible. |
| ApplnRoundingVisible | Boolean |
Returns whether application rounding accounts should be visible. |
Events
OnAfterGetReceivablesAccount
Raises an event after getting the receivables account to allow customization of the returned account.
[IntegrationEvent(False,False)]
local procedure OnAfterGetReceivablesAccount(var CustomerPostingGroup: Record "Customer Posting Group"; var Result: Code[20])Parameters
| Name | Type | Description |
|---|---|---|
| CustomerPostingGroup | Table Microsoft.Sales.Customer."Customer Posting Group" |
The customer posting group record. |
| Result | Code[20] |
The receivables account code that can be modified. |