ICStock()

<< 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

 

hmtoggle_arrow1        Examples: