Inventory > Inventory Query > Sales Orders for Stock Code

Sales Orders for Stock Code

You use this program to view customer orders that have been placed for a stock item.

Toolbar and menu

Field Description
Options  
Change Company

Select this to view sales orders for a different company.

This option is only enabled if multiple companies are sharing the same inventory files (Company Maintenance - Options tab).

Functions

See also: Notes and warnings.

Lot Numbers Select this to use the Lot, Bin, Serial Allocations program to view any lot allocations made for the currently highlighted sales order line.
Serial Numbers Select this to use the Lot, Bin, Serial Allocations program to view any serial number allocations for the currently highlighted sales order line.

This option is disabled if the stock item is traceable, as the serials are inextricably linked to the lot number and are therefore queried via the lot number.

Dispatch Notes Select this to use the Dispatch Notes program to view any dispatch notes created for the currently highlighted sales order line.
Bins Select this to use the Lot, Bin, Serial Allocations program to view any bin allocations for the currently highlighted sales order line

This option is disabled if the stock item is traceable, as the bins are inextricably linked to the lot number and are therefore queried via the lot number.

Reserved Allocations Select this to use the Lot, Bin, Serial Allocations program to view any lots, bins and serials allocated to reserved stock.

Stock is placed in reserve using the Sales Order Entry program. If lot, bin and serial information was entered at that time (see SO Reserve or Ship Stock), then that information is displayed.

Change Company

This screen is displayed when you select the Change Company option from the Options menu,

Field Description
Display sales orders for company Indicate the company for which you want to view sales orders for the selected stock code.
OK Select this to accept the company you entered and to return to the listview.
Cancel Select this to return to the listview without changing the company.

Sales Orders

[Note]

The options in the Sales Order Selection pane enable you to indicate your preferences for displaying sales orders in the Sales Orders listview (see Sales Order Selection).

Field Description
More lines Select this to display the next set of rows according to the number of rows you selected to display at the Rows option.

This function is only enabled when there are more rows to display and is not enabled when you select to display All rows.

Rows Indicate the number of rows you want to display in the listview.

This is useful if you have a large amount of data. Filtering the number of rows to display, as opposed displaying all rows, means that the data is loaded more quickly in the listview.

Listview

When you select the Sales Orders for Stock Code program, the sales orders currently defined are displayed in a listview.

Column Description
Sales order This indicates the sales order number.
Status This indicates the current status of the sales order (see Status Codes).
Order quantity This indicates the quantity of the stock item ordered.
Unit of measure This indicates the unit of measure for the order quantity.
Warehouse This indicates the warehouse from which the item must be shipped.
Ship quantity This indicates the quantity of the stock item shipped.
Backorder quantity This indicates the quantity of the stock item currently on backorder.
Customer This indicates the code of the customer for the sales order.
Customer name This indicates the name of the customer for the sales order.
Purchase order number

This indicates the Purchase Order number created for insufficient stock (see Insufficient Stock/Back Order).

This is only displayed until the Purchase Order is receipted. Once the purchase order receipt has been completed and the order updated, there is no longer a link from the sales order to the purchase order.

Price This indicates the price of the item.
Price unit of measure This indicates the unit of measure for the price.
Allocated

This indicates whether the Inventory module has raised allocations to reserve stock for the transaction.

Stock items defined as Kit types are not actually stocked (their components are stocked), so for Inventory purpose, the allocated quantity reflects as zero allocated to sales orders and to back orders.

When sales orders are created, Inventory allocations are done to reserve stock. Items with no allocations are:

  • Unallocated scheduled order back order and ship quantities
  • Forward orders
Rev This indicates the revision of the item. This only applies if the item is defined as ECC controlled (Stock Code Maintenance).
Rel This indicates the release of the item. This only applies if the item is defined as ECC controlled (Stock Code Maintenance).
Request date This indicates when the customer expects delivery of the merchandise
Date entered This represents the date on which the order was processed in SYSPRO.
Date ordered This represents the date on which the customer placed the order.

Sales Order Selection

The options on this pane enable you to indicate your preferences for displaying sales orders in the Sales Orders listview.

Field Description
Refresh Sales Orders Select this to redisplay the information in the Sales Orders listview to reflect changes you made to the options in this pane.

This function is only enabled when you make a change to the selections.

Autoload Values

Load Previous Form Values

Select this to set all selections as they were when last you ran this program. This option overrides any default form values.

Save Form Values as Default

Select this to save your selections in this pane as your default preferences for your operator code.

Save Form Values for this Company

Select this to save your selections in this pane as the default preferences for the current SYSPRO company.

Remove Default Form Values

Select this to remove all settings you applied to your operator code when you used the Save Form Values as Default option.

All selections in the pane are restored to the form's default preference selections.

This option is only enabled once you select the Save Form Values as Default option.

Remove Company Form Values

Select this to remove all settings you applied to the SYSPRO company when you used the Save Form Values for this Company option.

All selections in the pane are restored to the form's default preference selections.

This option is only enabled once you select the Save Form Values for this Company option.

Customers  
Customer selection

This enables you to display orders for all customers or a specific customer.

You cannot access the Customer selection field when viewing sales orders for a different company or if you selected to view supply chain transfers only.

Display options  
Supply chain transfers only Select this to display only orders that were generated from supply chain transfers.
Include completed sales order lines Select this to view completed order lines for sales orders that are not yet complete (i.e. Excluding orders in a status of <9>).
Include completed sales orders Select this to include order lines for orders that are complete (i.e. Orders that are in a status of <9>).
Engineering change controls  
ECC selection

Indicate whether you want to display sales orders for all or a single revision/release of the stock item.

This is available only if the item is ECC-controlled and the stock control level is by Revision or Release (Bill of Materials Setup - Engineering Change Control tab).

The wording displayed for these fields defaults to Revision/Release, but is replaced by whatever wording you have assigned to these user-defined fields (Bill of Materials Setup).

Revision Indicate the single revision for which you want to display sales orders in the listview.
Release Indicate the single release for which you want to display sales orders in the listview.

Notes and warnings

Program access

Restrictions and limits

  • You cannot view any lot numbers, serial numbers, dispatch notes or bins when viewing sales orders for a different company. The Lot Numbers, Serial Numbers, Dispatch Notes and Bins functions are disabled.

  • Any operator security access defined against warehouses or Accounts Receivable branches (where browses are being filtered) is applied when viewing sales orders for another company.

  • You cannot view serial information against a completed sales order. Once an order is invoiced, the serials are defined against the invoice and no longer against the sales order.