General Journal
General Journal
With the general journal we may make a report of a general journal for one or
more journal entries. We may also choose the amount of detail.
In the panel for entering of criteria used in the journal report we may enter
and select:
Report type
|
You may select by what detail should the data from the selected journal
entries or their respective items be displayed in the report. That is
whether the report was restricted by the data from the journal entries or by
their respective items. We may select between:
- 064 - General journal
- detailed by journal entries, it is the most often used report
showing the most important data from individual journal entry items (journal
entry ID, period date of the posting, account, subject, linked document,
debit and credit movement, note).
- 065 - General journal - detailed
by individual journal entry is used when we wnat to display
data from multiple journal entries at the same time and also make a
summary of the data from each individual journal entry.
- 06G -
General journal - detailed
by date in journal entry displays data from journal entry items,
sorted by date and journal entry ID
- 06H -
General journal - detailed
by document date displays data from journal entry items, sorted
by document data from the journal entry items
- 06I -
General journal - detailed
by document
- 06J -
General journal
- detailed by departments
displays data from journal entry items sorted by department
from the journal entry item
- 06K -
General journal - detailed
by clerks and journal entries displays data from the selected
journal entries sorted by clerks and secondly journal entry ID
- 06L -
General journal
- detailed by linked document
sorts all the selected records by date, account, subject and
linked document
- 06M - General journal
- detailed by journal entries, all data
differs from the "Detailed by journal entries" report in
that data on due dates, external document ID, note on the journal entry
item and document data are included in the report.
- 06O - General journal - detailed
by subjects
- 06R -
General journal - summary
by journal entries
- 063 -
General journal - summary
by accounts it makes a summary of data on debit or credit
movement by accounts from the journal entry item, if necessary
- 08G -
General journal -
summary by departments
it makes a summary of data on debit or credit movement by
departments from the journal entry item, if necessary
- 06E -
General journal - summary
by departments and accounts it makes a summary of data on debit
or credit movement by departments and accounts from the journal entry
item, if necessary
- 06F -
General journal - summary
by accounts and departments it makes a summary of data on debit
or credit movement by accounts and departments from the journal entry
item, if necessary
- 08H -
General journal - summary
by cost drivers
- 06N -
General journal - summary
by cost drivers and accounts
- 081 -
General journal - summary
by subjects it makes a summary of data on debit or credit
movement by subjects from the journal entry item, if necessary
- 066 -
General journal -
summary by subjects and accounts
it makes a summary of data on debit or credit movement by
subjects and accounts from the journal entry item, if necessary
- 06D -
General journal - summary
by accounts and subjects
it makes a summary of data on debit or credit movement by accounts
and subjects from the journal entry item, if necessary
|
Document types
|
We select the document types to be posted, for which we want to make a
general journal report. Records document types
are not on the list! (If we wnter the ID of the journal entry in the "ID"
field, this data need not be defined.)
|
Journal entry - data may be further filtered or restricted
according to the data from the journal entry
header
|
No.
|
The ID of the journal entry to be posted or of the general journal
(we may select also the IDs of journal entries of the records document types!).
If the report function of the general journal is called
directly from the journal entry to be posted,
this data shall be offered automatically by the programme. In this way we
may make a report for individual general journal and if we enter the data in
the "To" field (see description of the next field) as well as the selected
set of general journals.
|
To
|
The end number of the general journal. The data should be entered only
if we want ti make general journal report in the range from a start to
an end number.
|
Clerk
|
We may restrict the report by individual clerk (from the journal entry
header), who created the posting. |
| Period date (from) |
We may
select the start date (from journal entry header),
in which the posting belongs.
|
| Period date (to) |
We may select the end date (from journal entry
header), in which the posting belongs.
|
| Posting date (from) |
We may
select the start period date, in which the posting date belongs (from
journal entry header).
|
| Posting date (to) |
We may
select the end period date, in which the posting date belongs (from
journal entry header).
|
Journal entry items - data may be further filtered or restricted
according to the data from the journal entry
item
|
Account
|
If we want
to restrict the journal entry report to data on postings to individual
account, we select the account ID.
|
Account
|
An additionl account, by which we want to restrict the report. Thus we
can for example make a report for a specific subject both the
liabilities posted (account 2200) as well as payments received to the
giro account (account 1100).
|
Subject
|
The
report may be restriced by individual subjects from the items of the
posting. |
| Country |
The report may be restricted by the country, where the
subject from the item of the posting has its registered office |
Oddelek
| The report may be restricted by individual
department, to which the postings relate (suitable when tracking data by
cost centeres). The data may be found in the journal entry item.
|
| Cost drv. |
The report
may be restricted by individual cost driver. The data may be found in
the journal entry item. |
Document date (from)
|
Start period date, to which the document belongs (from the
journal entry item).
|
Document date (to)
|
End period date, to which the document belongs (from the
journal entry item). |
Due date (from)
| Start period date,
to which the due date of the document belongs (from journal entry item).
|
Due date (to)
|
End period date, to which the due date of the document belongs (from
journal entry item).
|
VAT date (from)
|
Start period date, to which the VAT date belongs (from journal entry item).
The data is used for the account of VAT (see VAT
posting).
|
VAT date (to)
|
End period date, to which the VAT date belongs (from journal entry item).
The data is used for the account of VAT (see VAT
posting).
|
Currency
| We
select whether the report for movements of local currency postings or rather
foreign currency postings shall be made:
|
Currency
|
We may
select the code of the foreign currency, in which posting was made.
|
| Note |
The report may be restricted also on
the grounds of the text in the note to the posting.
Wildcard characters can be of help here.. |
 |
To make the selection of the document types easier we may also
use the shortcut from the right-mouse-button-click menu (see -
Multiple selection list).
|
|
|
See Taskbar for a general
description of its functions.
|
|
|
We have to select the criteria for a report each and every time.
We may save them as a template. |
|
|
As with all kinds of filtering it is valid aslo for reports that
a blank field includes in the report all the values and the entered field
includes only those documents and items, which match the entered data!
By
using characters with special meaning we may set a somewhat wider scope of the
filter (see - Wildcard characters). |