Language:


Customer Statistics

This command in the Sales Ledger exports monthly sales totals excluding VAT for each specified Customer for the first period in the Reporting Periods setting (in the System module). The monthly sales total statistics will be compiled from Invoices, POS Invoices and Bar Tabs.

For each Customer, this function will simply export the Customer Number and monthly sales figures. If you need more Customer information to be exported (e.g. Customer Name, Customer Category) together with the same figures, use the 'Customer Turnover History' Export function.

When you select the function, the 'Specify Customer Statistics' window will open. Leave the single field blank if you need to export monthly sales statistics for every Customer. Alternatively, specify a single Customer Number, or a range of Customer Numbers, separated by a colon (:). Use 'Paste Special' to select the appropriate Customer Numbers if necessary. Then, click the [Run] button to start the export process. A dialogue box will open where you can name the export file and specify where it is to be saved. Enter a name for the file and click [Save] or press the Enter key.

The export file will be created and saved. A message window will keep you informed about the progress of the export process. When the export finishes, you can close the 'Export' window using the close box.

---

Export functions in the Sales Ledger and Integration modules:

Go back to: