<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Job / Cost Code Functions > JCDetail() |
JCDetail( Company, CostCode, FieldToReturn )
This function will return your Cost Code / Job Costing master details from Pastel.
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.
CostCode: The Pastel cost code to return the details
FieldToReturn: This should be one of the following keywords:
Returns Keyword
Cost Code Description Description
Cost Code Blocked Blocked
The path can be a reference to an Excel cell for example:
JCDetail( A1, "GOV01", "Description" )
Retrieves the Cost code description
JCDetail( A1, "GOV01", "Blocked" ) Will return Yes if the cost code is blocked otherwise No will be returned |