Creditor Report Applet

Answer every question about money you owe suppliers: which bills are open, how old they are, what a supplier’s statement shows, and how payments settled them. Only finalised documents are read, so drafts and voided bills never appear, and the only thing this applet writes is a contra between two open supplier documents.

Overview

The Creditor Report Applet gives your finance team one place to review money the company owes to suppliers. You can list unpaid supplier documents, review aging, pull supplier statements, trace historical balances, and see how payment vouchers settled purchase invoices, without moving between the purchase and payment applets. It reads the same documents those applets create; the only thing it writes is a contra between two open supplier documents.

In the product the applet is titled Creditor Report. It is the accounts-payable counterpart of the Debtor Report Applet; the Debtor and Creditor Report applet carries both sides in one menu.

Where it fits

Screens and menus

The left menu has eight reports. Each one opens a listing with an advanced-search bar (keyword plus filters), an AG Grid with export, and a drill-down that opens in the right-hand column.

View Outstanding Document (from Outstanding Document Report) has eight tabs in the order set under Settings → Default Selection → Details Tab Ordering: Details, Account (entity, bill-to, ship-to), Line Items (drill to View Item), Settlement (drill to View Settlement), Contra, Delivery Details, Department, Doc Link (Copied From / Copied To). The header PRINT button prints the document with the printable format registered for that document type (the one flagged default, otherwise the most recently updated; if none exists nothing is printed). The Contra tab lists existing contras, shows Total Contra, Doc Open Amount and Doc ARAP Balance, and offers a + button (only while the balance is not zero) that opens Contra Select Document — see Lifecycle and effects.

The Settings menu (group System Configuration) has Field Settings, Default Selection, Printable Format Settings and Aging Period Settings; the settings route also reaches the shared Webhook, Client Side Permission, Permission Wizard, Permission Set, User/Team/Role Permission and Release Notes screens. Personalization has one item, Default Selection.

All column and row-grouping choices are the standard AG Grid ones (columns panel, Drag here to set row groups, export from the status bar). The keyword box requires at least three characters; the two payment/settlement reports do not support keyword search at all (advanced search only).

Configuration

Before you can use it

• Supplier documents must be FINAL. Every report in this applet reads only finalised, active documents. Finalise purchase invoices, GRN stock-ins, debit/credit notes and returns in their own applets first.
• Suppliers need an AP type. Rows are restricted to entities whose default AR/AP type, or whose company link, is AP_TRADE, AP_OTHER, AP_MERCHANT or AP_EMPLOYEE. Set it in the Entity Applet or on the company link.
• Companies and branches come from the Organisation Applet. Two reports require a choice before searching: AP Transaction Report and Payment Details with Purchase Invoice require Company; Purchase Invoice with Settlement Details requires Branch.
• Server-side read permissions for each report (see Feature visibility / permissions). For users who are not tenant admin or owner, the company dropdowns and the default company scope are limited to the companies targeted by the report’s READ permission, so assign the permission with company targets in Settings → Permission Set / User Permission.
• A .jrxml printable format of type STATEMENT_OF_ACCOUNT_TRANSACTION and/or STATEMENT_OF_ACCOUNT_AGING, flagged Default, before anyone uses Export to PDF / Preview on a statement (below).
• An aging period (optional) if you want day-range buckets instead of calendar months (below).

Applet settings

Where settings live: this applet has its own small Field Settings screen, its own Default Selection screen, the shared Aging Period module, and a Printable Format Settings screen that also writes two settings keys. All of them are stored together as this applet’s settings, and a save merges the keys you save with the keys already stored, so saving one screen never wipes another. The Personalization → Default Selection screen renders but does not persist anything (below).

Who can change them: anyone who can open the applet’s Settings menu. There are no client-side permission definitions for this applet, so the menu is not hidden per role; if the server refuses a save for lack of permission, the screen shows no error.

Settings → Field Settings (SAVE sends the whole form)

Settings → Default Selection

Settings → Aging Period Settings

Settings → Printable Format Settings (applet-local; .jrxml only — ADD / SAVE stay disabled until a .jrxml file is attached)

The listing shows Format Code, Format Name, File Name, File Size, Uploaded Date, Uploaded By; edit offers download and delete (delete asks for a second click within three seconds).

Personalization → Default Selection — renders User Default Settings (Default Branch, Default Location, “This will override Applet Default Settings”) but the screen neither loads the stored values nor saves anything. Nothing is persisted; per-user branch defaults are not available in this applet.

Keys read at runtime that have no settings control in this applet (no screen here sets the first two; the third is written by the listings’ own layout toggle):

• ENABLE_BRANCH_FILTER_PERMISSION — on Historical Transaction Aging Analysis Report switches the Branch filter from the company-permission-filtered list (the default) to the plain branch list. The Outstanding Document Report reads it too, with no visible change (its Branch filter is already the plain list). On the Aging Report, which has no Branch filter of its own, it adds a Branch filter to the search panel — but the report never sends that choice, so the Aging Report is not narrowed by branch whatever you pick there. To see one branch’s aging, use the Outstanding Document Report with its Branch filter and the same bucket settings.
• SHOW_DOCUMENTS_WITH_ZERO_ARAP_BAL — in Contra Select Document, include documents whose balance is already zero.
• DEFAULT_TOGGLE_COLUMN (personal settings, written automatically) — remembers the single/double column layout per user.

