<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Unposted Documents > UnpostCst() |
UnpostCst( Company, docType, Cost Code )
This will return the unposted document monetary value for the given document type and specified cost code/Job code/project code.
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.
DocType: This should be one of the following document code types.
SQ - Quotes
SO - Sales Orders
SI - Sales Invoices
SC - Sales Credits
SD - Sales Debits
PO - Purchase Orders
PG - Purchase GRN's
PI - Purchase Invoices
PC - Purchase Credits
PD - Purchase Debits
Cost Code: This should be a valid cost code within Pastel. If you leave this value blank then the total unposted document value will be returned.