B04 - Batch Quantity (Stock Control Report Generator variable)
Syntax
B04{T/C/O/D, D1-D16, T/O/I}
Description
Calculates the batch quantity at the end of a given date or between 2 given dates depending on the parameters supplied.
Parameters
- T/C/O/D
- A text parameter that can be omitted (it defaults to "T").
- T
- Total Quantity. The batch quantity with all transactions taken into the calculation. This is usually the same as using the 'C' parameter if your user date is todays date.
- C
- Current Date. The current quantity of the batch from the date it was entered into the Stock Control to the end of the user date.
- O
- Original Date. The Opening balance of the Batch. This will be the quantity of the very first batch transaction.
- D
- Date Range. Used in conjunction with parameter D1-D16. Will calculate the batch quantity from the start date to the end date.
- D1-D16
- A text parameter that can be omitted.
- Restrict to a given date range.
- D1-D16
- Corresponds to the date range screen.
 | 'D1+1D' where 'D1' is the "date range" and '+1D' is the "date modifier". |
 | 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.
- T/O/I
- A text parameter that can be omitted.
- Movement filtering used in conjunction with parameter D1-D16.
- blank
- No filtering. Includes both internal and external stock movement. See B10.
| Any date range specified with parameter D1-D16 will be ignored. |
- T
- Only includes external stock movement. Both positive and negative transactions included.
- O
- Only includes external stock movement with a negative transaction value (Outgoing, eg. sales).
- I
- Only includes external stock movement with a positive transaction value (Incoming, eg. purchases).
Returns
A numeric value whose typical size is 8 digits plus 3 decimal places.
