 | Loading… |
|
|
|
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.
The general journal can be accessed via Financials | Reports | General Journal.
When selecting the General journal, you will be taken to a form for creating a printout of the posting journal.
Here is a description of the form:
In this section select the report type you want to printout.
|
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 want 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
- 33X - General journal - Detailed by status, post statuses
- 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
- 08K - General journal - summary by documents makes a summary of data on debit and credit movement by documents from the journal entry item,
- 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
- 33Q - General journal - Summary by status, post statuses
- 06W - General journal - In LCY and FCY , when needed data in original currency and local currency at the same report
- 06Y - General Journal - Summary by Original Line - report provides entries in the original posted value which were later split on more lines / entries.
|
In this section 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 enter the ID of the journal entry in the "ID" field, this data need not be defined). The selection of document types for review is stored seperately for each user.
In this section we select the document types - record only the ones which we want to include in a general journal report. By default, posts in Record only journal are not included - such documents are always unchecked after each opening and must be checked manually. The selection of document types for review is stored seperately for each user.
In this section 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 the 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 program. 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 to make a 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), to which the posting belongs.
|
|
Period date (to)
|
We may select the end date (from journal entry header), to which the posting belongs.
|
|
Posting date (from)
|
We may select the start period date, to which the posting date belongs (from journal entry header).
|
|
Posting date (to)
|
We may select the end period date, to which the posting date belongs (from journal entry header).
|
Journal entry lines - 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 an individual account, we select the account ID from the drop-down list. We can also select more than one account by using the multi select key  .
|
|
Contra Acct.
|
The report can be restricted on contra accounts.
|
|
Status
|
The report can be restricted on post status.
|
|
Subject
|
The report may be restricted 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.
|
|
Department
|
The report may be restricted by an individual department, to which the postings relate (suitable when tracking data by cost centers). The data may be found in the journal entry item.
|
|
Cost Center
|
The report may be restricted by individual cost driver. The data may be found in the journal entry item.
 |
HINT
Using the function  opens Lookup table in which multiple options can be selected within a single field. In this case, different Cost Centers in relation to their Name, Group or Status
On lookup table you can see also non-active cost centers.
|
|
|
Cost.Ctr.Status
|
The report can be restricted on cost center status.
|
|
Cost Ctr. Group
|
The report can be restricted on cost center group.
|
|
Subj. Type
|
The report can be restricted on subject type.
|
|
Document
|
The report can be restricted on document.
|
|
Foreign. doc
|
The report can be restricted on foreign document
|
| Report in User's Language |
If the translations of the chart of the account exist for certain language in the program, specific language can be selected for Journal entry lines overview.
By clicking on this option, name of accounts in report 063 - General Journal - summary by accounts will be shown in User's language set in menu Settings | Program | Administration Panel | Users and Groups | Users | Language. Option is usefull for users of PANTHEON in foreign language.
|
|
Link Document
|
The report can be restricted on link document.
|
|
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 the 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.
|
|
Export for Audit
|
By clicking on this button we will get data file under selected criteria for further use. A report can be prepared for different users: auditors or any other users. We can choose also type of file between dbr, xls and txt.
|
 |
warning
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).
|
|
WARNING
As with all kinds of filtering it is valid also 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)
|
|
|
|
|