Pre-aggregated Data Sets – Invoices

The existing pre-aggregated data sets show the number of orders created and a “limited” value along with the number of pickups and deliveries.

It has come up recently where the number of invoices is desired along with the invoice amount (before taxes).

This post contains “forward looking” statements. No commitment should be inferred from this content.

To meet this request two fields need to be added into the database and the relevant procedures updated.

Field Type Purpose
NOINVOICES count number of invoices in the period (uses DateInvoiced)
INVAMOUNT dollar sum of actual charges (uses DateInvoiced)
uses the NetPrice field so it does not include taxes.

In development this has been added to the Department data set, others may follow.

Bookmark the permalink.

Comments are closed.