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