XVendorOwing - Balance due to vendors for transactions made on a given period
Description
This function is only available for Sage 50 Canadian Edition
This function returns the balance due to vendors for transactions made on a specified period.
Parameters
- Vendors [Optional]
-
Vendor name for which the due balance is requested.
- AsOfDate [Optional]
-
Reference date at which the due balance is required.
When entering dates in Excel, use the format for your computer's regional settings, or use the ISO format (YYYY-MM-DD).
- StartingDays [Optional]
-
Number of days before the reference date mentioned in AsOfDate that establish the beginning of the period for which the due balance is required.
- EndingDays [Optional]
-
Number of days before the reference date mentioned in AsOfDate that establish the end of the period for which the due balance is required.
- Currency [Optional]
-
Currency code for which the due balance 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. 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 balance due to Ministry of Finance for transactions made on 30th of June 2015
- =XVendorOwing("Ministry of Finance","30/06/2015","30","60")