- Contents
- Index
- Search
Display results with all search words
GL Import Journal Interface Set up
This process imports a file containing journal data, which is extracted from a third-party product. You can use the process to import any general ledger journal, as long as the import file is in the correct format.
You can also
import general ledger journal information into Greentree Desktop using
the FREE gtGLJournal function.
Setup
Access the UT Interface Maintenance form to view the GL Import Journal interface type, which specifies the attributes and values to update when a comma delimited ASCII file is imported into Greentree Desktop. To view the interface, select the GL Import Journal Interface type, and Interface name.
Executing the Process
Access the GL Import Journal form from Workflow > System > Data Import Schedule. This process creates a general ledger journal batch by importing the contents of a comma delimited ASCII file.
A suspense entry is created if necessary to balance the journal. There may be multiple documents referenced in the import file, but they must all belong to the same batch, and have the same posting date.
Import File Format
The import file uses these field codes:
|
Field |
Format |
Comments |
|---|---|---|
|
Document No |
Alpha |
|
|
Document Date |
dd/mm/yy |
|
|
Detail |
||
|
Accrual |
Boolean |
True if an accrual journal |
|
Accrual Reversal Date |
dd/mm/yy |
Date for the accrual reversal |
|
Currency Code |
Valid currency code |
|
|
Currency Rate |
Numeric |
Currency conversion rate for the journal. If empty Greentree rate is used. |
|
Posting Date |
dd/mm/yy |
|
|
Company |
Alpha |
Company code, max three characters |
|
GL Account No |
Structured as per account set up |
|
|
Sub code |
Maximum six characters |
|
|
Cash Analysis Code |
||
|
Transaction Rate |
Numeric |
Currency conversion rate for the journal line. If empty Greentree rate is used. |
|
Narration |
Alpha |
|
|
Quantity |
Numeric |
May be empty unless account to be posted to is a quantity account and not checked to enable blanks |
|
Amount |
Numeric |
|
|
Transaction Tree Short Code List |
||
|
Current Date |
||
|
Current Time |
Currency Rate versus Transaction Rate Usage
The currency rate used on each journal line is determined by this decision tree. A journal can only have one currency code which is determined on the first line of the journal.
|
If |
Journal currency code = Ledger currency code |
1.0 |
|
else if |
Journal currency code = GL Account currency code |
1.0 |
|
else if |
GL Account currency code = Ledger currency code |
Currency Rate |
|
else |
Transaction Rate |