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

From Catalyst
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.
This date range can be modified by using one of the following date modifiers after the date indicator.

Date Modifiers

With offset

Eg. '+1D', '1Y', '-1Y'

D
Days
M
Months
Y
Years

If you want to add a unit to the date then you should just use the number you want to add and if you want to subtract the units from the date just use a '-' before the number.

A combination of units can be used. E.g. '-1Y+1M' would subtract 1 year and then add 1 month. Of course you could just subtract 11 months ('-11M').
'Month' will be used as default. E.g. '+2' will be interpreted as '+2M' and '-2' as '-2M'.

Without offset

Eg. '+', 'D', '='

=
User Date
.
Machine Date
-
Previous Day
+
Next Day
M
First day of the current month.
H
Last day of the current month.
Y
First day of the current year.
R
Last day of the current year.
W
First day of the current week (Mon).
K
Last day of the current week (Sun).

A combination of units can be used. E.g. '=--' would subtract 2 days from the current user date. Another way to write that would be '=-2D'.

'+1D', '+'
Add one day from the date supplied.
'=+1D', '=+'
Add one day from the user date.
'=-3MH'
The last day in the month three months from the user date.

Note

If you are using the year or month units you should note if the date supplied was the last day in a month that doesn't exist in the new year calculated the last day in the new month will be used. So don't worry if you add one year to a february date that was set to the last day of that february. The 29th of february in a leap year would be converted to the 28th of february in the new calculated year, unless of course you were adding a multiple of four years to the date, in this case the 29th february would be kept.

E1-E16
A text parameter that can be omitted.
Expected due in given date range.
E1-E16
Corresponds to the date range screen.
This date range can be modified by using one of the following date modifiers after the date indicator.

Date Modifiers

With offset

Eg. '+1D', '1Y', '-1Y'

D
Days
M
Months
Y
Years

If you want to add a unit to the date then you should just use the number you want to add and if you want to subtract the units from the date just use a '-' before the number.

A combination of units can be used. E.g. '-1Y+1M' would subtract 1 year and then add 1 month. Of course you could just subtract 11 months ('-11M').
'Month' will be used as default. E.g. '+2' will be interpreted as '+2M' and '-2' as '-2M'.

Without offset

Eg. '+', 'D', '='

=
User Date
.
Machine Date
-
Previous Day
+
Next Day
M
First day of the current month.
H
Last day of the current month.
Y
First day of the current year.
R
Last day of the current year.
W
First day of the current week (Mon).
K
Last day of the current week (Sun).

A combination of units can be used. E.g. '=--' would subtract 2 days from the current user date. Another way to write that would be '=-2D'.

'+1D', '+'
Add one day from the date supplied.
'=+1D', '=+'
Add one day from the user date.
'=-3MH'
The last day in the month three months from the user date.

Note

If you are using the year or month units you should note if the date supplied was the last day in a month that doesn't exist in the new year calculated the last day in the new month will be used. So don't worry if you add one year to a february date that was set to the last day of that february. The 29th of february in a leap year would be converted to the 28th of february in the new calculated year, unless of course you were adding a multiple of four years to the date, in this case the 29th february would be kept.

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.