Analysis

Contents : Show

The Analysis command provides a VAT report, six user-definable analysis reports and a transaction audit report for this period only.

When you run the Purchase - Utilities - End of Period command the purchase analysis information for the current period is transferred to a history file. You can then use the Purchase History command to report on purchase analysis information from earlier periods.

To save this report as a Microsoft Excel spreadsheet, select Excel Report from the Report Layout box on the Publisher form.  

User-Definable Reports

You define you own reports using the Set Options command on the Action menu associated with this form and can contain any combination of the following:

In the case of the supply code, you can also choose by range of characters. For example, the first four characters or the last six characters, and so on. Each of the options is identified by a letter and you can use a combination of up to four per report.

Example ...

When you print reports, selection criteria are available for a more precise selection of records.

VAT Analysis

Use the VAT Analysis option to produce a report of the VAT activities for this period including those goods purchased from an EC country.

Transaction List

Use the Transaction List option to produce a report that acts as a check on the analysis report. It includes the detail of every line of every invoice and credit note, by date, supplier, all analysis groups and supply code. It is presented in document sequence and shows the supplier account code, date, transaction type, invoice or credit number, together with the transaction values and analysis details.

Use the Action menu to:

Set up the analysis reports the you can view and print. You can create up to six reports and use up to four of the following codes for each report.

Code

Description

A - C

Includes analysis codes from the supplier records - Account, Supply, Type and Analysis.

E

Includes the supply analysis codes used on transaction records

F - L

Includes the first letters of the supply analysis codes used on transaction records. For example, letter J will include the first five digits in the supplier analysis code.

M - S

Includes the last letters of the supply analysis codes used on transaction records. For example, letter Q will include the last five digits in the supplier analysis code.

T

Includes the invoice numbers used on transaction records.

U - V

Includes the project and department codes used on transaction records.