Skip to content
Receivables

Sales summary by user

What a user sold in a period, how much of it is still to collect, and what came in.

What it shows

Three parts for the chosen user, or for everyone. Sales lists each sale of the period with Sales (its total), Sales due (what is still owed on it) and Sales settled (the rest: paid, credited or written off); Earlier invoices falling due lists invoices issued before the period, still open and due within it; Collected in the period lists the payments received on invoices and, on the desktop, what till sales and programs' documents were settled with as they were written. Only the first part makes the totals.

How it ties to the books

With no user chosen, the Sales total equals the Total of Sales by customer for the same period, and Sales due the Balance of Customer balances. The collected part goes by payment date, so it need not match Sales settled.

The user is the person responsible for the invoice, or whoever wrote it when no one is named; the cashier for a till sale; whoever posted a program’s document. Sales are invoices, the till’s sales and returns, and the documents a program posts to a customer.

GroupReceivables
Periodtakes a date range
FiltersUser
Columns4

Columns

ColumnKindTotalled
Invoicetext—
SalesamountYes
Sales dueamountYes
Sales settledamountYes

A sample from the demo data

Drawn by the program’s report engine on the demo company, 30 July 2026 to 28 October 2026, in SAR. The first 8 of 30 rows.

InvoiceSalesSales dueSales settled
Sales
POS-2026-00000113213.0013213.000.00
POS-2026-0000028452.000.008452.00
POS-2026-00000311430.000.0011430.00
POS-2026-00000414838.000.0014838.00
POS-2026-00000516514.000.0016514.00
POS-2026-0000069595.000.009595.00
POS-2026-00000717331.000.0017331.00
Total274783.0085182.00189601.00

Sample data, for illustration only.

Reports read with it

The 60 reportsJooDax

Sources

The definition and the sample come from the program’s report library (books/reports.rs) on the demo data; the explanation from its engine.