RIS-SC-1001

Order Invoice Printing History

Description

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.
image 13
male female graphic designers interacting computer
female web designer taking notes office
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.

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.

Reported Values

The report returns the following values:
Column NameDescription
nOrderIdThe ID of the order.

HistoryNoteNotes or comments associated with the order's history.
DateStampTimestamp of the action (when the invoice was printed).
UpdatedByUser who updated the order.
young team coworkers working project

Parameters

@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’.

@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’.