Export of journal in the txt file

By using the import export data icon from the  Taskbar you may export the data from the general ledger to a .txt file for further use in inspection.

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
• 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 original posted value which were later split on more lines / entries.

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.). The selection of document types for review is stored seperately for each user.

Document types-record-only

We select the document types -record only 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.       

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 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 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).

Account

If we want to restrict the journal entry report to data on postings to individual account, we select the account ID from the dropdown list. We can also select more than one account by using multi select key .

Contra Acct.

Report can be restricted on contra accounts.

Status

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 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.

Namig 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.

Cost.Ctr.Status

Report can be restricted on  cost center status.

Cost Ctr. Group

Report can be restricted on  cost center group.

Subj. Type

Report can be restricted on  subject type.

Document

Report can be restricted on document.

Foreign. doc

Report can be restricted on foreign document

Link Document

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:

• In local currency - makes a report of the local currency movements from the journal entry item
• In foreign currency - makes a report of the movements in foreign currency/currencys (for foreign currency postings - see Additional journal entry fields for foreign currency posts)

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..

Export for Audit

By clicking this button we will get data file under selected criteria for further use. Report can be prepared for different users: auditors or any other users. We can choose also type of file between dbr, xls and txt.