BeyondERP.Newsletter
Menu

Setup step on the Customer posting profiles page · Accounts receivable

Set up Customer posting profiles

Set up the posting profiles that control how customer transactions are posted to the general ledger.

Used by
Accounts receivable clerk, Accounts receivable manager, Auditor and 18 more roles
Business process
Define posting profiles in Dynamics 365 Finance
Menu item
CustPosting
Main table
CustLedger
Data entity
CustCustomerPostingProfileHeaderEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isCustomer posting profiles control how customer transactions post to the general ledger, assigning ledger accounts and document settings to all customers, a customer group or a single customer.
What you do hereUse it to define the summary (Accounts receivable trade) account and related accounts, plus settlement, interest and collection letter settings, applied to invoices, payment journals, collection letters and interest notes.
ExampleYou could create two posting profiles: one that posts customer balances in the national currency to one account and another for balances in a foreign currency; organizations taking prepayments often add a separate prepayment profile.
Customer posting profiles page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Customer posting profiles1 screen

Set up the posting profiles that control how customer transactions are posted to the general ledger.

  1. Screen 1

    Create the customer posting profile

    Go to Accounts receivable > Setup > Customer posting profiles

    1. Select New and enter the posting profile and description
    2. On the Setup FastTab, select Add
    3. Set Account code to All and enter the summary account
    1Posting profileBEAT
    DescriptionStandard trade receivables
    Account codeAll
    Summary account120100
    Create the customer posting profile (zoomed on the outlined fields)
    Show the full screenCreate the customer posting profile
    page title tab to open what to set or check

How to use it

  1. Go to Accounts receivable > Setup > Customer posting profiles.
  2. Select New to add a profile, or select a profile in the list and select Edit.
  3. Fill in the Posting profile and Description.
  4. In the Setup section, select Add and pick an Account code.
  5. Enter the Summary account and any other accounts you need, such as Liquidity account for payments or Sales tax prepayments.
  6. Select Remove to take a setup line away.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Posting profileThe code of the posting profile, for example one for national and one for foreign currency balances.Microsoft Learn GENPostingProfile
Account codeWhether the profile applies to one customer (Table), a customer group (Group), or all customers (All).Microsoft Learn AllAccountCode
Account/Group numberThe customer or customer group the profile applies to; left blank for All.Microsoft Learn Num
Summary accountThe Accounts receivable trade main account that customer balances post to.Microsoft Learn 120100SummaryLedgerDimension
Liquidity account for paymentsThe account used for cash flow forecasts; it appears only when cash flow forecasts are turned on.Microsoft Learn ClearingLedgerDimension
Sales tax prepaymentsThe account for sales tax on payments received in advance.Microsoft Learn VATPrepaymentsLedgerDimension
Liabilities for discount accountThe ledger account for liabilities of discount.Microsoft Learn LiabilitiesForDiscountLedgerDimension
Collection letter sequenceThe collection letter sequence used for customers on this profile.Microsoft Learn CollectionLetterCourse
Interest codeThe interest code used to calculate interest for customers on this profile.Microsoft Learn InterestCode
SettlementTurns on automatic settlement for transactions with this profile.Microsoft Learn Settlement
Collection letterWhether collection letters are generated for customers on this profile.Microsoft Learn CollectionLetter
CloseThe posting profile a transaction moves to once it is fully settled.Microsoft Learn PostingProfileClose
DescriptionA short text that describes the posting profile line.Microsoft Learn Standard trade receivablesName

Test checklist

  1. Create the profile with an All row and the receivables summary account, and Settlement switched on.
  2. Post a customer invoice and check the balance posts to the summary account.
  3. Post a payment for the customer and check it settles automatically if Settlement is on.
  4. Run Customer to ledger reconciliation for the period with Differences only and check it is empty.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Customer posting profilesOne profile for trade receivables with an All row as the fallback, Group rows only where a customer group needs a different summary account, and a separate prepayment profilePosting looks for the most specific row (Table, Group, All), so an All row guarantees every customer finds a summary account. Learn recommends a second profile for prepayments.How many customer posting profiles do you need?Changing the summary account after customers have posted: subledger and ledger get out of balance and posted transactions are not moved.Test: Customer posting profile search order
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: Posted transactions keep their accounts; a change needs reconciliation and possibly adjusting entries.
If you change it laterDuring posting the most specific profile wins: a profile for the customer first, then one for the customer's group, then one for all customers. Microsoft Learn
Technical architect

6Technical

Menu itemCustPosting Checked in Dynamics 365
FormCustPosting Checked in Dynamics 365
TableCustLedgerShown as “Customer posting profiles” in Record infoKey field: PostingProfileChecked in Dynamics 365
Data entitiesCustCustomerPostingProfileHeaderEntityCustomer posting profiles Microsoft data model
Who can open itPrivilegesMaintain customer posting profiles CustPostingMaintainView customer posting profiles CustPostingViewDutiesInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableReview general ledger process performance LedgerGeneralLedgerProcessPerfReviewInquire into invoice and cash policies RentalCustInvInvoiceAndCashPolInquirEnable invoice and cash process RentalCustInvoiceInvAndCashProcEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnableInquire into quotation to sales order policies RentalSalesQuotationToSlsOrdPoliciesInquireEnable quotation to sales order process RentalSalesQuotationToSlsOrdProcessEnableInquire into quotation to sales order policies SalesQuotationToSalesOrderPolInquireEnable quotation to sales order process SalesQuotationToSalesOrderProcessEnable
21 security rolesAuditor AuditPolicyManagerCollections manager CollectionLetterCollectionsManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental representative RentalRepresentativeRental sales manager RentalSalesManagerRetail service RetailServiceSales manager TradeSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 21 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CustPosting
Integrate withCustCustomerPostingProfileHeaderEntity data entity Microsoft data model
Data migrationCustCustomerPostingProfileHeaderEntity (Customer posting profiles): loaded for each company, in Microsoft's default template 140 - Accounts receivable.Load order: Microsoft's default template 140 - Accounts receivable loads Customer posting profiles at execution unit 1, level 140, sequence 30. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Tax)Microsoft Learn
Table definitionCustLedger columns and relations Microsoft data model
Everyone

8Sources

To cite this step: AR-SETUP-120, Set up Customer posting profiles. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/AR-SETUP-120