Velixo recommends the use of Microsoft 365 for this feature. Experimentally, Excel 2010 or higher can be used. See the Prerequisites for additional information. |
Description
The EXPANDINVENTORYITEMRANGE function returns all inventory item codes within the specified range
Syntax
EXPANDINVENTORYITEMRANGE(Connection, Range)
The EXPANDINVENTORYITEMRANGE function uses the following parameters (see our article on Filtering Velixo functions):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Range | Optional | The range of item codes to include in the results |
Example
=EXPANDINVENTORYITEMRANGE("Demo", "AAM:C;-ACCOMMODATE;-ADMCHARGE")
Description
Returns all inventory item codes between AAM and C except ACCOMMODATE and ADMCHARGE
Result
Applies to
PM Module