Share via


Gen. Journal Template Table

Specifies the general journal templates that have been set up. If you need to create new ones, you do it here.

Journal templates allow you to work in a journal window that is designed for a specific purpose. That is, the fields contained in each journal template are exactly the ones needed for a particular part of the program. For example, you do not need to use the same fields when you post a sales invoice as when you post a payment.

You can also select a specific test report and posting report to be printed with the Post and Print and Test Report functions in a journal template.

By using the Source Code file, you can insert a code on the journal template that will be copied onto all the journal lines that are created in the journal template. The code is also copied to the entries when they are posted. You can thus always see where an entry has been posted from.

If you want to create a journal template, choose Edit, Insert New on the menu bar, then fill in the fields in the table.

There are several standard general journal templates set up in menu items in the General Ledger, Sales & Receivables, Purchases & Payables and Fixed Assets application areas. They cover the most common routines used in the program, and in all of these journal templates, you can post entries to G/L, customer, vendor and fixed asset accounts. (These standard journal templates do not appear in the Gen. Journal Template table until you have opened the journals themselves.)

The General Ledger application area contains the General Journals menu item.

In the Sales & Receivables application area there are two journals: Sales Journals and Cash Receipt Journals. These are specially designed for creating sales invoices and registering payments from customers. (If you have access to sales documents such as invoices, you will normally use those facilities instead of sales journals.)

The Purchases & Payables application area contains two journals: Purchase Journals and Payment Journals. These contain the fields and functions necessary for creating purchase invoices and registering payments to vendors. (If you have access to the purchase documents such as invoices, you will normally use those facilities instead of purchase journals.)

The Fixed Assets application area contains several types of journals. The FA G/L Journal is a general journal, which is integrated to the general ledger. It is designed for posting fixed asset transactions such as acquisition and depreciation.

Each of these application areas also has a recurring general journal under Periodic Activities. This is a special window in which you can define a recurring frequency and other specifications and allocate amounts by using the Allocation table. When you use a recurring journal, you can post the same information as often as you want and you only need to enter it once. Whenever you want to post the same information again, you only need to click Post.

You can create multiple journal batches under each journal template. That is, several journals, each with its own name, can display the same window. This can be practical, for example, if every user needs to have his or her own journal.

List of Fields in the Table

To see the list of fields in this table, change to the Classic view. Choose the Choose View button in the upper-right corner, and then choose Classic.

