BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Open transactions report

A report that gives detailed information about the open transactions of each customer as of a chosen date.

Business process
Manage accounts receivable
Menu item
output:CustTransOpenPerDate
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 gives detailed information about the open transactions of each customer as of a chosen date.
What you do hereUse this report to review each customer's open transactions, with dates, vouchers, amounts, and balances, as of the date entered in the Open transactions per field.
Open 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 › Open 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 itAt period end or for an audit, when you need each customer's open items as of a past or current date.
How oftenAt each period close, or on demand for collections reviews.
What the output showsEach customer's open transactions with dates, vouchers, amounts and balances as of the chosen date. A balance that doesn't match the ledger often comes from settlements dated after the report date.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Open transactions report.
  2. Enter the Open transactions per date; if you leave it blank, the latest possible date is used.
  3. Turn on Exclude future settlements if settlements after that date should not count, so the report shows what was open on the date.
  4. Filter on the customers you need and run the report, then compare the totals with the Accounts receivable balance in the ledger for the same date.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Open transactions perThe date as of which open transactions are included; if left blank, the latest possible date is used.Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemoutput:CustTransOpenPerDate Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerCollections manager CollectionLetterCollectionsManagerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive people one of these roles. On this system, 9 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=output:CustTransOpenPerDate
Everyone

7Sources