XINVVALP - Value of inventory items between given periods
Description
This function is only available for Sage 50 Canadian Edition
This function returns the value variation of inventory items between two specific dates.
Parameters
- Inventory
-
Inventory item number for which the value variation is required.
- Beginning [Optional]
-
Beginning date of the period for which the value variation of inventory items is required.
When entering dates in Excel, use the format for your computer's regional settings, or use the ISO format (YYYY-MM-DD).
- End [Optional]
-
Ending date of the period for which the value variation of inventory items is required.
When entering dates in Excel, use the format for your computer's regional settings, or use the ISO format (YYYY-MM-DD).
- Journals [Optional]
-
Journal name for which the value variation of inventory items is required.
- In/Out [Optional]
-
In to obtain the items value added to the inventory or Out to obtain the decreased value inventory items.
- Locations [Optional]
-
Location name where the value variation of inventory items is required.
- Departments [Optional]
-
Department code or name related to the value variation of inventory items required.
- Vendors [Optional]
-
Vendor name related to the value variation of inventory items required.
- Customers [Optional]
-
Customer name related to the value variation of inventory items required.
- Employees [Optional]
-
Employee name related to the value variation of inventory items required.
- Projects [Optional]
-
Project name for which the value value of inventory items is required.
- Connections [Optional]
-
Sage 50 Connection to query. If left empty, the default connection will be used.
Usage
All past or future inventory items variation can be considered in this function. You just need to mention in Beginning the first inventory items variation date and in End the last inventory items variation date. The function XINVVALP will generate the value of the inventory items of all variations between those dates.
Examples
It is strongly recommended to use Excel cells address (ex. A1:B19) containing the information of the parameters requested in all XLGL functions, such as: stocks, dates, units, locations, departments, vendors, etc. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.
- Returns the C1020 items value variation
- =XINVVALP("C1020")
- Returns the C1020 items value variation between January 1st 2006 and the last inventory variation in the books
- =XINVVALP("C1020","01/01/2006")
- Returns the F2022 items value variation between June 30th 2015 and October 30th 2015 inventory variation in the books for journal name "Sales"
- =XINVVALP("F2022","30/06/2015","30/10/2015","Sales")