<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICItem() |
ICItem( Company, ItemCode, Store, FieldToReturn )
This function will return the master field information for the selected Item and store (if applicable).
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 information for.
Store: If the information is store specific then enter the store code to return the information for. This is only applicable if you have Pastel version 6 and higher.
FieldToReturn: The keyword of the master field information to return should be entered here.
Field to return |
Keywords |
Inventory Group Bin Number Last Invoice Last Purchase Last Amount Reorder Level Maximum stock level Price 1 Price 2 Price 3 Price 4 Price 5 Price 6 Price 7 Price 8 Price 9 Price 10 Price Inclusive 1 Price Inclusive 2 Price Inclusive 3 Price Inclusive 4 Price Inclusive 5 Price Inclusive 6 Price Inclusive 7 Price Inclusive 8 Price Inclusive 9 Price Inclusive 10 Special Start Date Special Start End Special Price Special Inclusive Price New Price 1 New Price 2 New Price 3 New Price 4 New Price 5 New Price 6 New Price 7 New Price 8 New Price 9 New Price 10 New Price Inclusive 1 New Price Inclusive 2 New Price Inclusive 3 New Price Inclusive 4 New Price Inclusive 5 New Price Inclusive 6 New Price Inclusive 7 New Price Inclusive 8 New Price Inclusive 9 New Price Inclusive 10 Item Description Barcode Discount Type Blocked Fixed Description Show quantity Physical Item Unit of measure Sales Tax Purchase Tax Default GL Code Allow Tax Allow Sales Commission Link to web Serial Item Picture User Text 1 User Text 2 User Text 3 User Number 1 User Number 2 User Number 3 Last Supplier Supplier Item Code Inventory Category Commodity Code (v8) Nett Mass (v8)
|
Group Bin LastInvoice LastPurchase LastAmount Reorder Maximum Price1 Price2 Price3 Price4 Price5 Price6 Price7 Pice8 Pice9 Price10 PriceInc1 PriceInc2 PriceInc3 PriceInc4 PriceInc5 PriceInc6 PriceInc7 PriceInc8 PriceInc9 PriceInc10 SpecialStart SpecialEnd SpecialPrice SpecialPriceInc NewPrice1 NewPrice2 NewPrice3 NewPrice4 NewPrice5 NewPrice6 NewPrice7 NewPrice8 NewPrice9 NewPrice10 NewPriceInc1 NewPriceInc2 NewPriceInc3 NewPriceInc4 NewPriceInc5 NewPriceInc6 NewPriceInc7 NewPriceInc8 NewPriceInc9 NewPriceInc10 Description Barcode DiscountType Blocked Fixed Showqty Physical Unitsize SalesTax PurchTax GLCode AllowTax Commission LinkWeb Serial Picture UserTxt1 UserTxt2 UserTxt3 UserNo1 UserNo2 UserNo3 LastSupplier SupplierItem Category Commodity NettMass |
This will return the item description for the specified item code
ICItem( "c:\PastelData\_demo", "ACC5/LOC", "", "Description")
This will return the user defined text field 1 for the specified item code
ICItem("c:\PastelData\_demo", "ACC5/LOC", "", "UserTxt1" )
This will return the Bin Number for store JHB for the specified item code
ICItem("c:\PastelData\_demo", "ACC5/LOC", "JHB", "BIN" )
Using Store codes is only valid in Pastel version 6 and higher.
If you don't use Multi-store then you must use the default store of 001 to return your main stock information.
|