<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Sales Analysis > SABalance() |
SABalance( Company, Code, Period )
This function will return the sales analysis balance for the specified code and period.
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.
Code: Enter the salesperson or sales analysis code to return the information for
Period: This should be one of the following period keywords
Month x - will return the balance for the specified period
Year to Date x - will return the total balance up to and including the specified period
Last Year Month x - will return the balance for the specified period last year
Last Year To Date x - will return the total balance up to and including the specified period for last year
The following will return the balance for period 3 from analysis code 00001
SABalance( "c:\PastelData\_demo", "00001", "Month 3" )
The following will return the total balance up to and including period 5 this year for code 00001
SABalance( "c:\PastelData\_demo", "00001", "Year To Date 5" )
The following will return the total balance for last year up to and including period 5 for code 00001
SABalance( "c:\PastelData\_demo", "00001", "Last Year To Date 5" )
|