XCustomerOwing

XCustomerOwing() - Balance due from customers at a given date

Description

  This function is only available for Sage 50 Canadian edition

This function returns the balance due from customers for transactions prior to a given date.

Parameters

Customers [Optional]

Customer name for which the balance due is requested.

AsOfDate [Optional]

Reference date at which the balance due is requested.

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 requested. Ex: 30 days before AsOfDate.

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 requested. Ex: 60 days before AsOfDate.

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 utilized.

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 XCustomerOwing will generate the balance due from customers 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 customers' 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 for Gigi's pasta & pizza

=XCustomerOwing("Gigi's Pasta & Pizza")

Returns the balance due for Gigi's pasta & pizza as of June 30, 2015, for transactions between 30 and 60 days old.

=XCustomerOwing("Gigi's Pasta & Pizza","30/06/2015","30","60")

Remarks

StartingDays and EndingDays are interchangeable. The XCustomerOwing function will use the smallest value as beginning of the period and the greatest value for the end of the period.