Use the Time Journal page to create and edit journal batches that are specific to time entry and only include fields needed to enter time. You can also import time entries into Time Journals from an Excel file. You also have the option to post manual entries to the GL using Time Journals.
To create a new time journal batch manually
Navigate to the Role Center > Journals > Time Journal.
Select a Time/Exp Journal Template from the ribbon, then complete the fields to create a time entry journal batch.
Posting Date: Specifies the posting date you want to assign to each journal line.
Document Number: Enter a document number for the journal line.
Project No.: Specifies the number of the project used for the time entry.
Project Task No.: Specifies the number of the related project task used for the time entry.
No. Select the resource related to the time journal line.
Description: Specify the name of the resource to which this entry applies. You can change the description.
Time Pay Type: Specifies pay type value for the entry to determine cost and price.
Work Type Code: Specifies which work type the resource applies to. Prices are updated based on this entry.
Currency Code: Specifies the project's currency code that listed in the currency code field in the project card. You can only create a project Journal using this currency code.
Quantity: Specifies the number of units of the project journal's No. field, which is the resource number, that applies. If you later change the value in the No. field, the quantity does not change on the journal line.
Unit of Measure Code: Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.
Project Manager Code: Specifies the project manager assigned to the project or project task.
Hour Bank No.: Specifies the hour bank to which this time entry will apply.
Resource Group No.: Specifies the resource group of the resource related to this entry.
Resource Sub Group No.: Specifies the resource sub group of the resource related to this entry.
Chargeable: Specifies if the price of this entry will be chargeable to the customer.
Unit Cost: Specifies the cost of one unit of the item or resource on the line.
Unit Cost (LCY): Specifies the cost, in LCY, of one unit of the item or resource on the line.
Total Cost: Specifies the total cost for the journal line. The total cost is calculated based on the project currency, which comes from the Currency Code field on the project card.
Total Cost (LCY): Specifies the total cost for this journal line. The amount is in the local currency.
-Unit Price: Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.
Total Price: Specifies the total price in the project currency on the journal line.
Line Discount %: Specifies the line discount percentage.
Line Discount Amount: Specifies the discount amount that is granted for the item on the line.
Line Amount: Specifies the amount that will be posted to the project ledger.
Profit %: Specifies the profit percentage for the time journal line.
Cost Type: Specifies the profit percentage for the time journal line.
G/L Account No.: Specifies the general ledger account to which this entry will be posted.
Bal. Account No.: Specifies the offsetting general ledger account to which this entry will be posted.
Pay Type Cost Factor: Specifies the pay type cost factor of the resource time entry. Unit cost will be adjusted by this factor.
Pay Type Price Factor: Specifies the pay type price factor of the resource time entry. Unit price will be adjusted by this factor.
Global Dimension 1: Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.
Global Dimension 2: Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup.
Create a new time journal batch by importing values
Prepare an Excel file with one line in Excel for each transaction line to import into the Time Journal, using the appropriate values based on above field descriptions.
Navigate to Journals > Time Journal
Navigate to Process > Import Time Entries
In the Import Time Journal page that opens, complete the following:
- Project Task No.: Specify the value of the project task number field. This value will be applied to any lines with a blank project task number in the import file.
When formatting the Project Task No. field in Excel (in preparation for importing), you cannot use a leading zero or a trailing zero if the task number is formatted to two decimal places. For example, if your task number is 100.10, and you try to run the import, the file will fail to import and you will receive an error message "The field Project Task No. of table Project Journal contains a value (100.1) that cannot be found in the related table (Project Task). To resolve this, be sure to format the field as Text in Excel by placing an apostrophe at the beginning of the number (i.e. '100.80) so the leading or trailing zero is not deleted by Excel and the file can import successfully.
Time Journal Template: Select the time journal template to use for the lines to be imported.
Time Journal Batch: Specifies the value of the time journal batch field for the lines to be imported.
Select File: Select the ellipsis and select Choose to navigate to the file you wish to import.
Advanced: Expand the Advanced fast tab to add additional parameters for the import:
Maximum rendering time: Specifies the maximum time it can take to render the report. If exceeded, the report will be canceled. The value must have the format [d.]hh:mm:ss[.ffffff]. Milliseconds can be included but will be ignored.
Maximum rows: Specifies the maximum number of rows that can be included in this report. If exceeded, the report will be canceled.
Maximum documents: Specifies the maximum number of documents that can be included in this report. Notice that this setting applies to document reports only. If exceeded, the report will be canceled.
Select OK to begin import.
You will receive a message upon successful completion of import "Import Completed". Select OK.
You can review the imported file and when ready, select Post/Print > Post to post the batch, or Post/Print > Test Report to preview and print a report of the batch.
For more information see: