BeyondERP.Newsletter
Menu

Setup step on the Commission posting page · Sales and marketing

Set up Commission posting

Use this page to post commission amounts to an expense account and offset them to a payable account.

Used by
Accounts payable clerk, Accounts payable manager, Collections manager and 13 more roles
Business process
Calculate and pay sales commissions in Dynamics 365 Finance
Menu item
CommissionPosting
Main table
InventPosting
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 where you choose the ledger accounts that commission amounts are posted to (Commission) and offset to (Commission offset), per item, item group or all items and per customer, customer group or all customers.
What you do hereUse this page to post commission amounts to an expense account and offset them to a payable account.
ExampleFor example, BEAT posts all commission to expense account 618100 and offsets it to payable account 231200, so a 2.00 percent commission of 120.00 on invoice INV-004512 debits 618100 and credits 231200.
Commission posting 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 Commission posting1 screen

Use this page to post commission amounts to an expense account and offset them to a payable account.

  1. Screen 1

    Set the account for commission expense

    Go to Sales and marketing > Commissions > Commission posting

    1. Under Select, choose Commission
    2. Select New
    3. Leave Item code and Account code as All, or narrow them to a group or a single item or customer
    4. Select the main account for the commission expense
    5. Select Save
    6. Choose Commission offset and add the offset (payable) account the same way
    1SelectCommission
    2Main account610100
    Item codeAll
    Account codeAll
    Set the account for commission expense (zoomed on the outlined fields)
    Show the full screenSet the account for commission expense
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Sales and marketing > Commissions > Commission posting.
  2. Under Select, choose Commission.
  3. Select New and set Item code and Account code (for example All and All), then the expense Main account.
  4. Under Select, choose Commission offset and add the same combination with the payable Main account.
  5. Invoice a sales order with commission and check the voucher.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
SelectChooses which posting the rows are for: Commission (the account the commission amount is posted to, typically an expense account) or Commission offset (the offsetting account, typically a payable account).Microsoft Learn Commission
Item codeWhether the row applies to one item (Table), a group of items (Group) or all items (All).Checked in Dynamics 365AllItemCode
Account codeWhether the row applies to one customer (Table), a group of customers (Group) or all customers (All).Checked in Dynamics 365AllCustVendCode
Main accountThe ledger account that the commission, or its offset, posts to.Microsoft Learn 618100LedgerDimension

Common errors and fixes

MessageWhat to do
Invoicing fails for a sales order that has commissions to pay.Set up commission posting rows for both Commission and Commission offset that cover the order's item and customer. Microsoft Learn

Test checklist

  1. Set up commission posting rows for the expense and the payable (offset) accounts.
  2. Invoice a sales order that matches a Commission calculation row.
  3. Open the invoice voucher and check the commission is debited to the expense account and credited to the payable account.
  4. In a test company without commission posting rules, check that invoicing the same kind of order fails.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Commission postingPost commission amounts to a dedicated expense account, offset to a dedicated payable account.Learn says commission amounts are typically posted to a dedicated expense account and offset to a dedicated payable account, so commission cost and the amount owed to sales staff stay visible in the ledger.Without commission posting rules, invoicing fails for any sales order that has commissions to pay.Test: Commission posts to the expense and payable accounts

Feature management and licence

Licence or add-inOn the live system, Accounting manager, Accounting supervisor and the rental managers (maintain), and Sales manager and the accounts receivable roles (use) use this page.

Checked in Dynamics 365

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: Posting rules are read when an invoice with commission is posted. A change affects later invoices; posted vouchers stay on the old accounts.
If you change it laterWithout commission posting rules, invoicing fails for any sales order that has commissions to pay. Microsoft Learn
Technical architect

6Technical

Menu itemCommissionPosting Checked in Dynamics 365
FormInventPosting Checked in Dynamics 365
TableInventPostingShown as “Item, ledger posting” in Record infoKey field: InventAccountTypeChecked in Dynamics 365
Who can open itPrivilegesMaintain setup of commission postings CommissionPostingMaintainView setup of commission postings CommissionPostingViewDutiesInquire into sales commissions master CustInvoiceSalesCommissionsInquireEnable general ledger process LedgerGeneralLedgerProcessEnableEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
16 security rolesCollections manager CollectionLetterCollectionsManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManagerSales manager TradeSalesManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental manager RentalManagerRental sales manager RentalSalesManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerTo use itSales manager TradeSalesManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 16 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=CommissionPosting
Data migrationLoad order: Commission posting has no data entity in Data management that is named for this page: no entity is listed for it in the live Data management list, and the ledger posting definition entities built on its table (InventPosting) are named for inventory, procurement, production, sales and standard cost variance posting. Enter the Commission and Commission offset rows on the page in each legal entity.Checked in Dynamics 365
Table definitionInventPosting columns and relations Microsoft data model
Everyone

8Sources