<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICStock() |
ICStock( Company, ItemCode, Store, Period )
This function will return the actual stock 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:\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 actual stock for
Store: Enter the store code (if applicable) to return the actual stock for
Period: This should be one of the of the period keywords shown below
Month x - return the stock movement for the month specified
Year to Date x - return the actual stock up to and including the period specified
Last Year - will return the actual stock for last year
This will return the actual stock for this year up to period 5 for Item code ACC5/LOC for store code CT.
ICStock( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Year to Date 5" )
This will return the actual stock for month 3 for the item code ACC5/LOC and store CT.
ICStock( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Month 3" )
|