BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Transactions report

A report that shows customer transactions that have been invoiced.

Business process
Manage accounts receivable
Menu item
Output:CustTransList
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 customer transactions that have been invoiced.
What you do hereUse this report to review invoiced customer transactions, including the debits, credits, and amounts for each invoice.
Transactions 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 › Transactions 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 review invoiced customer transactions for a period, for example during collections or reconciliation.
How oftenOn demand, or at period end as part of the review of customer accounts.
What the output showsInvoiced customer transactions with debits, credits and amounts for each invoice. Amounts that differ from the ledger usually come from the Exchange rates choice, which includes or leaves out revaluations.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Transactions report.
  2. Turn on Only open to leave out settled transactions, and Include reversed to show reversed transactions too.
  3. In Exchange rates, choose Adjustment date to include foreign currency revaluations, or Invoice date to show amounts at the original rate.
  4. Filter on customers and dates and run the report, then read the debit, credit and amount columns per invoice.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Only openIncludes only open transactions and leaves out settled ones.Microsoft Learn
Include reversedIncludes reversed transactions.Microsoft Learn
Exchange ratesAdjustment date includes foreign currency revaluations; Invoice date doesn't.Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemOutput:CustTransList Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 6 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources