Reporting
RoyaltyCentral ships six reports. They cover licensor statements, internal review, payee backup, guarantee tracking, and contract printouts. Business Central’s built-in Analysis Mode adds ad-hoc views over the Royalty Entries ledger. Open the reports from RoyaltyCentral → Reporting.
| Report | Purpose | Audience |
|---|---|---|
| Royalty Statement | The detailed royalty transactions for the selected contracts and date range. This is the report you share with licensors. | External (licensors) |
| Royalty Due | A summary of the sales and royalty amounts by contract, with no line detail. | Internal |
| Royalty Detail | The transactions for the selected contracts. | Internal |
| Royalty Payment Detail | Formatted to accompany a payment to a payee as backup. | External (payees) |
| Royalty Minimum Guarantee | The guarantee schedule and progress, for the contracts with guarantees. | Internal |
| Royalty Contract Detail | The full definition of one contract on one printout: the contract information, the detail lines, the payees, and the minimum guarantee schedule. | Internal (or share with the licensor) |
Royalty Statement
The licensor-facing statement. Choose a date range and one or more contracts. The Include Payments option is on by default. Clear it to show only the sales entries.
Royalty Due
A summary of the sales and royalty totals by contract. It is the quick internal “what did we accrue” view, without transaction detail.
Royalty Detail
The transactions for the selected contracts. Use it for internal review, not for external distribution. The report also ships an Excel pivot layout.
Royalty Payment Detail
Payment backup for a payee: the transactions behind a settlement, formatted to send with the payment.
Royalty Minimum Guarantee
Schedule-and-progress tracking for the contracts that carry a guarantee. See Minimum guarantees.
Royalty Contract Detail
This report prints the full definition of a contract. It shows the contract information, the contract detail lines, the payees, and the minimum guarantee schedule. The schedule shows the same period figures as the Contract Guarantees page: the royalty total, the remaining amount, and the posted guarantee total. Each contract starts on a new page.
To print one contract, select Print on the Royalty Contract Card. To print several contracts, select them on the Royalty Contract List. Then select Print. You can also run the report from the Reporting menu and filter on No., Licensor No., and Status.
Ad-hoc analysis — Analysis Mode
Royalty activity posts to the Royalty Entries ledger. So you can build pivot-table-style views without a custom report. Open Royalty Entries. Switch on Analysis Mode (the toolbar toggle). Then:
- Pivot and group by the columns you choose, for example contract, licensor, payee, G/L account, item, or period, with row and column totals, like an Excel pivot.
- Save named analysis tabs. The tabs persist, and you can share them with other users, who see the same layout.
- Export to Excel for a workbook that a licensor or finance can work from.
This is often the fastest way to shape licensor-specific views and reconcile a period, next to the formatted reports above.
Report layouts. As with other Business Central reports, you can restyle the six reports with custom report layouts to match your house format. The underlying data does not change.
See also: Royalty entries · Payments · Minimum guarantees · Contracts