XINVVAL

XINVVAL - Value of inventory items on a given period

Description

 This function is only available for Sage 50 Canadian Edition

This function returns the inventory items value on a specific date.

Parameters

Inventory

Inventory item number for which the quantity variation is required.

Date [Optional]

Date at which the inventory items value is required.

When entering dates in Excel, use the format for your computer's regional settings, or use the ISO format (YYYY-MM-DD).

Locations [Optional]

Location name where the inventory items value is required.

Connections [Optional]

Sage 50 Connection to query. If left empty, the default connection will be used.

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, 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 inventory items value of inventory number C1020

=XINVVAL("C1020")

Returns the inventory items value of inventory number F2022 on June 30, 2015

=XINVVAL("F2022","30/06/2015").