Skip to main content

Customer Dashboard

TL;DR

This report answers what one customer has ordered and what has been shipped to them. A customer must be chosen before anything appears. Two of the tiles across the top add up only the rows currently on screen, so they can disagree with the counts beside them.

What this answers

For one chosen customer: every purchase order they have placed, and every invoice raised for them, with totals across the top. Customer-first, where the Item Dashboard is product-first.

Before you start

A customer must be chosen. Until then the screen shows "Select a Customer" panels reading "Choose a company & customer above, then click Load Data to see orders here." and "…to see dispatches here.". The button those panels mean is labelled "Apply". Nothing on the screen is labelled "Load Data". Pressing "Apply" without a customer shows "Please select a customer to load data.".

Filters

Filter Required Notes
Date Range No Purchase Orders table: the order date. Dispatches: the invoice date
Company ("Select Company") No Narrows the customer list only. It does not filter the tables. Chosen for you automatically when you are assigned exactly one
Customer ("Select Customer") Yes Marked with a red asterisk
Purchase Order Status ("Select Purchase Order Status") No "Pending", "In Progress", "Complete", "Partially Dispatched"
Invoice Status ("Select Invoice Status") No "In Progress", "Complete", "Delivered". No Delete choice, because removed invoices never appear on this report

"Apply" refreshes both tables; "Reset" clears everything and returns to the panels.

The Company filter deserves a second warning: whatever company is picked, both tables show the customer's rows from every company you can see. The picker exists to help find the customer, nothing more.

The four totals

Across the top: "Total Orders", "Total Dispatches", "Total Orders Qty", "Total Dispatch Qty", plus badges like "137 Orders" and "12 Dispatches".

The two counts are true totals. The two quantity tiles are not. They add up only the rows currently on screen, ten unless the rows-per-page selector was changed. "Total Orders: 137" can sit beside an orders quantity that covers ten rows.

The workaround: set the rows-per-page selector to "All" (or a size covering everything) on each table, and the quantity tiles become correct.

Columns

Purchase Orders table:

Column What it holds
PO Number The order
PO Date Day-month-year
Sales Order No Or a dash when empty
Delivery Date Or a fallback when empty
Status The order's status badge. "Partially Dispatch" is spelled so here
Total Qty The order's total quantity
Total Amount With the order's currency sign

Default order: by status rank, then most recently changed first.

Dispatches table:

Column What it holds
Invoice No The invoice
Invoice Date Day-month-year
PO Numbers All orders billed on it, or "—" when none
Dispatch Qty The invoice's total dispatch quantity
Total Amount The invoice's total
Status "In Progress", "Complete" or "Delivered". "Complete" here means complete but not yet delivered
Port of Loading "N/A" when empty
Port of Discharge The same
Transport Mode The same
Dispatch Name The same

Default order: by status rank: In Progress first, then Delivered, then Complete. Inside the Delivered group, the most recently changed invoices come first.

Which rows appear

  • Purchase Orders: the customer's orders, excluding those whose status is Delete. Only your assigned companies.
  • Dispatches: the customer's invoices: including those still in progress, unless the Invoice Status filter narrows them. Removed invoices are left out.

Exporting

Both tables offer "Excel", "Excel All", "CSV", "CSV All" built in the browser, plus "PDF" and "PDF All" built by the system. "PDF" covers the current screen's rows; "PDF All" covers everything matching. A failure shows "Unable to generate PDF".

The orders PDF is titled "Customer Purchase Orders Report" and carries a "Date Range: … to …" line; the dispatches PDF is titled "Customer Dispatches Report".

One status, three spellings

The same order state is spelled three ways on this one report. Quoted exactly, where each appears:

  • The table badge: "Partially Dispatch"
  • The filter option: "Partially Dispatched"
  • The exported orders PDF: "Partially Dispatched". Its wording list also contains "Deleted" and "Unknown", though no row in those states can reach the PDF

And the dispatches PDF heads its status column "Invoice Status" where the screen column is headed "Status". All of these mean what their nearest match means; none is a different state.

Things to watch

  • The quantity tiles and the company filter, both above, are the two most-reported "faults" of this screen, and both are how it is built.

FAQs

Why do the quantity tiles disagree with the counts beside them?

The two counts are true totals, but the two quantity tiles add up only the rows currently on screen, ten unless the rows-per-page selector was changed. Set the selector to "All" on each table and the quantity tiles become correct.

Why does picking a company not change the tables?

The Company filter narrows the customer list only; it does not filter the tables. Whatever company is picked, both tables show the customer's rows from every company you can see.

Where is the "Load Data" button the panels mention?

Nothing on the screen is labelled "Load Data". The button the panels mean is labelled "Apply".

Why do in-progress invoices appear in the Dispatches table?

The table includes the customer's invoices still in progress by design, unless the Invoice Status filter narrows them. Removed invoices are left out.

Are "Partially Dispatch" and "Partially Dispatched" different states?

No. The same order state is spelled three ways on this report: the table badge says "Partially Dispatch" while the filter option and the exported orders PDF say "Partially Dispatched". None is a different state.

Why does the dispatches PDF say "Invoice Status" where the screen says "Status"?

They are the same column under two headings. Each means what its nearest match on screen means.

Last verified: 22 September 2026