Document behaviour settings

Not applicable — this is a report applet; the only write action (contra) has no settings.

Feature visibility / permissions

No client-side permission definitions exist for this applet, so nothing in the menu or on the screens is hidden per role. Access is enforced by the server per report, against these permissions: API_TNT_DM_ERP_ENTITY_AR_AP_REPORT_CREDITOR_OUTSTANDING_DOCUMENT_READ, …_CREDITOR_OUTSTANDING_ENTITY_READ, …_CREDITOR_OUTSTANDING_AGING_READ, …_DEBTOR_OUTSTANDING_ENTITY_READ, API_TNT_DM_ERP_CREDITOR_TRANSATION_HISTORY_REPORT_READ, API_TNT_DM_ERP_PURCHASE_INVOICE_SETTLEMENT_DETAIL_REPORT_READ, API_TNT_DM_ERP_PAYMENT_DETAIL_PURCHASE_INVOICE_REPORT_READ, API_TNT_DM_ERP_ARAP_TRANSACTION_READ, TNT_TENANT_ADMIN, TNT_TENANT_OWNER.

“Company scope”: a user with TNT_TENANT_ADMIN or TNT_TENANT_OWNER sees all companies; anyone else gets the company dropdown, and the implicit company scope applied when no company is chosen, limited to the companies targeted by the permission named in the last column.

Fields

There is no create/edit form; the fields are the advanced-search filters of each report, the two statement tabs and the contra picker.

Report filters (✓ = present, R = required before search)

Statement Of Account tabs (inside Entity Report Transactions)

Contra Select Document (opened from the Contra tab of View Outstanding Document)

Lifecycle and effects

What the reports read. Only finalised, active documents of AP entity types (the Outstanding Document Report additionally requires the entity to be flagged as a supplier), after the excluded document types are removed. A document’s balance is its open amount plus its contras, as stored on the document itself; when no currency filter is set, foreign-currency documents are converted to base currency at the document’s own exchange rate. “As of today” reports (Outstanding Document, Aging, Statement of Account, AP Transaction) read the live documents. The two historical reports read a historical-ageing snapshot up to the chosen month end. That snapshot is not maintained as documents are finalised: a monthly clock in the Scheduler writes it, at 01:00 on the 1st, from the balances at that moment, so a document finalised this month has no row until next month’s run. That clock is set per tenant, and yours may not have it. It is installed as a default only on tenants created after it joined the defaults (late August 2025), and it can be switched off. Open the Scheduler and look for the monthly historical-aging clock (MONTHLY_GENERIC_DOC_HISTORICAL_AGING_PROCESSOR): if it is missing or not Active, no new month-end is ever photographed, and the two historical reports come back empty for those months — or show only a back-dated contra’s correction, never a full month. Ask support to install it, then let it run once on the 1st. Two things correct an existing month afterwards — a back-dated contra, and, only where your tenant subscribes to the back-dated aging step, finalising a document dated in a month already photographed. See The aging shows an invoice already paid.

The statement and the “today” reports can disagree about a contra. The statement’s opening balance and its aging count a contra on its contra date. The Outstanding Document and Aging reports show the document’s balance as it stands today, whatever the contra date. So a contra dated into an earlier month moves the statement’s opening balance for that month, while the two “today” reports simply show the reduced balance.

Which amount lands in a bucket. In month mode both aging listings, and the Aging Summary tiles, put each document’s balance (open amount plus contras, converted to base currency) into its month column. In day mode they differ. The Outstanding Document Report puts the balance into the day-range columns. The Aging Report puts the document’s original open amount into its day-range columns — before any contra — while its Balance column uses the balance. On both reports a foreign-currency document’s day-range amount is left in the document’s own currency rather than converted, so in day mode with foreign-currency suppliers use the Currency filter or month mode. A partly settled bill therefore shows its full amount in the Aging Report’s day columns and its remaining balance on the Outstanding Document Report. When you reconcile to the ledger in day mode, total the Balance column (or use the Outstanding Document Report), not the day columns of the Aging Report; month mode does not have this difference.

What this applet changes. The eight reports only read. The one write is the contra (below), and a contra changes the balance and contra total of both documents and, for a pair at different exchange rates, posts an exchange-difference journal. No document’s status or posting status changes.

Contra — the one write path. View Outstanding Document → Contra → + → Contra Select Document → ADD creates a contra between the open document and each selected document.

Related applets

• Debtor Report Applet — the receivable twin (same screens, the AR entity types, plus a salesman collection report).
• Debtor and Creditor Report — a separate applet that carries both sides in one menu; same reports.
• Payment Voucher (Internal) — creates the settlements shown in the Settlement tab and the two payment reports.
• Purchase Invoice No Stock In, Purchase GRN Stock In, Purchase Debit Note, Purchase Credit Note, Purchase Return — the documents that carry supplier balances.
• Purchase Order, Purchase GRN — linked through the PO No / GRN No columns.
• Entity Applet — supplier master and AR/AP type; Organisation Applet — companies and branches.
• Financial Report, Ledger And Journal — the GL side to reconcile against.
• Purchase Report — purchase analysis by document and item.

Troubleshooting

Related documentation

• Reports & Analytics — where this applet sits among the finance reports.
• Financial Accounting module and Purchasing module.
• Debtor Report Applet and Debtor and Creditor Report — the sibling reference pages.