<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Inventory Functions > ICGrp() |
ICGrp( Company, InventoryGroup, FieldToReturn )
This function will return the master information for the supplied inventory group.
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.
InventoryGroup: Enter the inventory group code to return the master field information for.
FieldToReturn: The keyword of the master field information to return should be entered here.
Field to Return |
Keyword |
Group Name Sales Account Purchase Account Cost of Sales Account Adjustment Stock Control Variance Account Purchase Variance Sales Tax Code Purchase Tax Code |
Name Sales Purchase COS Adjustment Control Variance PurchaseVar SalesTax PurTax
|
This will return the group name associated with the inventory group 001
ICGrp( "c:\PastelData\_demo", "001", "Name" )
This will return the Sales General Ledger account associated with the inventory group 001
ICGrp( "c:\PastelData\_demo", "001", "Sales" )
This will return the Stock Control General Ledger account associated with the inventory group 001
ICGrp( "c:\PastelData\_demo", "001", "Control" )
|