XINVP - Quantity variation of inventory items between given periods
Description
This function is only available for Sage 50 Canadian Edition
This function returns the quantity variation of inventory items between two specific dates.
Parameters
- Inventory
-
Inventory item number for which the quantity variation is required.
- Beginning [Optional]
-
Beginning date of the period for which the quantity 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 quantity 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 quantity variation of inventory items is required.
- In/Out [Optional]
-
In to obtain the items quantity added to the inventory or Out to obtain the decreased quantity inventory items.
- Units [Optional]
-
Measurement unit name (stocking, selling or buying) in which the quantity variation is required.
- Locations [Optional]
-
Location name where the quantity variation of inventory items is required.
- Departments [Optional]
-
Department code or name related to the quantity variation of inventory items required.
- Vendors [Optional]
-
Vendor name related to the quantity variation of inventory items required.
- Customers [Optional]
-
Customer name related to the quantity variation of inventory items required.
- Employees [Optional]
-
Employee name related to the quantity variation of inventory items required.
- Projects [Optional]
-
Project name for which the quantity variation 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 XINVP will generate the quantity 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 items quantity variation of inventory number C1020 between January 1st 2006 and the last inventory variation in the books
- =XINVP("C1020","01/01/2006")