XVendorOrder

XVendorOrder - Total of all vendors orders amounts between given periods

Description

  This function is only available for Sage 50 Canadian edition

This function returns the sum of all vendor's order amounts made between two specific dates.

Parameters

Vendors [Optional]

Vendor name for which the sum of all order amounts is required.

Beginning [Optional]

Beginning date of the period for which the sum of all orders amounts 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 sum of all orders amounts is required.

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

Status [Optional]

Order status required: initial order, received order or remaining order. By default the remaining order amount is returned.

Accounts [Optional]

General Ledger account number or name for which the sum of all orders amounts is required.

Departments [Optional]

Department code or name for which the sum of all order amounts is required.

Inventory [Optional]

Inventory items number for which the sum of all orders amounts is required.

Projects [Optional]

Project name for which the budget is requested.

Freight [Optional]

Included to obtain the sum of all order amounts, including freight fees, or Excluded to exclude freight fees.

Currency [Optional]

Currency code for which the sum of all order amounts is required, for example, CAD or USD.

Connections [Optional]

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

Usage

All past and future transactions can be considered in this function. You just need to mention the beginning of the first transaction date and the end of the last transaction date. The function XVendorOrder will calculate the sum of all order amounts 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 vendors' names, dates, account numbers, department codes, 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 total of all Classic Catering orders amounts made in account number 5020 between January 1st and December 31st of 2006, including freight fee

=XVendorOrder ("Classic Catering","01/01/2006","31/12/2006","Initial Order", "5020",,,,,,"Included")