BeyondERP.Newsletter
Menu

Report page · Accounts receivable

Customer invoice transactions report

A report that shows Accounts receivable customer invoice transactions.

Business process
Issue sales invoices
Menu item
output:CustInvoice
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 Accounts receivable customer invoice transactions.
What you do hereUse this report to review posted customer invoice transactions sorted by the general ledger account credited on each invoice line.
Customer 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 › Issue sales invoices
Menu pathAccounts receivable › Inquiries and reports › Invoices › Customer invoice 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 analyze revenue from customer invoices by ledger account, for example at month end.
How oftenOn demand, or at each period close.
What the output showsPosted customer invoice transactions sorted by the general ledger account credited on each invoice line, filtered by open or paid status. Revenue on the wrong account usually comes from the main account on the invoice line.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts receivable > Inquiries and reports > Invoices > Customer invoice transactions report.
  2. Enter the From date and To date of the posted invoice transactions.
  3. Choose the Dimension set (dimension focus) and set Invoice type to Open, paid or both.
  4. Limit Invoice account or Customer account if needed, run it and read the amounts per general ledger account credited.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Billing classificationLimits the report to one or more billing classifications (public sector).Microsoft Learn
Dimension setThe financial dimension set the report uses.Microsoft Learn
From dateThe start of the date range of posted invoice transactions.Microsoft Learn
To dateThe end of the date range of posted invoice transactions.Microsoft Learn
Invoice typeWhether to include open invoices, paid invoices, or both.Microsoft Learn
Invoice accountThe invoice accounts to include.Microsoft Learn
Customer accountThe customer accounts whose transactions are included.Microsoft Learn
Solution architect

4Design impact

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

5Technical

Menu itemoutput:CustInvoice 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:CustInvoice
Everyone

7Sources