Generating sales order audit trail report

Introduction

This screen allows you to generate an audit trail report for all the sales orders.

Menu path

Order/Statistics/Audit trail

Description

Type section

Normal

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.

Reversed

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. 

General section

Warehouse

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.

Sales order date

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.

Payment date

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.

Selection code

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.

Show all section

If you have selected Normal under the Type section, the following options are displayed:

Show: Transactions

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.

Incomplete

Select this check box to view the sales orders that have not been completely fulfilled or invoiced.

Not paid

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:

Incomplete

Select this check box to view sales orders with order amounts that are different from the invoice amounts.

POS invoice

Select this check box if you want the amount in Point of Sale invoices to be added to the invoice amount.

Commission invoice

Select this check box if you want the amount in commission invoices to be added to the invoice amount.

Credit notes

Select this check box if you want the amount in credit notes to be added to the invoice amount.

Button

Display

Click this to view the report based on the defined criteria. For more information, see Sales order audit trail report.

Close 

Click this to exit. 

Related document