Reporting

• Quick Report User Field Dropdowns

  mark{background-color: RGB(0,111,98); color: white} Overview In SalesPad it is possible to populate a list of options for a user defined field using a modified version of a SalesPad Quick Report. The ...

• Quick Report Examples

  Overview This document applies to Item Quick Report, Vendor Quick Report, Customer Quick Report, Purchase Order Quick Report, Sales Document Quick Report and Sales Line Quick Report. Settings Follow t...

• Purchase Receipt Return Report

  Overview Purchase Receipt Return Report is a SalesPad security that allows users to access the Purchase Receipt Return default report. This report can be copied and edited in Report Designer. See the ...

• Restricting Document Printing

  Overview Some situations require that a sales document not be printable until further action has been taken. There are three ways to restrict document printing in SalesPad and Dynamics GP: Configuring...

• Report Designer Stored Procedure spcpSalesDocumentReport

  Note: The following fields are required for proper function of the stored procedure: cSalesDocument level required items are sd.Sales_Doc_Num & sd.Sales_Doc_Type cSalesLineItem level required items ar...

• Report Designer Stored Procedure spcpPurchaseOrderReport

  Example spcpPurchaseOrderReport A software product created by SalesPad Solutions, LLC Copyright 2004-2011 www.cavallo.com Note: The following fields are required for proper function of the stored proc...

• Quick Reports

  Overview Quick Reports provide a quick mechanism to create and run simple reports based on SQL queries and user input. Quick Reports can be created to display any information about the company includi...

• Quick Reports Reference Guide

  Summary Quick Reports is a module for SalesPad GP. Its primary purpose is to provide a quick mechanism to create and run simple reports based on SQL queries and user input. End users can view reports ...

• Quick Report Sales Line Detail by Workflow Queue

  The following Quick Report (no UDFs required) will display Sales Line Detail by Workflow Queue: <report name=Sales Line AutoLinks=true autoRun=true BestFitAll=true> <search name=Warehouse column=Wares...

• Quick Report Finding Syntax Errors in Document Notes

  Overview An error will be encountered when a sales document containing improper syntax is opened. Use the Quick Report on the following page to pull all document notes in order to find syntax errors. ...