Field Location
Sub Type Field, Gen. Journal Template Table India Local Functionality
Allow Posting From Field, Gen. Journal Template Table Belgium Local Functionality
Allow Posting To Field, Gen. Journal Template Table Belgium Local Functionality
No. of CBG Statements Field, Gen. Journal Template Table Netherlands Local Functionality
Vendor Receipt Report ID Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report Caption Field, Gen. Journal Template Table General Ledger
Posting Report ID Field, Gen. Journal Template Table General Ledger
Bal. Account No. Field, Gen. Journal Template Table General Ledger
Page Caption Field, Gen. Journal Template Table General Ledger
Name Field, Gen. Journal Template Table General Ledger
Type Field, Gen. Journal Template Table General Ledger
Test Report ID Field, Gen. Journal Template Table General Ledger
Recurring Field, Gen. Journal Template Table General Ledger
Reason Code Field, Gen. Journal Template Table General Ledger
Copy VAT Setup to Jnl. Lines Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report Caption Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report ID Field, Gen. Journal Template Table General Ledger
Source Code Field, Gen. Journal Template Table General Ledger
Bal. Account Type Field, Gen. Journal Template Table General Ledger
Force Doc. Balance Field, Gen. Journal Template Table General Ledger
Posting Report Caption Field, Gen. Journal Template Table General Ledger
No. of CBG Statements Field, Gen. Journal Template Table Netherlands Local Functionality
Allow VAT Difference Field, Gen. Journal Template Table General Ledger
Test Report Caption Field, Gen. Journal Template Table General Ledger
Description Field, Gen. Journal Template Table General Ledger
Page ID Field, Gen. Journal Template Table General Ledger
Force Posting Report Field, Gen. Journal Template Table General Ledger
Type Field, Gen. Journal Template Table New Zealand Local Functionality
Vendor Receipt Report ID Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report Name Field, Gen. Journal Template Table General Ledger
Posting Report ID Field, Gen. Journal Template Table General Ledger
Bal. Account No. Field, Gen. Journal Template Table General Ledger
Page Name Field, Gen. Journal Template Table General Ledger
Name Field, Gen. Journal Template Table General Ledger
Type Field, Gen. Journal Template Table General Ledger
Test Report ID Field, Gen. Journal Template Table General Ledger
Recurring Field, Gen. Journal Template Table General Ledger
Reason Code Field, Gen. Journal Template Table General Ledger
Copy VAT Setup to Jnl. Lines Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report Name Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report ID Field, Gen. Journal Template Table General Ledger
Posting No. Series Field, Gen. Journal Template Table General Ledger
Source Code Field, Gen. Journal Template Table General Ledger
Bal. Account Type Field, Gen. Journal Template Table General Ledger
Force Doc. Balance Field, Gen. Journal Template Table General Ledger
Posting Report Name Field, Gen. Journal Template Table General Ledger
Allow VAT Difference Field, Gen. Journal Template Table General Ledger
Test Report Name Field, Gen. Journal Template Table General Ledger
Description Field, Gen. Journal Template Table General Ledger
Page ID Field, Gen. Journal Template Table General Ledger
No. Series Field, Gen. Journal Template Table General Ledger
Force Posting Report Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report ID Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report Name Field, Gen. Journal Template Table General Ledger
Posting Report ID Field, Gen. Journal Template Table General Ledger
Bal. Account No. Field, Gen. Journal Template Table General Ledger
Page Name Field, Gen. Journal Template Table General Ledger
Name Field, Gen. Journal Template Table General Ledger
Type Field, Gen. Journal Template Table General Ledger
Test Report ID Field, Gen. Journal Template Table General Ledger
Recurring Field, Gen. Journal Template Table General Ledger
Reason Code Field, Gen. Journal Template Table General Ledger
Copy VAT Setup to Jnl. Lines Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report Name Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report ID Field, Gen. Journal Template Table General Ledger
Posting No. Series Field, Gen. Journal Template Table General Ledger
Source Code Field, Gen. Journal Template Table General Ledger
Bal. Account Type Field, Gen. Journal Template Table General Ledger
Force Doc. Balance Field, Gen. Journal Template Table General Ledger
Posting Report Name Field, Gen. Journal Template Table General Ledger
Allow VAT Difference Field, Gen. Journal Template Table General Ledger
Test Report Name Field, Gen. Journal Template Table General Ledger
Description Field, Gen. Journal Template Table General Ledger
Page ID Field, Gen. Journal Template Table General Ledger
No. Series Field, Gen. Journal Template Table General Ledger
Force Posting Report Field, Gen. Journal Template Table General Ledger
No. of CBG Statements Field, Gen. Journal Template Table Netherlands Local Functionality
Posting No. Series Field, Gen. Journal Template Table General Ledger
No. Series Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report ID Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report Caption Field, Gen. Journal Template Table General Ledger
Posting Report ID Field, Gen. Journal Template Table General Ledger
Bal. Account No. Field, Gen. Journal Template Table General Ledger
Page Caption Field, Gen. Journal Template Table General Ledger
Name Field, Gen. Journal Template Table General Ledger
Type Field, Gen. Journal Template Table General Ledger
Test Report ID Field, Gen. Journal Template Table General Ledger
Recurring Field, Gen. Journal Template Table General Ledger
Reason Code Field, Gen. Journal Template Table General Ledger
Copy VAT Setup to Jnl. Lines Field, Gen. Journal Template Table General Ledger
Vendor Receipt Report Caption Field, Gen. Journal Template Table General Ledger
Cust. Receipt Report ID Field, Gen. Journal Template Table General Ledger
Posting No. Series Field, Gen. Journal Template Table General Ledger
Source Code Field, Gen. Journal Template Table General Ledger
Bal. Account Type Field, Gen. Journal Template Table General Ledger
Force Doc. Balance Field, Gen. Journal Template Table General Ledger
Posting Report Caption Field, Gen. Journal Template Table General Ledger
Allow VAT Difference Field, Gen. Journal Template Table General Ledger
Test Report Caption Field, Gen. Journal Template Table General Ledger
Description Field, Gen. Journal Template Table General Ledger
Page ID Field, Gen. Journal Template Table General Ledger
No. Series Field, Gen. Journal Template Table General Ledger
Force Posting Report Field, Gen. Journal Template Table General Ledger
No. of CBG Statements Field, Gen. Journal Template Table Netherlands Local Functionality

See Also

Reference

General Journal Templates