BeyondERP.Newsletter
Menu

Report page · Credit and collections

Detailed due date list report

A report that gives a detailed list of customer payments that are due by a specific date.

Business process
Manage credit and collections
Menu item
output:CustDueReportDetail
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 a detailed list of customer payments that are due by a specific date.
What you do hereUse this report to see which customer transactions are due on or before a date you choose.
Detailed due date list 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 credit and collections
Menu pathCredit and collections › Inquiries and reports › Detailed due date list 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 customers have credit balances, for example from overpayments, that you must pay back.
How oftenOn demand, when customers have credit balances above the minimum reimbursement.
What the output showsA vendor invoice for each customer's credit balance: the customer credit balance is removed and a balance due appears on the customer's vendor account. Customers without a vendor account get a one-time vendor account.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Credit and collections > Inquiries and reports > Detailed due date list report.
  2. Set the Minimum reimbursement in Accounts receivable parameters first, and add a Vendor account on customers who should be paid through an existing vendor.
  3. Set Summarize customer to Yes to group all transactions, or No to group only transactions with similar ledger dimensions.
  4. Turn on Include customers with outstanding debit transactions when customers who also have unsettled debit amounts should be reimbursed in this run.
  5. On the Records to include FastTab, select Filter to limit the run to specific customer accounts.
  6. Run the process, review the transactions in the Reimbursement report, and pay the vendor invoices in Accounts payable.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
As onDate that decides which customer payments are included; transactions due on or before it are listed.Microsoft Learn

Test checklist

  1. The customer's credit balance is zero after the run.
  2. A matching vendor invoice exists on the customer's vendor account.
  3. The Reimbursement report lists the expected customers and amounts.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: The credit balance is moved to a vendor invoice. Check the Reimbursement report before you pay; once paid, the money has left the company. Microsoft Learn
If you change it laterRemoves customer credit balances and creates vendor invoices for the same amounts, creating one-time vendor accounts where needed. Microsoft Learn
Technical architect

5Technical

Menu itemoutput:CustDueReportDetail Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itCollections manager CollectionLetterCollectionsManagerCollections agent CollectionLetterCollectionsAgentAccounts receivable manager CustInvoiceAccountsReceivableManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorGive 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:CustDueReportDetail
Everyone

7Sources