Table 92 "Customer Posting Group"
Base Application · Microsoft.Sales.Customer
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC2617 fields changed
- BC27unchanged
- BC281 procedures added
- BC29-30unchanged
Neighbourhood 42 connected objects and pages
Base Application · Microsoft.Sales.Customer · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 148 “Customer Posting Group Card” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Customer Posting Group |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Code Δ BC26 | Code[20] | Specifies the identifier for the customer posting group. This is what you choose when you assign the group to an entity or document. | NotBlank |
| 2 | Receivables Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post receivables from customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 7 | Service Charge Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post service charges for customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 8 | Payment Disc. Debit Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post payment discounts granted to customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 9 | Invoice Rounding Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post amounts that result from invoice rounding when you post transactions for customers. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 10 | Additional Fee Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post additional fees from reminders and finance charge memos for customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 11 | Interest Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post interest from reminders and finance charge memos for customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 12 | Debit Curr. Appln. Rndg. Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post rounding differences. These differences can occur when you apply entries in different currencies to one another. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 13 | Credit Curr. Appln. Rndg. Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post rounding differences. These differences can occur when you apply entries in different currencies to one another. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 14 | Debit Rounding Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post rounding differences from a remaining amount. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 15 | Credit Rounding Account Δ BC26 | Code[20] | Specifies the general ledger account to use when you post rounding differences from a remaining amount. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 16 | Payment Disc. Credit Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post reductions in payment discounts granted to customers in this posting group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 17 | Payment Tolerance Debit Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post payment tolerance and payments for sales. This applies to this particular combination of business group and product group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 18 | Payment Tolerance Credit Acc. Δ BC26 | Code[20] | Specifies the general ledger account to use when you post payment tolerance and payments for sales. This applies to this particular combination of business group and product group. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 19 | Add. Fee per Line Account Δ BC26 | Code[20] | Specifies the general ledger account that additional fees are posted to. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 20 | Description Δ BC26 | Text[100] | Specifies the description for the customer posting group. | |
| 21 | View All Accounts on Lookup Δ BC26 | Boolean | Specifies that all possible accounts are shown when you look up from a field. If the check box is not selected, then only accounts related to the involved account category are shown. |
Keys
- Key1: Code (clustered)
Events published
OnAfterGetReceivablesAccount(var CustomerPostingGroup: Record "Customer Posting Group"; var Result: Code[20])(integration): Raises an event after getting the receivables account to allow customization of the returned account.
Procedures
GetReceivablesAccount(): Code[20]: Gets the receivables G/L account for posting customer balances.GetPmtDiscountAccount(Debit: Boolean): Code[20]: Gets the payment discount G/L account for debit or credit postings.GetPmtToleranceAccount(Debit: Boolean): Code[20]: Gets the payment tolerance G/L account for debit or credit postings.GetRoundingAccount(Debit: Boolean): Code[20]: Gets the rounding G/L account for debit or credit postings.GetApplRoundingAccount(Debit: Boolean): Code[20]: Gets the application rounding G/L account for currency adjustments.GetInvRoundingAccount(): Code[20]: Gets the invoice rounding G/L account and validates its posting group.GetServiceChargeAccount(): Code[20]: Gets the service charge G/L account for posting finance charge service fees.GetAdditionalFeeAccount(): Code[20]: Gets the additional fee G/L account for posting reminder and finance charge fees.GetAddFeePerLineAccount(): Code[20]: Gets the additional fee per line G/L account for posting line-based reminder fees.GetInterestAccount(): Code[20]: Gets the interest G/L account for posting finance charge interest.SetAccountVisibility(var PmtToleranceVisible: Boolean; var PmtDiscountVisible: Boolean; var InvRoundingVisible: Boolean; var ApplnRoundingVisible: Boolean): Sets visibility flags for optional posting group account fields based on setup.
Plus 4 local procedures.
Triggers
OnDelete
Relations
- lookup page Page 110 “Customer Posting Groups”
- Add. Fee per Line Account: TableRelation Table 15 “G/L Account”
- Additional Fee Account: TableRelation Table 15 “G/L Account”
- Credit Curr. Appln. Rndg. Acc.: TableRelation Table 15 “G/L Account”
- Credit Rounding Account: TableRelation Table 15 “G/L Account”
- Debit Curr. Appln. Rndg. Acc.: TableRelation Table 15 “G/L Account”
- Debit Rounding Account: TableRelation Table 15 “G/L Account”
- Interest Account: TableRelation Table 15 “G/L Account”
- Invoice Rounding Account: TableRelation Table 15 “G/L Account”
- Payment Disc. Credit Acc.: TableRelation Table 15 “G/L Account”
- Payment Disc. Debit Acc.: TableRelation Table 15 “G/L Account”
- Payment Tolerance Credit Acc.: TableRelation Table 15 “G/L Account”
- Payment Tolerance Debit Acc.: TableRelation Table 15 “G/L Account”
- Receivables Account: TableRelation Table 15 “G/L Account”
- Service Charge Acc.: TableRelation Table 15 “G/L Account”
Referenced by
37 fields in 36 objects relate to this table (TableRelation or CalcFormula).
- Table 960 “Alt. Customer Posting Group”: Alt. Customer Posting Group, Customer Posting Group
- Table 110 “Sales Shipment Header”: Customer Posting Group
- Table 112 “Sales Invoice Header”: Customer Posting Group
- Table 114 “Sales Cr.Memo Header”: Customer Posting Group
- Table 1381 “Customer Templ.”: Customer Posting Group
- Table 1692 “Posted Bank Deposit Line”: Posting Group
- Table 18 “Customer”: Customer Posting Group
- Table 181 “Posted Gen. Journal Line”: Posting Group
- Table 21 “Cust. Ledger Entry”: Customer Posting Group
- Table 295 “Reminder Header”: Customer Posting Group
- Table 297 “Issued Reminder Header”: Customer Posting Group
- Table 30102 “Shpfy Shop”: Customer Posting Group
- Table 30152 “Shpfy Catalog”: Customer Posting Group
- Table 302 “Finance Charge Memo Header”: Customer Posting Group
- Table 304 “Issued Fin. Charge Memo Header”: Customer Posting Group
- Table 36 “Sales Header”: Customer Posting Group
- Table 379 “Detailed Cust. Ledg. Entry”: Posting Group
- Table 382 “CV Ledger Entry Buffer”: CV Posting Group
- Table 4405 “EXR Top Customer Report Buffer”: Customer Posting Group
- Table 4763 “Whse Demo Data Setup”: Cust. Posting Group
- Table 5107 “Sales Header Archive”: Customer Posting Group
- Table 5475 “Sales Invoice Entity Aggregate”: Customer Posting Group
- Table 5495 “Sales Order Entity Buffer”: Customer Posting Group
- Table 5505 “Sales Quote Entity Buffer”: Customer Posting Group
- Table 5507 “Sales Cr. Memo Entity Buffer”: Customer Posting Group
- Table 5802 “Value Entry”: Source Posting Group
- Table 5900 “Service Header”: Customer Posting Group
- Table 5990 “Service Shipment Header”: Customer Posting Group
- Table 5992 “Service Invoice Header”: Customer Posting Group
- Table 5994 “Service Cr.Memo Header”: Customer Posting Group
- Table 6010 “Service Header Archive”: Customer Posting Group
- Table 6660 “Return Receipt Header”: Customer Posting Group
- Table 751 “Standard General Journal Line”: Posting Group
- Table 81 “Gen. Journal Line”: Posting Group
- Table 83 “Item Journal Line”: Source Posting Group
- Table 86 “Exch. Rate Adjmt. Reg.”: Posting Group
Pages and codeunits on this table
- Page 110 “Customer Posting Groups” (source table)
- Page 148 “Customer Posting Group Card” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 48 “PostingSetupManagement” (10 calls:
GetAddFeePerLineAccount → LogCustPostingGroupFieldError,GetAdditionalFeeAccount → LogCustPostingGroupFieldError,GetApplRoundingAccount → LogCustPostingGroupFieldError, …) - Codeunit 570 “G/L Account Category Mgt.” (2 calls:
CheckGLAccount → CheckGLAccount,LookupGLAccount → LookupGLAccount)
Countries that replace it
AU, CA, ES, IT, MX, NZ, RU, US
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Customer Posting Group"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.