<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICValue() |
ICValue( Company, ItemCode, Store, Period )
This function will return the inventory sales (monetary) for the selected item code, 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.
ItemCode: Enter the item code that you wish to return the sales value for.
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 Item code ACC5/LOC for store code CT.
ICValue( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Year to Date 5" )
This will return the sales value for month 3 for the item code ACC5/LOC and store CT.
ICValue( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Month 3" ) |