Inquisitor Library

The list below includes Inquisitor reports donated by your fellow Active Accounting users. We at UDS hope you find some of them to be as useful to you as they have been to their creators. In order to make your search for a report a little easier, each has been grouped into an application category that most closely matches their intended use.

UDS invites you to donate your favorite Inquisitor reports to this web page. Click here for easy directions.

If you would like to donate your favorite Inquisitor report designs to this web page, and we hope ALL of you will, UDS would be happy to post them here for you. Export your Inquisitor Report (File/Export Report Format) from the Inquisitor Reports window. Attach it to an email going to www.support@udsgis.com. Please include along with your report design a clear statement of its' intended use or purpose. Any additional instructions you can provide that relate to using your Inquisitor report will be greatly appreciated because they will certainly benefit the person selecting your Inquisitor report.

Additionally, we can place your name and/or company name alongside your report design, as "Submitted by: ___" unless you tell us otherwise. Many new users are looking for Inquisitor reports and right now there exists only a void. Hopefully it won't be too long before we can help them out.

How to download an Inquisitor Report? Click here for directions.

	Note that these Inquisitor report format files (designs) have been compressed into a .zip file type and will download very quickly as a result. Therefore you must have installed the Winzip™ program or at least their free evaluation copy of Winzip™ in order to unzip these files after downloading. For your convenience you may click on this link now to be taken to the Winzip.com site if you need to acquire a copy of Winzip™.
	Click on Save to Disk link when you are ready to begin downloading an Inquisitor report.
	Answer 'save to disk' when prompted and specify the folder to which you would like to save the downloaded report.
	After Downloading is complete, unzip the file into its' .xml file type.
	Start Active Accounting and select from the main menu- File/View/Other/Inquisitor.
	On the Inquisitor Reports window that appears, select from its' menu- File/Import Report Format.
	Provide the path to the folder in which you saved the .xml file and then select 'Open'.
	Don't forget to 'Save' the report format after importing it the first time or after making your own modifications to the report format.

Accounts Receivable:

Accounts Payable:

Billing:

Customer:

Estimating:

General Ledger:

Save to Disk Non-Posted-AR.zip View non-posted A/R transactions sorted first by Reference number then by Debit or Credit.

More Info

Used to minimize your time with your database open in MS Access™ looking for the source of a posting problem. Modify selected record ranges to further refine your listing of GL Transactions. Modify the Sort sequences to group transactions differently.

Save to Disk Non-Posted-AP.zip View non-posted A/P transactions sorted first by Reference number then by Debit or Credit.

More Info

Use to minimize your time with your database open in MS Access™ looking for the source of a posting problem. Modify selected record ranges to further refine your listing of GL Transactions. Modify the Sort sequences to group transactions differently.

Save to Disk Non-Posted-PR.zip View non-posted P/R transactions sorted first by Reference number then by Debit or Credit.

More Info

Save to Disk GL Transactions by Sales Type & Invoice Date.zip Specify a Sales Type and Invoice Date range and view a List of posted GL Transactions created from only those AR Invoices that meet the criteria.

More Info

	Possible uses include the ability to look just at GL transactions generated by POS Sales receipts, such as, regular POS sales or Internal sales.
	Report links Sales Analysis Invoice Header table to GL Transaction History table so that GL transactions created from only Invoices of a given Sales Type or two will be displayed. Report is sorted first by Sales Type, then Reference Number, then amounts are subtotaled by Debit or Credit within each reference number.

Inventory:

Job Costing:

Orders:

Planning:

Payroll:

Save to Disk Emp-Quart-City-Tax-code.xml View or Print only those Employee Quarterly records in a situation where a Local Tax YTD deduction exists but is showing no City Tax Code assigned. 9/30/2005

More Info

	Active Accounting will not show any local taxes that may have been previously deducted from an employees check on the W-2 Print if, there is currently no City Tax Code showing in that field within the Employee's Quarterly record.
	For example let's say the employee had local taxes deducted in the first half of the year. But, in the second half of the year they do not. The regular employee record was therefore opened so that the local tax code could be blanked-out. Upon closing that quarter, the employee quarterly record is updated and the City Tax Code field is naturally blanked-out. Because the City Tax Code has been blanked-out in the employee quarterly record, the W-2 Print process ignores any Local Taxes YTD accumulated in the first half of the year even though showing in the employee quarterly record.
	Running this Inquisitor report will conveniently inform the payroll user if this situation exists, so that, the City Tax Code can be added temporarily back into the employee's quarterly record and the local taxes year to date will print on the W-2 form.

Purchase Order:

Save to Disk PO by Number or Recv Date.zip View or Print your Purchase Order Receipts report without price columns. 12/07/2004

More Info

This report will retrieve any PO # from 000000 to 999999 or any PO with a received date between 12/01/2004 and 12/31/2004, so it is likely the user of this report will want to first the Select Records menu option in order to further restrict the report to a smaller and more useful range of PO Numbers.

Shipping:

POS:

Save to Disk End-of-Day-by-Item-Type.zip Specify up to two Sales Types and also a Ship Date range to view a report listing Items sold. Items are first sorted by Item Type and then by Description. Extended Prices are shown for each line Item and subtotaled by Item Type.

More Info

	Possible uses include the ability to look only at Items sold on regular POS and/or Internal Sales receipts, have them sorted by Item Type and view the Extended Prices subtotal by Item Type sold.
	Restricting the Ship Date range to one day or several days could be compared to the POS End of Day report function that does not go as far as breaking sales down by Item Type.
	The current Select Records setup allows Sales Type "P" or "P" and a Ship Date range => 01/01/2003 and <= 12/31/2003. The user of this report would change the Sales Type to match theirs and set the beginning and ending Ship Date range to suit their liking.