XVendorQuote - Total of all vendors quotes amounts received between given periods
Description
This function is only available for Sage 50 Canadian Edition
This function returns the sum of all vendors quotes amounts received between two specific dates.
Parameters
- Vendors [Optional]
-
Vendor name for which the sum of all quotes amounts is required.
- Beginning [Optional]
-
Beginning date of the period for which the sum of all quotes 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 quotes 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).
- Accounts [Optional]
-
General Ledger account number or name for which the sum of all quotes amounts is required.
- Departments [Optional]
-
Department code or name for which the sum of all quotes amounts is required.
- Inventory [Optional]
-
Inventory items number for which the sum of all quotes amounts is required.
- Freight [Optional]
-
Included to obtain the sum of all quotes amounts including freight fees or Excluded to exclude freight fees.
- Currency [Optional]
-
Currency code for which the sum of all quotes 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 or future transaction can be considered in this function. You just need to mention in AsOfDate the reference date of your choice. The function XVendorOwing will generate the balance due to vendors for transactions made on the period established by AsOfDate, StartingDays and EndingDays parameters.
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: vendors names, dates, accounts numbers, departments 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 sum of all amounts from Classic Catering quotes made in the account number 5020 between January 1st and December 31st of 2006 including freight fee
- =XVendorQuote("Classic Catering","01/01/2006","31/12/2006","5020",,,,,,"Included")