S96 - Quantity on Sales Order (Stock Control Report Generator variable)

From Catalyst
Revision as of 05:56, 27 October 2017 by ThrashBot (talk | contribs) (Updated from revision control)
Jump to: navigation, search

Syntax

S96{D1-D16, E1-E16, N/C/O, depot, N/Y}

Description

Quantity of a stock item which is allocated on the " Sales Order Processing" but has not been completed.

Parameters

D1-D16
A text parameter that can be omitted.
Order placed in given date range.
D1-D16
Corresponds to the date range screen.
E1-E16
A text parameter that can be omitted.
Expected due in given date range.
E1-E16
Corresponds to the date range screen.
N/C/O
A text parameter that can be omitted.
Select only certain Item Types.
blank
All items (No filter).
N
"Normal" Items.
C
"Contract" Items.
O
"Call Off" Items.
depot
A text parameter that can be omitted.
Quantity on order for a specific depot.
blank
All items at all depots. (No depot filter).
depot
Filter by 'depot'.
N/Y
A text parameter that can be omitted (it defaults to "N").
Only include sales orders within the just in time horizon or all outstanding orders.
N
All sales orders.
Y
Only orders within just in time horizon.

Returns

A numeric value whose typical size is 6 digits plus 2 decimal places.