BeyondERP.Subscribe

Setup page · Tax

Ledger posting groups

A setup page for ledger posting groups, which control the main accounts that sales tax is posted to automatically.

Used by
Accounts payable manager, Accounts receivable manager, Accountant and 5 more roles
Business process
Develop tax strategy
Menu item
TaxAccountGroup
Main table
TaxLedgerAccountGroup
Data entity
TaxPostingGroupEntityV2
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isA setup page for ledger posting groups, which control the main accounts that sales tax is posted to automatically.
What you do hereUsed to set the payable, receivable, use tax and settlement accounts for the sales tax codes the group is attached to.
ExampleFor example, a company can use one ledger posting group for all its sales tax codes, or set up a separate group for each sales tax code.
Ledger posting groups page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business processDefine accounting policies › Develop tax strategy
Menu pathTax › Setup › Sales tax › Ledger posting groups
Set up firstMain accounts Microsoft Learn ↗
Used next bySales tax codes Microsoft Learn ↗
Related pages—

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Ledger posting groups1 screen

Used to set the payable, receivable, use tax and settlement accounts for the sales tax codes the group is attached to.

  1. Screen 1

    Create the ledger posting group

    Go to Tax > Setup > Sales tax > Ledger posting groups

    1. Select New, and enter the Ledger posting group and Description
    2. Select the Sales tax payable and Sales tax receivable accounts
    3. Select the Settlement account
    4. Select Save
    1Ledger posting groupBEAT-ST
    2Sales tax payable230100
    3Sales tax receivable230100
    4Settlement account230100
    Create the ledger posting group (zoomed on the outlined fields)
    Show the full screenCreate the ledger posting group
    page title tab to open what to set or check

Microsoft's steps

  1. Go to Tax > Setup > Sales tax > Ledger posting groups.
  2. Select New.
  3. In the Ledger posting group field, enter a value, and in the Description field, enter a description.
  4. In the Sales tax payable field, select the account for tax payable to the authority.
  5. In the Sales tax receivable field, select the account for tax paid to vendors.
  6. In the Use tax expense and Use tax payable fields, select the use tax accounts, if used.
  7. In the Settlement account field, select the account where the net tax balance is posted at settlement.
  8. Optionally, select the Vendor cash discount and Customer cash discount accounts.
  9. Select Save.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Sales tax payableThe account for outgoing sales tax that is payable to the tax authority.Microsoft Learn ↗230100TaxOutgoingLedgerDimension
Sales tax receivableThe account for sales tax paid to vendors; not available when Apply sales tax taxation rules is on.Microsoft Learn ↗230100TaxIncomingLedgerDimension
Use tax expenseThe account for deductible use taxes that vendors don't claim, such as EU reverse charge.Microsoft Learn ↗—TaxUseTaxLedgerDimension
Use tax payableThe account for use taxes that are payable to tax authorities.Microsoft Learn ↗—TaxOffsetUseTaxLedgerDimension
Settlement accountThe account where the net tax balance is posted at settlement, unless the authority is linked to a vendor.Microsoft Learn ↗230100TaxReportLedgerDimension
Vendor cash discountOptional account for cash discount on these sales tax codes; if blank, the account on Cash discount codes is used.Microsoft Learn ↗—CashDiscountIncomingLedgerDimension
Ledger posting group—BEAT-ST—

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Ledger posting groups——

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it laterChanging the accounts in a ledger posting group affects only transactions that haven't been posted yet. Microsoft Learn ↗

Technical architect

6Technical

Menu itemTaxAccountGroup Checked in Dynamics 365
FormTaxAccountGroup Checked in Dynamics 365
TableTaxLedgerAccountGroupShown as “Ledger posting groups” in Record infoKey field: TaxAccountGroupChecked in Dynamics 365
Data entitiesTaxPostingGroupEntityV2Sales tax ledger posting groups V2 Microsoft data model ↗
Who can open itPrivilegesMaintain sales tax ledger posting groups TaxAccountGroupMaintainView sales tax ledger posting groups TaxAccountGroupViewDutiesRental Inquire into sales tax process reference data RentalTaxSalesTaxProcessReferenceDataInquireEnable sales taxes process TaxSalesTaxesProcessEnableInquire into sales tax process reference data TaxSalesTaxProcessReferenceDataInquire
8 security rolesAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental manager RentalManagerRental purchasing manager RentalPurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=TaxAccountGroup
Integrate withTaxPostingGroupEntityV2 data entity Microsoft data model ↗
Table definitionTaxLedgerAccountGroup columns and relations Microsoft data model ↗

Everyone

8Sources and checks