Access Crystal Reports (ACR) are additional standard reports provided by Access, which enable you to report on aspects of your data which are not covered by the normal Transaction and Record reports. These reports use the Seagate Crystal Reports print engine. See the General Information Reports section of this help, for further information on ACR.

When you select ACR a window opens, listing the reports that are available.

Screen, Printer, Email - these are the types of output from which you can choose.

Edit - You must have Seagate Crystal Reports installed to use this feature. This allows you to make changes to the selected report.

Search - This opens a separate window where you can specify Search Criteria against the Available Search Fields; you are able to save your search criteria for future use.

Select Search - Here you select a previously saved Search.

Add to-/ Remove from Favourites - You can use these functions to flag/un-flag specific reports as being favourites. Favourites appear at the top of the Available Reports list.

Print - this sends the selected report to your selected output type.

This drop-down allows you to filter the list so that only specific types of reports are displayed in the list, e.g. FIFO contains various FIFO Valuation reports, Stock contains Stock Checks, Stock Lists, Stock Movements, Stock Reorder List, Stock Transaction, or Work that contains Work in Progress reports, Work to List, and Works Order reports.

You can click on this heading to sort the list. The list itself shows all reports that match your search and/or filter criteria.

The Access Crystal reports are stored in the Price Matrix/Reports folder found in the folder in which Access Accounts has been installed.

Four reports are included with the Advanced Price Matrix Plug-In, where the Standard Report is the default:

This lists the Minimum and Buy quantities against the quantity that is permitted Free or at a preferential price and the maximum items allowed.

Individual product prices are not included.

This lists the products and their prices when using the price list you have selected.

The name of the price list is include but not the details of it's structure e.g. Whole Order quantity or Minimum and Buy quantities.

This report includes the price of each product and, if appropriate, the buying quantities for each price.

The name of the price list is include but not the details of it's structure e.g. Whole Order quantity or Minimum and Buy quantities.

This lists the Whole Order quantity together with the fixed or percentage discounts that are applicable.

Individual product prices are not included.

All reports include:

When creating a price list with the Price Matrix wizard, the report to be used when printing the price list is selected on the Price List settings window.

The reports for Works Orders, found on the Transactions menu and also from the Records menu, are also available as Access Crystal Reports. These can be run from the Access Crystal Reports window.

All these reports are copies of the standard reports and are described in the Works Order Reports topic.

The reports include:

this report will list the outstanding materials requirement for existing works orders thus providing a materials short fall statement for outstanding works orders.

this report lists all the transactions that have been input since the last Not Yet Printed report for the Works Order module was printed to a printer, or to file, and flagged as updated. The report will be sorted by Works Order number. When the report is printed to printer or file you will be prompted with the option to update the transactions as printed.

this report lists Works Orders that are currently Work in Progress but where the End Date has been exceeded.

this produces a list of all the assembly type stock records that have a Route assigned.

this produces a list of all the Route records including a list of the Stages and the Route Notes.

this produces a list of assembly stock items that are currently being used in active Works Orders including the quantities required, issued and outstanding.

this report shows the outstanding works orders, detailing issued components and outstanding costs. This report is available for four valuation methods: Average, Latest, Standard and Weighted.

this report details outstanding Works Orders, initially sub-totalled by Route and then by Stage, enabling you to see the work-load per stage.

this report lists the outstanding, batched Sales Orders for stock items that can be manufactured but for which no works order has been created or assigned.

this report provides an analysis of completed Works Orders detailing the variances between Actual and Estimated costs with a split between Material costs and Labour Costs.

this report is a summary of the values written-off when completing and cancelling works orders. The report includes an actual cost summary and the profit and loss write off account.