PaXcel - functions > Unposted Documents

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().

UnpostCst( Company, docType, Cost Code )

This will return the unposted document monetary value for the given document type and specified cost code.

UnpostItem( Company, docType, ItemCode, StoreCode )

This will return the unposted document monetary value for the given document type, item code and store code if required.

UnpostGrp( Company, docType, Inventory Group )

This will return the unposted document monetary value for the given document type and specified Inventory Group.

UnpostSle( Company, docType, Sales Analysis code)

This will return the unposted document monetary value for the given document type and specified sales analysis code.

UnpostStr( Company, docType, Store Code )

This will return the unposted document monetary value for the given document type and specified store code.

Document Types

The following codes should be used for the document 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