Debtor and Creditor Report

Review what customers owe you and what you owe suppliers in one place, for a team that looks after both sides. It reads finalised documents and writes nothing, not even a contra, and its totals are document balances, so they can differ from the Balance Sheet, which also carries manual journals.

Overview

The Debtor and Creditor Report applet is one workspace for reviewing both sides of the sub-ledger: money customers owe you (accounts receivable, “debtors”) and money you owe suppliers (accounts payable, “creditors”). Its left menu carries fifteen reports — a debtor and a creditor version of the outstanding-document, aging, statement-of-account, historical-aging and historical-balance reports, plus the AR and AP transaction reports, the salesman collection report and the two payment/settlement reports. It reads the same FINAL documents that the sales, purchase, receipt and payment applets create and writes nothing.

In the product the applet is titled Debtor & Creditor Report and its route root is applet/tnt/wavelet/erp/debtor-and-creditor-report-applet. It is a separate product from the single-sided Debtor Report Applet and Creditor Report Applet, which share its report engine but carry their own settings screens (this applet has almost none — see Configuration). Choose this applet when one team reviews both sides; choose the single-sided applets when you need aging periods, excluded document types, contra creation or the salesman-code and popup settings.

Where it fits

Screens and menus

Every menu item opens a listing with an advanced-search bar (keyword plus filters), a Current DateTime or As of Date label, an AG Grid with export, and — where the repo has one — a drill-down that opens in the right-hand column. The default landing page is Debtor Outstanding Document Report.

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

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

• Documents must be FINAL. Every report reads only FINAL, active documents. Draft or voided documents never appear.
• Entities need an AR or AP type. The Debtor … screens return entities whose default AR/AP type (or company link) is an AR_* type; the Creditor … screens use the AP_* types. Set it in the Entity Applet or on the company link.
• Companies and branches come from the Organisation Applet. AR Transaction Report and AP Transaction Report require Company; Purchase Invoice with Settlement Details requires Branch (“Please select branch.”).
• Server-side read permissions for each report (see Feature visibility / permissions), granted with company targets for users who are not tenant admin or owner.
• 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.

Applet settings

Where settings live: this applet has no settings form of its own. Of the three screens under Settings, only Printable Format Settings saves anything; it writes two settings, merged with what is already stored. Every listing still reads the same keys the single-sided applets use (see the runtime-only list below), so a tenant that needs day-range buckets here has to have those keys written by another means. Excluded document types are the exception: no key changes them in this applet (see below).

Who can change them: anyone who can open the applet’s Settings menu. The applet has no client-side permissions, so nothing in the menu is gated.

Settings → Field Settings — renders two panels, Lines Settings (Unit Discount, SST/VAT/GST, WHT, Blanket Order) and Department Settings (Segment, G/L Dimension, Profit Center, Project), but none of the eight toggles is saved and the SAVE button does nothing. The screen is a placeholder.

Settings → Default Selection — renders Default Branch and Default Location dropdowns, but choosing a branch raises an error in the browser console and SAVE saves nothing. Nothing is persisted; DEFAULT_BRANCH / DEFAULT_LOCATION cannot be set from this applet.

