XCustomerQuote

XCustomerOwing() - Total quote amounts for customers transactions for a given period

Description

  This function is only available for Sage 50 Canadian edition

This function returns the sum of all quote amounts made for customers between two specific dates.

Parameters

Customers [Optional]

Customer name for which the sum of all quotes amounts is requested.

By default, when this parameter remains empty, the sum of all customers' quote amounts will be generated.

Beginning [Optional]

Beginning date of the period for which the sum of all quote amounts is requested.

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 quote amounts is requested.

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

Accounts [Optional]

General Ledger account number or name for which the sum of all quote amounts is requested.

If this parameter remains empty, the Current Earnings value will be reported.

See Accounts Parameter for more information on how you can use this parameter.

Departments [Optional]

Department code or name for which the sum of all quote amounts is requested.

If this parameter remains empty, only the Accounts parameter will be used.

See Departments Parameter for more information on how you can use this parameter.

Employees [Optional]

Employee name for which the sum of all quote amounts is requested.

Inventory [Optional]

Inventory items number for which the sum of all quote amounts is requested.

Freight [Optional]

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

Currency [Optional]

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

Connections [Optional]

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

Usage

All past and future transactions can be considered in this function. You just need to mention at the beginning the first transaction date and at the end the last transaction date. The function XCustomerQuote will calculate the sum of all quote 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 customers' names, dates, account numbers, department codes, employees' names, 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 sum of all quote amounts made for Kent industries Inc. in the account number "4010-4090"

=XCustomerQuote("Kent Industries Inc.",,,"4010-4090")

Returns the sum of all quote amounts made for Kent industries Inc. in account number 4020 between January 1st and December 31st of 2006, including the freight fee

=XCustomerQuote("Kent Industries Inc.","01/01/2006","31/12/2006","4020",,,,,,"Included")