Difference between revisions of "S96 - Quantity on Sales Order (Stock Control Report Generator variable)"
(Updated from revision control) |
(Updated from revision control) |
||
Line 12: | Line 12: | ||
:;D1-D16 | :;D1-D16 | ||
::Corresponds to the date range screen. | ::Corresponds to the date range screen. | ||
+ | {{Note|text= | ||
+ | This date range can be modified by using one of the following date modifiers after the date indicator. | ||
+ | }} | ||
+ | |||
+ | === Date Modifiers === | ||
+ | ==== With offset ==== | ||
+ | Eg. {{DataValue|+1D}}, {{DataValue|1Y}}, {{DataValue|-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 {{DataValue|-}} before the number. | ||
+ | |||
+ | {{Tip|text= | ||
+ | A combination of units can be used. E.g. {{DataValue|-1Y+1M}} would subtract 1 year and then add 1 month. Of course you could just subtract 11 months ({{DataValue|-11M}}). | ||
+ | |||
+ | }} | ||
+ | |||
+ | {{Note|text= | ||
+ | {{DataValue|Month}} will be used as default. E.g. {{DataValue|+2}} will be interpreted as {{DataValue|+2M}} and {{DataValue|-2}} as {{DataValue|-2M}}. | ||
+ | |||
+ | }} | ||
+ | |||
+ | ==== Without offset ==== | ||
+ | Eg. {{DataValue|+}}, {{DataValue|D}}, {{DataValue|<nowiki>=</nowiki>}} | ||
+ | |||
+ | ;= | ||
+ | :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. {{DataValue|<nowiki>=--</nowiki>}} would subtract 2 days from the current user date. Another way to write that would be {{DataValue|<nowiki>=-2D</nowiki>}}. | ||
+ | |||
+ | {{Example|text= | ||
+ | ;{{DataValue|+1D}}, {{DataValue|+}} | ||
+ | :Add one day from the date supplied. | ||
+ | ;{{DataValue|<nowiki>=+1D</nowiki>}}, {{DataValue|<nowiki>=+</nowiki>}} | ||
+ | :Add one day from the user date. | ||
+ | ;{{DataValue|<nowiki>=-3MH</nowiki>}} | ||
+ | :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 | ;E1-E16 | ||
:A text parameter that can be omitted. | :A text parameter that can be omitted. | ||
Line 17: | Line 80: | ||
:;E1-E16 | :;E1-E16 | ||
::Corresponds to the date range screen. | ::Corresponds to the date range screen. | ||
+ | {{Note|text= | ||
+ | This date range can be modified by using one of the following date modifiers after the date indicator. | ||
+ | }} | ||
+ | |||
+ | === Date Modifiers === | ||
+ | ==== With offset ==== | ||
+ | Eg. {{DataValue|+1D}}, {{DataValue|1Y}}, {{DataValue|-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 {{DataValue|-}} before the number. | ||
+ | |||
+ | {{Tip|text= | ||
+ | A combination of units can be used. E.g. {{DataValue|-1Y+1M}} would subtract 1 year and then add 1 month. Of course you could just subtract 11 months ({{DataValue|-11M}}). | ||
+ | |||
+ | }} | ||
+ | |||
+ | {{Note|text= | ||
+ | {{DataValue|Month}} will be used as default. E.g. {{DataValue|+2}} will be interpreted as {{DataValue|+2M}} and {{DataValue|-2}} as {{DataValue|-2M}}. | ||
+ | |||
+ | }} | ||
+ | |||
+ | ==== Without offset ==== | ||
+ | Eg. {{DataValue|+}}, {{DataValue|D}}, {{DataValue|<nowiki>=</nowiki>}} | ||
+ | |||
+ | ;= | ||
+ | :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. {{DataValue|<nowiki>=--</nowiki>}} would subtract 2 days from the current user date. Another way to write that would be {{DataValue|<nowiki>=-2D</nowiki>}}. | ||
+ | |||
+ | {{Example|text= | ||
+ | ;{{DataValue|+1D}}, {{DataValue|+}} | ||
+ | :Add one day from the date supplied. | ||
+ | ;{{DataValue|<nowiki>=+1D</nowiki>}}, {{DataValue|<nowiki>=+</nowiki>}} | ||
+ | :Add one day from the user date. | ||
+ | ;{{DataValue|<nowiki>=-3MH</nowiki>}} | ||
+ | :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 | ;N/C/O | ||
:A text parameter that can be omitted. | :A text parameter that can be omitted. |
Latest revision as of 05:45, 3 July 2018
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.