Intelligent Analysis
Access Accounts can analyse your transactions in many different ways, this analysis can then be viewed in the enquiry windows or by using the extensive reporting facilities.
Analyses are based either on Analysis Codes or on Key fields
The Analysis Codes provide automatic analysis as the transaction is stored in the database. The analysis is instantly available through enquiry windows as well as through reports. This type of Analysis uses intelligent defaults.
The Key fields associated with records and transactions do not have to be used. When they are used, they are stored as part of the record or transaction and can be used as selection criteria when printing reports. This type of Analysis has either no defaults or plain defaults.
To illustrate the full width and breath of available analysis, the following analyses are available when entering a Sales Order:
Analysis Code
Analysis Name
|
Maintained at
|
Interaction during SOP entry
|
Default
|
Sales Analysis Code (Nominal update rules)
|
Analysis
|
Default shown.
Selection available.
Ability to add on the fly if required.
|
Intelligent (see below)
|
VAT Analysis
|
Rates
|
Default shown.
Selection available.
|
Intelligent (see below)
|
Stock Sub Analysis Analysis Code (one for each Sub Analysis)
|
Stock record - Sub Analysis – Analysis tab card
|
For Stock items that have Sub Analysis, selection is required (entry can be completed later).
Ability to add on the fly if required.
|
Intelligent (see below)
|
Sales Analysis Intelligent Default rules
The default Sales Analysis displayed will be set according to the first of these rules to be met:
Rule | Description | Notes |
|
|
1
|
Matrix code from Sub Analysis if used for this Customer/Stock combination
| |||
2
|
Matrix code if used for this Customer/Stock combination
| |||
3
|
Sales Analysis setting in Customer Delivery Address selected on this Sales Order
|
See Multiple Addresses
| ||
4
|
Sales Analysis setting in Customer Invoice Address selected on this Sales Order
|
See Multiple Addresses
| ||
5
|
Sales Analysis default set in Customer record VAT window
|
See Customer/Supplier VAT window.
| ||
Stock
|
Price
|
Text
|
Each line of the Order is attributed to one of these line types.
The rules differ accordingly.
| |
6
|
Default Sales Analysis from Stock Sub Analysis window Analysis tab card
|
-
|
-
| |
7
|
Default Sales Analysis from the Stock record Selling Price line
|
-
|
-
| |
8
|
Default Sales Analysis set in Sales Ledger Analysis records as default for the Sales Ledger or set in Trading Currencies for the Currency used in this transaction
|
|
Key fields
Analysis Name | Maintained at | Interaction in SOP entry | Default |
Customer
User Key 1 - 3
|
Customers
|
Default shown.
Full edit for this SOP available.
|
Plain
|
Customer Account number
|
Customers
|
Selection required
Ability to add on fly if required.
|
None
|
Customer Head Office Account
|
Customers
|
Default shown.
Full edit for this SOP available.
|
Plain
|
Nominal Sale type
|
Major Heading
|
Not displayed
| None |
Project
|
Projects
|
No default presented.
Selection available.
Ability to add on fly if required.
Entry can be forced if required.
| None |
Cost Centre
|
Projects - Cost Centres
|
If Project Code is entered (see above) then of entry Cost Centre is mandatory.
Selection available.
Ability to add on fly if required.
| None |
Stock User Sort 1 - 3
|
Stock record
|
Not displayed
| None |
Stock Code
|
Stock record
|
Option to select Stock/Price/Text.
If Stock chosen, selection required.
Ability to add on fly if required.
|
None
|
Stock Sub Analysis User Sorts 1 - 6
|
Stock Options – Sub Analysis tab card
|
Not displayed
| None |
Transaction
User Key 1 - 3
|
None
|
Selection available.
Free entry available if required.
| None |