Settings → Printable Format Settings (this applet’s own; .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.

Personalization → Default Selection — renders User Default Settings (Default Branch, Default Location) but, exactly like the applet-wide screen, never loads values and its SAVE has no listener. Nothing is persisted.

Keys read at runtime that have no control in this applet (settings are stored per applet, so values saved in the Debtor or Creditor Report Applet do not carry over; these can only be set by editing this applet’s APPLET_SETTINGS JSON):

Excluded document types are fixed in this applet. Every listing sends a fixed list as exclude_server_doc_types: the Debtor … screens exclude 22 purchase-side types (purchase invoices, GRNs, debit/credit notes, payment vouchers, consignment documents, goods delivery/dispatch notes, INTERNAL_PURCHASE_GRN_STOCK_IN), the Creditor … screens exclude 25 sales-side types (sales invoices, cash bills, receipt vouchers, credit/debit notes, returns, jobsheets, packing orders, customer consignments, plus INTERNAL_PURCHASE_GRN_STOCK_IN, added July 2026 after a customer saw GRN stock-ins double-counted). A GRN stock-in with an open supplier balance therefore never appears in this applet’s creditor reports, and there is no setting to change that.

Document behaviour settings

Not applicable — this is a report applet with no write action.

Feature visibility / permissions

No client-side permission definitions exist for debtor-and-creditor-report-applet in the registry (checked 2026-09-05). Access is enforced by the backend per endpoint. At start-up the applet asks the permission-inquiry service for: API_TNT_DM_ERP_ENTITY_AR_AP_REPORT_CREDITOR_OUTSTANDING_DOCUMENT_READ, …_CREDITOR_OUTSTANDING_ENTITY_READ, …_CREDITOR_OUTSTANDING_AGING_READ, …_DEBTOR_OUTSTANDING_DOCUMENT_READ, …_DEBTOR_OUTSTANDING_ENTITY_READ, …_DEBTOR_OUTSTANDING_AGING_READ, API_TNT_DM_ERP_CREDITOR_TRANSATION_HISTORY_REPORT_READ, API_TNT_DM_ERP_DEBTOR_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_DEBTOR_REPORT_BRANCH_TGT_READ, TNT_TENANT_ADMIN, TNT_TENANT_OWNER.

Because the creditor screens were copied from the debtor ones, a role built only from CREDITOR_* permissions gets an empty company dropdown on the creditor listings; the practical minimum for an AP-only user is the debtor outstanding-document and outstanding-entity READ permissions with company targets as well. Branch dropdowns are scoped by the targets of TNT_DEBTOR_REPORT_BRANCH_TGT_READ on both sides. Tenant admins and owners see all companies.

Fields

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

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

There is no ARAP Type filter on any listing; the side is fixed by the menu item. Keyword search needs at least three characters; with no currency filter, foreign-currency amounts are shown in base currency (divided by the document rate), and a non-MYR currency filter shows document-currency amounts.

Statement Of Account tabs (inside Entity Report Transactions, both sides)

Lifecycle and effects

What the reports read. Only FINAL, active documents of the side’s account types, less a fixed list of excluded document types. The balances are the document’s own Docs Open, Contra and Balance figures (Balance = Docs Open + Contra), and the customer or supplier a row names is the document’s — every report here reads the document, not the journal. The one report that reads the journal line’s entity instead, and so keeps naming the old record after a posted document’s customer or supplier was changed without the journal following, is the Subledger Report tab of Entity Report Transactions in the Debtor Report and Creditor Report applets; this applet’s version of that tab is switched off. “As of today” reports read the documents as they stand now; the four historical reports read the historical-ageing snapshot as at the end of the chosen month. That snapshot is not kept up to date as documents are finalised: a monthly job writes it, at 01:00 on the 1st, from the balances at that moment. That job runs on a clock that is set up per tenant, and it may be off on yours. If it is off, the historical reports stop at the last month it wrote, and every later month comes back empty rather than wrong. Check it in the Scheduler applet: look for the monthly historical-aging clock with Status ACTIVE, and if it is missing or inactive ask your BigLedger contact. Do not run it by hand to fill a missed month: it stores last month-end from today’s balances and never replaces a month already stored. A back-dated contra corrects a month already written, and so — only where your tenant subscribes to the back-dated aging step — does finalising a document dated in such a month. See The aging shows an invoice already paid. Collection Invoice with Aging is built differently from every other report here. It reads the settlements themselves rather than the documents’ balances: each time a receipt voucher settled a sales invoice or cash bill, at the date of that settlement. So it is the one report that measures how long customers take to pay, not how old their unpaid balance is. Use it to compare salesmen’s collection speed, or to set a customer’s credit terms from how they actually pay. A balance settled by a sales credit note does not appear in it here; the same report in the Debtor Report Applet includes credit notes, so use that one when you need both.

What it writes. Nothing. The Contra tabs list existing contras, and there is no add button on any of them. No document status changes, no journal, no stock movement. To create a contra use the Debtor Report Applet or Creditor Report Applet.

Related applets

• Debtor Report Applet — the receivable side on its own, with Field Settings, aging periods, personal defaults and contra creation.
• Creditor Report Applet — the payable side on its own, same additions.
• Receipt Voucher (Internal) and Payment Voucher (Internal) — create the settlements shown in the Settlement tabs, the transaction reports and the payment/settlement reports.
• Sales Invoice (Internal), Purchase Invoice No Stock In — the main documents carrying customer and supplier balances.
• Entity Applet — AR/AP type decides the side; Organisation Applet — companies and branches.
• Financial Report, Ledger And Journal — the GL side to reconcile against.

Troubleshooting

Related documentation

• Reports & Analytics — where this applet sits among the finance reports.
• Financial Accounting module, Digital CRM module and Purchasing module.
• Debtor Report Applet and Creditor Report Applet — the single-sided reference pages.