Open topic with navigation
GL Transactions Import Tab
Make the following menu selections to display this tab:
eFinancials—Data
Transfer—GL
Transactions Import
Use this tab to import general ledger transaction data,
including intercompany transactions, which create general ledger transactions
(batches and journal entries) within eFinancials.
Note
GL transactions cannot be imported for accounts that
are tracked by unit (i.e., the Track Unit? selection
is Required on
the GL Account Maintenance Tab). When applicable, the GL
Transactions Import Exception report lists any accounts that could
not be imported for this reason.
Prerequisites
Prior to import, an XML or ASCII file must be stored
on your system. For a successful import, the file you created in another
software application should match the format used in this software. If
you add batches manually, confirm that you have a batch set up and available
for selection.
To Import Transaction Data
- Click Current
Settings to display the Quick Popup and select a date, batch, and
date, batch, and companydate, batch,
property and entity
for the import. Selections you make in the Quick Popup are used as default
entries for importing.
- Complete Step 1 to
select a file.
- Complete Step 2 to
decide whether to create intercompany transactions and/or a new batch.
Completing Step 1
- Click Browse.
The operating system navigation window displays.
- Navigate to and select
either of the following file types: GL.XML or GL.ASCII.
- Click Load
Import File. The system uploads the file to the server and updates
the tab for step 2.
Completing Step 2
- Determine
whether intercompany transactions need to be created.
- At Create
Intercompany Transactions, select this option if the imported transactions
include intercompany transactions.
- Determine
whether a new batch needs to be created. Note that selections made
on the Batch Tab of global policies affect
the batch-related fields that display. Depending on the selections all
or none of the fields detailed in the following steps can display. If
none of the fields are displaying, the transactions are added to the currently
selected batch. Continue reading at step 9.
- At Create
new batch, select this option if you want to create a new batch
for the import transactions. Additional fields display. If you do not
select this option or if this option is not available for selection, the
transactions are added to the currently selected batch.
- At Auto
approve batch, select this option if you want to automatically
approve the batch and complete the remainder of the fields on the tab.
Otherwise, continue reading at step 9.
NOTE that if your system is set to allow incomplete journal entries
and to Import Unbalanced JEs or JEs with Errors
as Incomplete JEs, this label will read Auto
approve batch if complete JEs. The Create Intercompany Transactions
and Create new batch check boxes will no longer show if global policy is
set to Always
Import as Incomplete JEs.
- At Approved
Date, enter a date using the format mm/dd/yyyy. Or use the Calendar
icon to select a date.
- At Approved
By, enter the approver's name.
- At Approval
Code, enter the code.
- Click Import Now. A success message displays when the import
is finished. The message lists the ID of the newly created batch if create
new batch option was selected.
- Click OK.
See
Also
Data
Transfer File Formats Introduction
GL
Transactions Import File Format CSV
GL
Transactions Import File Format SDF
GL
Transactions XML File Format
GL
Transactions XML File Format - Job Cost
GL Transactions Import Errors
GL Intercompany
Overview