BeyondERP.Newsletter
Menu

Report page · Accounts receivable

History by transaction report

A report that shows how customer accounts connect to ledger accounts or main accounts.

Business process
Manage accounts receivable
Menu item
Output:CustLedgerTrans
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 how customer accounts connect to ledger accounts or main accounts.
What you do hereUse this report to document the link between customer accounts and the ledger accounts or main accounts they post to.
History by transaction 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
Menu pathAccounts receivable › Inquiries and reports › History by transaction 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 itWhen you need to document or audit which ledger or main accounts customer transactions posted to, for example at year end.
How oftenOn demand, for audits or after posting profile changes.
What the output showsCustomer transactions grouped by the ledger account or main account they posted to, either in detail or as totals per account. An unexpected account usually means the customer posting profile or customer group was different when the transaction was posted.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > History by transaction report.
  2. Turn on Main accounts only to show main accounts instead of full ledger accounts with dimensions.
  3. Turn on Totals per account only to get one total per account instead of each transaction's date, voucher and invoice.
  4. Filter on the customers or period you need to document, run the report and compare the accounts with the summary accounts in the customer posting profiles.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Main accounts onlyShows main accounts instead of ledger accounts.Microsoft Learn
Totals per account onlyShows only a total per account instead of each transaction's date, voucher and invoice.Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemOutput:CustLedgerTrans 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 CollectionLetterCollectionsManagerAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkGive people one of these roles. On this system, 13 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources