SALES ANALYSIS INQUIRY

Use this screen to review sales order information and associated order costs, sales, and calculated profit/loss margins. Detailed sales order line information, including invoices, labor, and subcontract costs, is displayed along with issues, shipping, and accounts receivable information.

You can limit the inquiry to sales orders for a particular project, catalog, or customer. You can refine the inquiry by selecting a sales order status code or combination of status codes. After you have chosen your order criteria and selected the Execute button on the toolbar, all sales orders in the system that match the criteria are displayed.

The revenue or sales numbers displayed in the inquiry screen are based on invoiced sales order items. The Sales Order Analysis subtask displays the sales analysis for the order as a whole using cumulative line data. Use the Sales History subtask to view the sales analysis for individual lines on the order.

All amounts will be in the functional and transaction currencies. However, if you are not using Costpoint Multicurrency, all columns relating to transactional currency will be hidden.

Use the Sales Analysis Inquiry screen whenever you need to review or revise the status of a sales order.

Project

To limit the inquiry to sales orders for a particular project, enter, or use Lookup to select, the project ID and then select the Execute button on the toolbar. You can refine your inquiry by selecting a sales order status code or combination of status codes from the Select SO Status group box. Leave the Project field blank before selecting the Execute button to include all sales orders in the system that match the selected status codes.

Catalog

To limit the inquiry to sales orders for a particular catalog, enter, or use Lookup to select, the catalog ID and then select the Execute button on the toolbar. You can refine your inquiry by selecting a sales order status code or combination of status codes from the Select SO Status group box. Leave the Catalog field blank before selecting Execute to include all sales orders in the system that match the selected status codes.

Trans Currency

To limit the inquiry to sales orders for a particular transaction currency, enter, or use Lookup to select, the transaction currency and then select the Execute button on the toolbar. You can refine your inquiry by selecting a sales order status code or combination of status codes from the Select SO Status group box. Leave the Trans Currency field blank before selecting Execute to include all sales orders in the system that match the selected status codes.

Customer

To limit the inquiry to sales orders for a particular customer, enter, or use Lookup to select, the customer ID and then select the Execute button on the toolbar. You can refine your inquiry by selecting a sales order status code or combination of status codes from the Select SO Status group box. Leave the Customer field blank before selecting Execute to include all sales orders in the system that match the selected status codes.

Sales Order

To limit the inquiry to a particular sales order, enter, or use Lookup to select, the sales order ID and then select the Execute button on the toolbar. Leave the Sales Order field blank before selecting Execute to include all sales orders in the system that match the selected status codes.

Rel

This field displays the release number associated with the sales order ID.

Select SO Status

Use the options in this group box to retrieve a sales order or group of sales orders: Pending, In Approval, Approved, Rejected, Closed, Void, and Sys Closed. You can use these status codes in conjunction with a value entered in the Project, Catalog, Customer, or Sales Order fields, or you can base your inquiry solely on one or more status codes. After selecting the status code(s) checkboxes on which to base your inquiry, select the Execute button on the toolbar to display the related sales orders.

Type

This group box is currently unavailable.

Table Window

SO

This field displays the sales order ID.

Rel

This field displays the release number associated with the sales order ID.

Status

This field displays the sales order status.

Approval Process

This field displays the approval process for the sales order if approvals are required; otherwise, this field is blank.

Type

This field displays the only available type code, "S" (Sales order). Other codes will display when options such as change orders, blanket orders, and release orders are added in a future version of Costpoint.

Customer, Customer Name

These fields display the customer ID and customer's name from the sales order.

Price Project

This field displays the price project ID, if selected on the sales order.

Price Catalog

This field displays the price catalog ID, if selected on the sales order.

Sales Rep, Sales Rep Name

These fields display the sales representative's ID, if selected on the sales order, and the representative's name.

Order Date

This field displays the date on which the sales order was created.

SO Total Amt

This field displays the sales order's total dollar amount, including line charges and taxes.

Trans Currency

This field displays the transactional currency of the sales order line item.

Trans Currency SO Total Amt

This field displays the total amount of the sales order line item listed in transactional currency.

Sales Analysis

Select this pushbutton to view the sales analysis for the order as a whole using cumulative line information.

SO Lines

Select this pushbutton to view individual line information for a selected sales order row.

Exchange Rate

Select this pushbutton to view exchange rate information for the sales order row.