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