BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Sales tax specification report

A report that shows, for each customer account, the sales tax amounts on all posted invoices and the total sales tax amount.

Business process
Issue sales invoices
Menu item
Output:CustTransTaxTrans
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA report that shows, for each customer account, the sales tax amounts on all posted invoices and the total sales tax amount.
What you do hereUse this report to review the sales tax charged to each customer, including the sales tax direction, such as sales tax payable.
Sales tax specification report 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

Business processManage accounts receivable › Issue sales invoices
Menu pathAccounts receivable › Inquiries and reports › Sales tax specification report
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.

When to run it

When to run itBefore you settle and report sales tax for a period, to review the sales tax charged to each customer.
How oftenOnce per sales tax period, or on demand when a customer questions the tax on an invoice.
What the output showsFor each customer account, the sales tax amounts on posted invoices with the sales tax direction, and a total. A wrong total usually points to the sales tax group or item sales tax group on the invoice lines.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Sales tax specification report.
  2. Set Summary to Yes to total the amounts by sales tax code, or leave it off to list the sales tax per invoice.
  3. Filter on the customer accounts and invoice dates that you need to review.
  4. Run the report and compare the totals per sales tax code with the sales tax payable in the ledger.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
SummarySummarizes by sales tax code; otherwise the report is organized by invoice.Microsoft Learn
Solution architect

4Design impact

Can it be undoneNothing to undo: The report only reads posted sales tax transactions. Microsoft Learn
Technical architect

5Technical

Menu itemOutput:CustTransTaxTrans Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorGive people one of these roles. On this system, 10 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Output:CustTransTaxTrans
Everyone

7Sources