UnpostGrp()

<< Click to Display Table of Contents >>

Navigation:  PaXcel  - functions > Unposted Documents >

UnpostGrp()

 

UnpostGrp( Company, docType, Inventory Group )

This will return the unposted document monetary value for the given document type and specified 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.

 

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 Group: This should be a valid inventory group within Pastel. If you leave this value blank then the total unposted document value will be returned.