XINVVALP

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 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 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 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 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")