<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICUnposted() |
ICUnposted( Company, ItemCode, Store, ValueToReturn )
This will return the unposted stock figure for the selected Item Code, store and unposted type
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 unposted value for.
Store: Enter the store code (if applicable) to return the unposted value for.
ValueToReturn: Enter one of the following keywords to return the unposted value for.
Value to return |
Keyword |
Total unposted Unposted Sales Order Unposted Purchase Order Unposted Invoices |
Total SalesOrder PurchaseOrder BatchQty |
The following will return the Total unposted value for item code ACC5/LOC and store CT
ICUnposted( "c:\PastelData\_demo", "ACC5/LOC", "CT", "Total" )
The following will return the unposted Sales Orders for item code ACC5/LOC and store CT
ICUnposted("c:\PastelData\_demo", "ACC5/LOC", "CT", "SalesOrder" ) |