XVendorOwing

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 transactions 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 an Excel cell address (ex. A1:B19) containing the information of the parameters requested in all Logicim 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 the ministry of finance for transactions made on 30th of June 2015

=XVendorOwing("Ministry of Finance","30/06/2015","30","60")