S96 - Quantity on Sales Order (Stock Control Report Generator variable)
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'.
|
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'.
|
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.