Skip to main content

Questions you can ask Copilot about the Debtors module

A reference guide to the natural language queries you can use with Copilot to retrieve and analyse customer records and sales transactions from the Debtors module.

Updated over a week ago

You can interact with Copilot using natural language queries to retrieve key information from Access Dimensions Cloud.

The below listed queries can also include filters of your choosing.

  • How many customers do I have?

  • How many inactive customers do I have?

  • How many active customers?

  • List active customers with Name and Code

  • List inactive customers with Name and Code

  • How many on stop customers?

  • List inactive customers who are also on stop

  • Show me the credit limit for [Customer Name]

  • Show me the customers with the highest credit limit

  • Find customers nearing their credit limit

  • Find customers under their credit limit

  • Find customers over their credit limit

  • List [Transaction Type] for [Customer Name] over [Value]

  • List all [Transaction Type] for [Customer Name] for [Date] or [Date Range]

  • Show me details about [Customer Name]

  • Show me the terms for [Customer Name]

  • Show me contact details for [Customer Name]

  • Which is the latest invoice for [Customer Name]?

  • How many payments has [Customer Name] made in the last year?

  • What is the percentage of sales coming from our top 10 customers?

  • List top customers by outstanding debt

  • Find customers with the largest most persistent debt over 180 days

  • Which customers have payment terms longer than 60 days?

  • Who is the credit controller for [Customer Name]?

  • Show me the customers that have [Credit Controller Name] as credit controller

  • Which customers have shown the highest sales growth between this year and last year?

  • List [Transaction Type] for [Date] or [Date Range]

  • List top customers by spend

  • Show me the customer with the highest\lowest outstanding amount

  • How many [Transaction Type] are batched and what is the value of these?

  • What was the highest invoice from last month?

  • How many invoices have been paid late in the past year?

  • Which invoices were paid before their due date?

  • What is the variance in sales invoices compared to the previous fiscal year?

  • Show me customers with no invoices raised in the last 6 months

  • List all unpaid invoices

  • List all unpaid Invoices from [Customer Name]

  • List the highest value sales transactions this quarter

  • How many sales transactions have occurred in the past week?

  • What is the average transaction value for the past 3 months?

  • How many invoices are on dispute?

  • List all invoices with Customer Code and Name and Gross value

  • What is the total value of the highest invoice raised last month and this month and what is the average value of these?

  • How many sales transactions are for [Customer Name] and list this showing me the Date, Type and Outstanding Amount?

Did this answer your question?