<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICCost() |
ICCost( Company, ItemCode, Store, Period )
This function will return the average cost 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 average cost price for
Store: Enter the store code (if applicable) to return the average cost price for
Period: This should be a value between 1 - 13. If you wish to return the average cost at the end of last year then enter -1
This will return the average cost for period 5 for Item code ACC5/LOC for store code CT.
ICStock( "c:\PastelData\_demo", "ACC5/LOC", "CT", 5 )
This will return the average cost for period 3 for the item code ACC5/LOC and store CT.
ICStock( "c:\PastelData\_demo", "ACC5/LOC", "CT", 3 )
This will return the average cost for last year for the item code ACC5/LOC and store CT.
ICStock( "c:\PastelData\_demo", "ACC5/LOC", "CT", -1 )
|