<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICSale() |
ICSale( Company, ItemCode, Store, Period )
This function will return the stock sales for the item code, store and period specified.
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\pastel8\_demo would enable you to retrieve information from the Pastel Partner demo company.
ItemCode: Enter the item code that you wish to return the stock sales for.
Store: Enter the store code (if applicable) to return the stock sales for.
Period: This should be one of the of the period keywords shown below.
Month x - return the sales for the month specified
Year to Date x - return the total sales up to and including the period specified.
Last Year - will return the total sales for last year
This will return the total sales for this year up to period 5 for Item code ACC5/LOC for store code CT.
ICSale( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Year to Date 5" )
This will return the total sales for month 3 for the item code ACC5/LOC and store CT.
ICSale( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Month 3" )
|