<< Click to Display Table of Contents >> Navigation:  PaXcel  - functions > Unposted Documents > UnpostCat()

 

UnpostCat( Company, docType, Inventory Category )

This will return the unposted document monetary value for the given document type and specified inventory category. This function is valid for Pastel v6, Pastel 2004, Pastel 2007, Pastel 2009,  Pastel v11, Pastel v12, Pastel v14, Pastel v17, Pastel v18 and Sage 50c Pastel Partner v19 when inventory categories where introduced. If you are using with Pastel v5.2 this is the same as UnpostGrp().

 

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

 

Inventory Category: This should be a valid category code within Pastel. If you leave this value blank then the total unposted document value will be returned.