- 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.
Note: You can also import general ledger journal information into Greentree Desktop using the FREE gtGLJournal function.
Setup
Access the 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 then select Interface name.
Executing the Process
Access the GL Import Journal form by selecting Workflow > System > Data Import Schedule. Use this form to create 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 Desktop rate is used. |
|
Posting Date |
dd/mm/yy |
|
|
Company |
Alpha |
Company code, max three characters |
|
GL Account No |
|
Structured using account set up |
|
Sub code |
|
Maximum six characters |
|
Cash Analysis Code |
|
|
|
Transaction Rate |
Numeric |
Currency conversion rate for the journal line. If empty Greentree Desktop 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 |