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 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 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 Excel cells address (ex. A1:B19) containing the information of the parameters requested in all 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.