This screen allows you to generate an audit trail report for all the sales orders.
Order/Statistics/Audit trail
Select this to view the sales orders, deliveries, generated invoices, and payments based on the sales order date. This option displays the sales order processes from the time the sales orders were created until payment was made for the sales orders. By default, this is selected.
Select this to view the sales orders based on the payment date. This option displays the end of the sales order process flow first such as the payment amount followed by the start of the sales order process flow such as the ordered amount.
Note: Only sales orders that are partially or fully paid will be displayed.
Select the warehouse to display sales orders with the selected warehouse.
Note: This box is available only if you have E-Warehouse Management in your license.
Type or select the start date and end date to display sales orders that were created within that period.
Note: Both the start and end dates must be selected. If you select or type the start date or end date only, the other date will be filled in automatically with the current date when you click Display. This box is available only if Normal is selected under the Type section.
Type or select the start date and end date to display sales orders with payments made within that period.
Note: Both the start and end dates must be selected. If you select or type the start date or end date only, the other date will be filled in automatically with the current date when you click Display. Also, this box is available only if Reversed is selected under the Type section.
Click this to select the selection code of the sales orders to be displayed. A green check mark and “In use” is displayed once a selection code is selected.
Note: This button is available only if Normal is selected under the Type section. The selection code of the sales orders is based on the Selection code defined in the conditions screen (go to Order/Entries/Sales orders, select the relevant sales order, click Open, and then click Conditions), under the Analytical group section. You can also define selection codes at System/Logistics/Selection codes.
If you have selected Normal under the Type section, the following options are displayed:
Select this check box to display the Transaction XXX column (the column name depends on the default currency you use) in the report. The amount in this extra column is based on the amount posted (financial posting) for the sales order.
Note: “XXX” represents the default currency used in the system.
Select this check box to view the sales orders that have not been completely fulfilled or invoiced.
Select this check box to display sales orders that have not received payments.
If you have selected Reversed under the Type section, the following options are displayed:
Select this check box to view sales orders with order amounts that are different from the invoice amounts.
Select this check box if you want the amount in Point of Sale invoices to be added to the invoice amount.
Select this check box if you want the amount in commission invoices to be added to the invoice amount.
Select this check box if you want the amount in credit notes to be added to the invoice amount.
Click this to view the report based on the defined criteria. For more information, see Sales order audit trail report.
Click this to exit.