Reports

Advanced Dynamic Report

One report that answers four questions: what did this customer buy, what did we buy from this supplier, who buys this product, and who supplies it.

Last updated 2026-10-13

DigitalKey ERP — Docs · digital-key.co/docs/reports/advanced-report

Requires subscriptionreport.advanced_dynamic2,000 IQD / month

Overview

Pick who or what to report on, pick a period, and the report lists everything bought or sold with totals — and every row opens to show the invoices behind it. It lives on the Advanced tab under Reports.

Reports — Advanced Dynamic Report
Advanced Dynamic Report
Advanced Dynamic Report — A customer's purchases by product, with quantity, returned, net quantity, amount and prices, and one row opened to its invoices.

The four modes

ParameterTypeRequiredDescription
Customer → productssalesOptionalEverything one customer bought, by product.
Supplier → productspurchasesOptionalEverything bought from one supplier, by product.
Product → customerssalesOptionalEvery customer who bought one product.
Product → supplierspurchasesOptionalEvery supplier one product was bought from.
  1. 1

    Choose the mode

    One of the four above.

  2. 2

    Search the subject

    A customer or supplier by name or phone; a product by name, barcode or SKU. Change swaps it for another.

  3. 3

    Set the period

    Two dates, or All time.

  4. 4

    Generate

    The table and its totals appear. Reset clears the subject and the period to start again.

  5. 5

    Open a row

    Each row expands to the invoice lines behind it — date, invoice number, quantity, unit price, total and payment type.

Columns

ParameterTypeRequiredDescription
QtydecimalOptionalQuantity bought or sold, in line units.
ReturneddecimalOptionalQuantity returned against those same invoices.
Net qtydecimalOptionalQty less Returned.
AmountdecimalOptionalLine totals after line discounts.
Avg pricedecimalOptionalAmount divided by quantity.
Last pricedecimalOptionalThe price on the most recent invoice.
InvoicesintegerOptionalHow many invoices the row is built from.
First / LastdateOptionalThe first and most recent invoice dates.
NoteAmounts are line totals after line discounts. An invoice-level discount is not spread over the lines, so the Amount column can add up to slightly more than the invoices' totals.

Print and Excel

Print and Excel (CSV) export the table as shown. On a long report the screen draws rows in batches, but the totals, the printout and the export always cover every row.

Cost prices

WarningIn the two supplier modes the amounts are cost prices. For a staff member without See purchase price & profit those amounts are hidden, and only quantities are shown.

Not part of Smart Reports

The Advanced Dynamic Report is its own subscription. Smart Reports includes the sales and discounts reports, but not this one.

Related