Sales Invoice Lines

Downloads a selection or all of your printed Exact Online sales invoice lines as an Excel workbook from one or more Exact Online companies.

Parameters

The following parameters can be specified:

•Exact Online company division code to be downloaded. When empty, all accessible Exact Online companies will be downloaded.

•Earliest invoice date; when specified only include sales invoice lines with an invoice date on or after the earliest invoice date.

•Latest invoice date; when specified only include sales invoice lines with an invoice date before or on the latest invoice date.

•Earliest order date; when specified only include sales invoice lines with an order date on or after the earliest order date.

•Latest order date; when specified only include sales invoice lines with an order date before or on the latest order date.

•Earliest payment date; when specified only include sales invoice lines with a payment date on or after the earliest payment date.

•Latest payment date; when specified only include sales invoice lines with a payment date before or on the latest payment date.

•Article group code; when specified only include lines for articles within the specified article group.

•Cost unit code; when specified only include lines for the specified cost unit.

Excel Output Format

The Excel workbook has three worksheets:

•Number of companies selected.

•Parameters and their values.

•Printed sales invoice lines, including account manager, article and payment information.