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

 

UnpostItem( Company, docType, Item Code, Store Code )

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

 

Item Code: This should be a valid product/inventory code within Pastel.

 

Store Code: If you wish to limit item codes by store then enter the store code. If you leave blank then the total monetary value will be return irrespective of store code.