XINV

XINV - Quantity of inventory items for a given period

Description

Sage 50 Canadian Edition  This function is only available for Sage 50 Canadian edition

This function returns the inventory items' quantity on a specific date.

Parameters

Inventory

Inventory item number for which the quantity is required.

Date [Optional]

Date at which the inventory items quantity is required.

Units [Optional]

Measurement unit name (stocking, selling or buying) in which the inventory items quantity is required.

Locations [Optional]

Location name where the inventory items quantity 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 an Excel cell address (ex. A1:B19) containing the information of the parameters requested in all Logicim 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 quantity of inventory item number C1020

=XINV("C1020")

Returns the quantity of inventory item number F2022 on June 30, 2015

=XINV("F2022","30/06/2015")

Posted: Tuesday, November 05, 2024

Related articles

No related articles found

Can't find what you're looking for?

You can Contact us so we can address your question.

Related information