ICCatValue( Company, Category, Store, Period )
This function will return the inventory sales (monetary) for the selected Category, store 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.
Category: Enter the item code that you wish to return the sales value for. Category codes where not available in
Pastel prior to Version 6, so for version 5.2 this would be the inventory group.
Store: Enter the store code (if applicable) to return the sales value for.
Period: This should be one of the of the period keywords shown below.
Month x - return the sales value for the month specified
Year to Date x - return the sales value up to and including the period specified.
Last Year - will return the sales value for last year
This will return the sales value for this year up to period 5 for Category 001 for store code CT.
ICCatValue( "c:\PastelData\_demo", "001", "CT", "Year to Date 5" )
This will return the sales value for month 3 for the category code 002 and store CT.
ICCatValue( "c:\PastelData\_demo", "002", "CT", "Month 3" )
|