V63 - Total nett expenses (Unit Sales Report Generator variable)
Syntax
V63{A/V/E/C/X, cat, D1-D16, filter, E/X/A}
Description
The total amount of expenses on this unit. An expenses breakdown can be used by using the 'E' variables. If the unit is In Stock and Unsold, and has an Expected Expenses figure entered that exceeds the Expenses incurred so far that will be returned instead, unless the 'A' parameter is added.
Parameters
- A/V/E/C/X
- A text parameter that can be omitted.
- blank
- If the unit is In Stock and Unsold, and has an Expected Expenses figure entered that exceeds the Total Expenses incurred so far, Expected Expenses are shown. Otherwise Total Expenses are shown. This simulates the behaviour of many system reports.
- A
- Forces the variable to show the Total Expenses incurred.
- V
- Forces the variable to show the Expenses incurred against just the unit. This excludes any Expenses flagged as "Extras & Accessories Expenses".
- E
- Forces the variable to show the Expenses incurred due to Extras & Accessories. This excludes any Expenses flagged as "Unit Expenses".
- C
- Forces the variable to show only the Cost of Extras & Accessories accompanying the Sale of the current unit.
- X
- Forces the variable to show the Expected Expenses figure entered manually in Unit Amendments. This may be used to report on whether you are predicting costs effectively, for example.
- cat
- A text parameter that can be omitted.
- If a category is given then this will be used as a filter for the result.
- D1-D16
- A text parameter that can be omitted.
- If a date range is given (using the date range screen) then it will act as a filter and only items within this range will appear in the report.
- 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.
- filter
- A text parameter that can be omitted.
- If a text string is given then it will act as a filter and only items where the string appears in the description will appear in the report. This parameter can have more than one word (but they must be in the correct order). The case of the text doesn't matter.
- E/X/A
- A text parameter that can be omitted (it defaults to "E").
- (Applicable for all values of parameter A/V/E/C/X except 'X'.)
- E
- Effective total - total of all Actual expenses, plus Expected expenses that have not been superseded by an Actual.
- X
- Expected total - total of all Expected expenses.
- A
- Actual total - total of only Actual expenses.
Returns
A numeric value whose typical size is 6 digits plus 2 decimal places.
|
|
