<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Customer Functions > SLBalance() |
SLBalance( Company, Account, Period, ReturnForeignBalance )
This function will return the outstanding balance or movement for the selected account and period specified.
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
Account: This should be the customer account number. Multiple accounts can be specified in the format ABC001, ABC002, ABC003.
Period: This is a predefined keyword that represents the period to return the balance for. x - can be a period number from 1 to 13.
Month x - will return the current outstanding balance as at month specified
Last Year x - will return the outstanding balance as at the Last Year period specified
Net Month x - will return the net change in the balance outstanding for the period specified
Net Last Year x - will return the net change in the balance outstanding for the period last year
Year to Date x - will return the outstanding balance for the year to date up to the period specified
Last Year to Date x - will return the outstanding balance for last year to date up to the period specified
Year to Date x and Month x are interchangeable as both will return the outstanding balance up to the period specified
ReturnForeignBalance: If you set this to 1 the value returned will be the outstanding balance in foreign currency, anything else and the home currency balance will be returned.
The following will return the outstanding balance as at Month 1 in home currency
SLBalance( "c:\PastelData\_demo", "ACK001", "Month 1", 0 )
The following will return the outstanding balance as at Month 1 last year in home currency
SLBalance( "c:\PastelData\_demo", "ACK001", "Month 1", 0 )
The following will return the outstanding balance as at Month 1 for accounts ACK001 and AGC001
SLBalance( "c:\PastelData\_demo", "ACK001, AGC001", "Month 1", 0 )
|