Sales Orders > Sales Invoice Query

Sales Invoice Query

You use this program to view detailed information on invoices and debit/credit notes created in the Sales Order module.

Toolbar and menu

Field Description
Options  
Preferences Configures options that will determine the level of detail you want to view within the query.
Sequence These options enable you to view invoice information by invoice number, sales order number or customer code
Invoice Enter the invoice number you want to query.
Sales order Enter the sales order number for which you want to view the invoice information (if you are sequencing the query by sales order).
Customer Enter the customer code for which you want to view the invoice information (if you are sequencing the query by customer).

Preferences

Invoice Selection

Field Description
Invoice Selection  
Invoice from order Includes invoices created from normal sales orders in the query.
Dispatch invoice Includes dispatch invoices in the query.
Consolidated dispatch invoice Includes consolidated dispatch invoices in the query.
SCT Includes invoices created from Supply Chain Transfers in the query.
Dispatch SCT Includes dispatch Supply Chain Transfer invoices in the query.

Detail Lines Selection

Field Description
Detail Lines Selection  
Stocked detail Includes information for stocked order lines in the Detail Lines pane.
Non-stocked detail Includes information for non-stocked order lines in the Detail Lines pane.
Freight Includes information for freight change order lines in the Detail Lines pane.
Other charges Includes information for miscellaneous charge order lines in the Detail Lines pane.
Comments Includes comment order lines in the Detail Lines pane.
Include  
Consolidated lines for consolidated dispatch invoice Includes consolidated dispatch note lines in the Detail Lines pane.

General

Field Description
Default sales order query sequence  
Invoice Defaults to querying the information by invoice number.
Sales order Defaults to querying the information by sales order number.
Customer Defaults to querying the information by customer number.

Notes and warnings

Restrictions and limits

  • Cost and profit values are only displayed if you enabled the Display costs and gross profit in order totals setup option (Sales Order Setup).

Viewing considerations

  • The information for this query is generated from the following invoice reprint files:

    • Sales order invoices
    • Dispatch invoices
    • Consolidated Dispatch Invoices

    The period for which information can be queried for these files is determined by your entry at the Number of days to retain Reprint file setup option (Sales Order Setup).

  • The title of panes within this program changes to reflect whether you highlighted the Sales Order Invoice, Dispatch Invoice or Consolidated Dispatch Invoice panes.

  • The RMA number on an invoice is the RMA number that created the order, so it is displayed for an exchange, a cross shipment or a credit invoice.

    The RMA number is not displayed for the original invoice because you can create many RMAs from a single invoice.

Custom forms

  • Invoice custom form data is created when an Order or Dispatch invoice is printed (Document Print). It is taken from the Order custom form if the Save custom form for reprinting with invoice is enabled for Sales orders (Sales Order Setup) or from the Dispatch note custom form if the Save custom form for reprinting with dispatch invoice is enabled for Dispatch notes (Dispatch Notes Setup).

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.