<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Customer Functions > SLSales() |
SLSales( Company, Account, Period )
This function will return the sales for the given account 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.
Account: This should be the customer account number. Multiple accounts can be specified in the format ABC001, ABC002, ABC003
Period: This should be the period that you wish to return sales for. The period can be one of the following keywords. x - can be a period from 1 to 13.
Year to Date x - Sales for the year up to and including the period specified
Last Year to Date x - Sales for the last year up to and including the period specified
Month x - Sales for the period specified
Last Year x - Sales for the period of the last year specified
The following will return the total sales for this year
SLSales( "c:\PastelData\_demo", "ACK001", "Year To Date 12" )
The following will return the total sales for last year
SLSales( "c:\PastelData\_demo", "ACK001", "Last Year To Date 12")
The following will return the sales for Month 1 only
SLSales("c:\PastelData\_demo", "ACK001", "Month 1" )
|