XINVP

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 item variations can be considered in this function. You just need to mention in the beginning the first inventory item variation date and at the end the last inventory item 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 Logicim 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")