Order Invoice Printing History
Home || Linnworks || Order Invoice Printing History
Description
RIS-SC-1001 Order Invoice Printing History
This query retrieves information about orders where an invoice has been printed within a specific time range. It includes the order ID, history note, timestamp of the action, and the user.
How to generate the report: a step-by-step guide
- 1. Select the Order Invoice Printing History report in the Query type drop-down menu.
- 2. Click the calendar icon to select From and To dates.
- 3. Click the Generate Report button.
- 4. Select the Time Zone and click the Download (CSV file) button when downloading the report.
Reported Values
The report returns the following values:
Column Name | Description |
---|---|
nOrderId | The ID of the order. |
HistoryNote | Notes or comments associated with the order's history. |
DateStamp | Timestamp of the action (when the invoice was printed). |
UpdatedBy | User who updated the order. |
Parameters
- 1. @fromDate: Specifies the start date and time from which the query should retrieve data. The default value is '2022/11/07 00:00:00.000'.
- 2. @toDate: Specifies the end date and time until which the query should retrieve data. The default value is '2022/11/07 18:00:00.000'.
Summary
This query fetches order details where an invoice has been printed between the specified start and end dates. It provides essential information such as the order ID, relevant notes, timestamp of the action, and the user responsible for updating the order. The data retrieved can be useful for tracking invoice printing activities within a given time frame.