Accounts 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 it
When you need to document or audit which ledger or main accounts customer transactions posted to, for example at year end.
How often
On demand, for audits or after posting profile changes.
What the output shows
Customer 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.
Go to Accounts receivable > Inquiries and reports > History by transaction report.
Turn on Main accounts only to show main accounts instead of full ledger accounts with dimensions.
Turn on Totals per account only to get one total per account instead of each transaction's date, voucher and invoice.
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.
Shows only a total per account instead of each transaction's date, voucher and invoice.Microsoft Learn
Solution architect
4Design impact
Can it be undone
Nothing to undo: The report only reads posted customer transactions. Microsoft Learn
Technical architect
5Technical
Menu item
Output:CustLedgerTransChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To 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