Skip to content
Hypamoon

For teams that run on Business Central

Business Central customer statements each month

Business Central makes a statement from the customer card or the Customer Statement report, and you send it from there. Sending one every month to each customer with a balance, with only what is still open, depends on someone running it with the right dates, layout and address.

How it goes today

  1. Open the Customer Statement report at the start of the month.
  2. Set the dates and choose to show only open entries.
  3. Check the document layout and email address per customer.
  4. Run it and follow up with the customers who did not get one.

How it can go

Each customer with an open balance gets a statement every month.

On the first working day of the month, each customer with an open balance gets a statement from your own address: open invoices with invoice date, due date, open amount and days overdue, the balance as Business Central shows it, and the totals for current, 30, 60 and 90 days. Paid invoices are left off. You choose per customer which address it goes to and get a list of who received one.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. You paste your Business Central key in the portal, never in the chat.

Your request

With Hypamoon, on the first working day of each month, send each customer with an open balance in Business Central a statement from our address. List their open invoices with invoice date, due date, open amount and days overdue, their balance, and the totals for current, 30, 60 and 90 days. Leave paid invoices off. Use the statement address I set per customer, otherwise their main email. Send me a list of who got one.

Your IT administrator registers an app in your own Microsoft Entra ID with a client ID and secret and the Business Central API permission, then adds it on the Microsoft Entra Applications page in Business Central with only the permission sets this tool needs. It stays yours.