S87 - Date of Last Sale/Purchase (Stock Control Report Generator variable)
From Catalyst
Syntax
S87{S/P, N/T, CCYYMMDD, A/C/D, depot}
Description
The Date the current stock was last sold or purchased.
Parameters
- S/P
- A text parameter that can be omitted (it defaults to "S").
- S
- From last sale.
- P
- From last purchase.
- N/T
- A text parameter that can be omitted (it defaults to "N").
- N
- Numeric result. This is the number of days since the first of January 1980. This is most commonly used for sorting purposes.
- T
- Text result. This is the date formatted for display, e.g. '01/01/2004'. You can optionally use the next parameter to control the exact format.
- CCYYMMDD
- A text parameter that can be omitted (it defaults to "DD/MM/CCYY").
- When the previous parameter is 'T', this parameter can be used to control the exact format. The following four values can be combined in any order, with separating characters if required.
- DD
- Day (01 to 31).
- MM
- Month (01 to 12).
- CC
- Century (19 or 20).
- YY
- Year (00 to 99).
|
- A/C/D
- A text parameter that can be omitted (it defaults to "A").
- A
- All depots (last sale/purchase from any depot)
- C
- Current depot (last sale/purchase from the current report depot)
- D
- Supplied depot (last sale/purchase from the supplied depot)
- depot
- A text parameter that can be omitted.
- Last sale/purchase for a specific depot.
- depot
- Filter by 'depot'.
Returns
A text or numeric (depending on the parameters) value whose typical size is 10 characters.