BeyondERP.Newsletter
Menu

Setup step on the Vendor posting profiles page · Accounts payable

Define vendor posting profiles

Post vendor invoice and payment balances to the intended general ledger accounts.

Used by
Accounts payable manager, Auditor, Chief executive officer and 12 more roles
Business process
Process supplier invoices
Menu item
VendPosting
Main table
VendLedger
Data entity
VendorPostingProfileHeaderEntity
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 isA setup page for posting profiles that control how vendor transactions are posted to the general ledger, for all vendors, a vendor group or a single vendor.
What you do hereUse this page to assign the summary, settle, prepayment tax, arrival and offset accounts and settlement settings that apply when purchase orders, vendor invoices and payments are posted.
ExampleYou create two posting profiles, National and Foreign, to post vendor balances in the national currency and in a foreign currency to different accounts.
Vendor 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

Define vendor posting profiles1 screen

Post vendor invoice and payment balances to the intended general ledger accounts.

  1. Screen 1

    Create the vendor posting profile

    Go to Accounts payable > Setup > Vendor 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 payables
    Account codeAll
    Summary account210100
    Create the vendor posting profile (zoomed on the outlined fields)
    Show the full screenCreate the vendor posting profile
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Setup > Vendor posting profiles.
  2. Select New, then enter the Posting profile and Description.
  3. In the Setup section, select Add to add a line.
  4. Choose the Account code and, if needed, the Account/Group number.
  5. Enter the Summary account, Liquidity account for payments, Sales tax prepayments, Arrival and Offset account.
  6. Expand Table restrictions if you need them, or select Open Profile in Excel to work on the profile in Excel.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Account codeWhether the profile applies to one vendor (Table), a vendor group (Group), or all vendors (All).Microsoft Learn AllAccountCode
Summary accountThe ledger account used as the vendor balance account for the vendors in this profile.Microsoft Learn 210100SummaryLedgerDimension
ArrivalThe account that unapproved invoices from the invoice register post to.Microsoft Learn PurchasingLedgerDimension
Offset accountThe account that offsets unapproved invoices posted to the arrival account.Microsoft Learn PurchasingOffsetLedgerDimension
Sales tax prepaymentsThe account for sales tax on payments made in advance.Microsoft Learn VATPrepaymentsLedgerDimension
SettlementTurns on automatic settlement for transactions with this profile.Microsoft Learn Settlement
CloseThe posting profile a transaction changes to once it is fully settled.Microsoft Learn PostingProfileClose
Posting profileGENPostingProfile
DescriptionA short description of the vendor posting profile.Checked in Dynamics 365Standard trade payablesName

Test checklist

  1. Create the profile with an All row and the trade payables summary account.
  2. Post a vendor invoice and check the vendor balance posts to the summary account.
  3. Post an invoice register entry and check Arrival and Offset account are used, then approve it and check the debt moves to the summary account.
  4. Run the vendor balance against the ledger for the period and check they agree.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Define vendor posting profilesOne profile for trade payables with an All row as the fallback, plus Group rows only for vendor groups that need a different summary account, and a separate profile for prepaymentsPosting looks for the most specific row in the order Table, Group, All, so an All row guarantees every vendor finds a summary account. Learn uses separate profiles for cases such as foreign vs national balances and prepayments.Which vendors need different AP summary accounts or posting treatment?Assuming the All row wins when a more specific vendor or vendor-group row exists; Microsoft's lookup order is Table, Group, then All. A separate AP parameters action sets the default profile, and posting definitions can change the posting route.Test: AP baseline defaults flow from setup to invoice and payment
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: Changing a profile after posting affects future transactions and may require reconciliation of historical balances.
If you change it laterThe system uses the most specific profile it finds: one vendor first, then the vendor group, then all vendors. If you later remove a summary account from a profile, check the Do not allow manual entry setting on that main account. Microsoft Learn
Technical architect

6Technical

Menu itemVendPosting Checked in Dynamics 365
FormVendPosting Checked in Dynamics 365
TableVendLedgerShown as “Vendor posting profile” in Record infoKey field: PostingProfileChecked in Dynamics 365
Data entitiesVendorPostingProfileHeaderEntityVendor posting profile Microsoft data model
Who can open itPrivilegesMaintain vendor posting profiles VendPostingMaintainView vendor posting profiles VendPostingViewDutiesInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableReview general ledger process performance LedgerGeneralLedgerProcessPerfReviewInquire into purchase order to invoice policies PurchOrderToInvoicePoliciesInquireEnable purchase order to invoice process PurchOrderToInvoiceProcessEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnableInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
15 security rolesAuditor AuditPolicyManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManagerPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorRental manager RentalManagerPurchasing manager TradePurchasingManagerRental sales manager RentalSalesManagerTo use itChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantAuditor AuditPolicyManagerRental coordinator agent RentalCoordinatorAgentGive people one of these roles. On this system, 15 roles can open this page.Checked in Dynamics 365
Actions on the pageButtons: Open Profile in ExcelChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendPosting
Integrate withVendorPostingProfileHeaderEntity data entity Microsoft data model
Data migrationVendorPostingProfileHeaderEntity (Vendor posting profile): loaded for each company, in Microsoft's default template 120 - Accounts payable.Load order: Microsoft's default template 120 - Accounts payable loads Vendor posting profile at execution unit 1, level 120, sequence 45. 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 Bank)Microsoft Learn
Table definitionVendLedger columns and relations Microsoft data model
Everyone

8Sources

To cite this step: AP-SETUP-040, Define vendor posting profiles. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/AP-SETUP-040