Analytical accounting
Menu path
Finance ➔ General Ledger ➔ Analytical Accounting
Introduction
Analytical accounting helps you to change the financial transactions without going through every single entry for the changes and do deferred costs allocation. You do not need to register, for example, project, resource and warehouse information immediately upon booking. If you do not know all details, you can just enter a transaction with basic information and add this specific data in a later stage. The process will not be delayed. This increases the flexibility and convenience of updating the relevant fields of the financial transactions.
Fields
Date
Select the date of entry or the reporting date to filter the search results.
Date, to
Type or select the required date or date range, or select the All check box for all dates.
Show
Select one of the following to filter the results you want displayed:
-
All
- Available: Resource
- Not available: Resource
- Available: Project
- Not available: Project
- Available: Warehouse
- Not available: Warehouse
- Available: Cost center
- Not available: Cost center
- Available: Cost unit
- Not available: Cost unit
- Available: Item code
- Not available: Item code
- Available: Assets
- Not available: Assets
Note: The options available depend on the license you have for the particular modules in Exact Globe Next.
G/L
Select a general ledger account or the range of general ledger accounts to be displayed in the results. Alternatively, select the All check box for all general ledger accounts. Only entries linked to the selected general ledger account(s) are displayed.
Check: Analytical values
Select the Check: Analytical values check box to display only options with Not available: at Show.
Show: Budget
Select the Show: Budget check box to display the budget information.
Budget scenario
If you have selected the Show: Budget check box, budget scenario is available for selection. Type or select the required budget scenario to display the budget details.
Group by
The default value is G/L. Select one of the following to display the search results according to the grouping:
- Our ref.
- Your ref.
- G/L
- Resource
- Project
- Account
- Warehouse
- Cost Center
- Cost Unit
- SO/PO
- Selection code
- Item
- Date
- None
Note: The options available depend on the license you have for the particular modules in Exact Globe Next.
Type
Select one of the following to display the search results according to the entry types:
- All
- Other
- Sales invoice
- Sales credit note
- Purchase invoice
- Purchase credit note
- Machine hours
- Labor hours
- Depreciation
- Receipt
- Fulfillment
- Counts
- Payroll
Note: The options available depend on the license you have for the particular modules in Exact Globe Next.
Currency
Type or select the required currency.
Unprocessed
Select the Unprocessed check box to also display the unprocessed entries.
P&L
Select the P& L check box to also display the entries made to the Profit & Loss (P&L) account.
Balance Sheet
Select the Balance Sheet check box to also display the entries made to the Balance Sheet.
Filter
Click Filter to show or hide the criteria as below.
Our ref.
Type Our ref. of the entries to display the report that matches the defined criteria.
Debtor
Select the required debtor to display the report that matches the defined criteria.
Project
Select the required project to display the report that matches the defined criteria.
Your ref.
Type Your ref. of the entries to display the report that matches the defined criteria.
Creditor
Select the required creditor to display the report that matches the defined criteria.
Warehouse
Select the required warehouse to display the report that matches the defined criteria.
Order
Type the order number to display the report that matches the defined criteria.
Journal
Select the required journal number to display the report that matches the defined criteria.
Item group
Select the required item group to display the report that matches the defined criteria.
Payment reference
Type the payment reference number to display the report that matches the defined criteria.
Resource
Select the required resource to display the report that matches the defined criteria.
Item
Select the required item code to display the report that matches the defined criteria.
Entry number
Type the entry number to display the report that matches the defined criteria.
Cost center
Select a cost center, a cost center range, or select the All check box for all the cost centers to display the report that matches the defined criteria.
Serial no.
Select the required serial number to display the report that matches the defined criteria.
Description
Type a description to display the report that matches the defined criteria.
Cost unit
Select a cost unit, a cost unit range or select the All check box for all the cost units to display the report that matches the defined criteria.
VAT code
Select the required VAT type to display the report that matches the defined criteria.
External number
Type an external number to display the report that matches the defined criteria.
General ledger transactions: free field 1 to 5
Type the free field information for the selected entry. In total, there are 5 free fields. These fields allow you to type additional information (besides the available fields) of the particular transaction. You can customize the field labels at System ➔ General ➔ Free fields. For more information see Maintaining free fields.
At the bottom of the screen, you will find the Total amount. When you zoom to a selected entry line, it displays the total amount of the relevant financial transactions in the respective general ledger account. Selected shows the outstanding amounts of the selected entry lines.
Buttons
Refresh
Click this to refresh the displayed results. You will see the results that match the newly defined criteria.
Change
Click this to modify or update the additional analytical information to the selected entry. It is enabled only if you have selected Our ref., Your ref., SO/PO, or None at Group by. Alternatively, the button is also enabled when you have selected an entry.
Select all
Click this to select all the displayed entry lines at once, allowing you to export all selected entries quickly and easily.
Card
Select an entry and click this to view the item transaction card. It is enabled only if you have selected G/L or None at Group by. Alternatively, it is also enabled if you have zoomed in for the entry earlier.
Our ref.
Click this to view or update the financial transaction details of the selected entry in the Our ref. screen. You will see all the transactions grouped by the Our ref. number. This button is enabled only if you have typed the Our ref. in the financial transactions earlier or when you have selected Our ref. or None at Group by.
Your ref.
Click this to view or update the financial transaction details of the selected entry in the Your ref. screen. This button is enabled only if you have typed the Your ref. in the financial transactions earlier or when you have selected Your ref. or None at Group by.
Resource
Click this to view or update the financial transaction details of the selected entry in the Resource screen. This button is enabled only if you have typed or selected the resource name in the financial transactions earlier, or when you have selected Resource or None at Group by.
Export
Click this to export and convert the selected entry or entries to Microsoft Excel.
Zoom
Click this to view or edit the details of the selected entry. You cannot select more than one entry at a time.
Clear
Click this to clear all the defined criteria.
Close
Click this to exit.
Related documents
| Main Category: |
Attachments & notes |
Document Type: |
Online help main |
| Category: |
|
Security level: |
All - 0 |
| Sub category: |
|
Document ID: |
12.181.037 |
| Assortment: |
Exact Globe+
|
Date: |
26-09-2022 |
| Release: |
|
Attachment: |
|
| Disclaimer |