Export GL Journal File

Use the Export GL Journal File routine to export the GL journal entries for the selected periods to an Export file.  The exported journal entries are generally used for a specified General Ledger system.  There are different export formats for each of the General Ledger systems.  The export formats and the attributes of the export files are set during Export Control Maintenance.

Tip:  For more information about working with data in fields, see the Data Entry Guidelines.

Directions:

To see directions for...

• Opening Export GL Journal File, click More.

   

  1.  Click Utilities from the Menu Bar.

  2.  Click Exports.

  3.  Click Export GL Journal File.
  
  Tip:  Or, use the keyboard shortcut:  [ALT] [t] [e] [Enter].
  
  
  Note:  You may be able to access the General Ledger menu while in another INVISION module.  To activate the General Ledger menu in another module, the G/L Application Control must be set up for the module during installation.

   

  Export GL Journal File Window Example:

  

   

• Choosing the selections at the prompt window, click More.

   

  Export G/L Journal File Prompt Options Tip:  To see more information about a field, click the hyperlink for the field name.
  Transmission Date	The system date displays as the Transmission Date.  To enter a different date, click and enter the Transmission date. (mmddyy, slashes not necessary)
  Control ID	Enter the defined Export Control ID that will be used to control the G/L Journal export. Tip:  To search for the Control ID, click Search or press [Ctrl + f].
  Export Journals Again	To export the selected journals again, click to check the Export Journals Again box. To omit exporting the journals again, leave this box unchecked.
  Consolidate by Account	To consolidate entries by account, click to check the Consolidate by Account box. To omit consolidating entries by account, leave this box unchecked.
  Exclude Accounts that Net to Zero	To exclude from the export accounts with entries that net to zero, click to check the Exclude Accounts that Net to Zero box. To omit excluding from the export, accounts with entries that new to zero, leave this box unchecked.
  Journal Periods	To select the Journal Periods to export, click to check the appropriate Periods listed. Tip: To quickly select or de-select all Journal Periods listed, click the Check All icon.
  	To run the routine, click Proceed, or press [ENTER]. Keyboard shortcut:  [ALT + p]
  	To escape from the routine, click Cancel. Keyboard shortcut:  [ALT + c] Tip:  Or, click Close .
  Export File Processing Note:  As the Export processes, various messages display in the Export GL Journal File Window as seen below.  When the Export file is created, the following functions are available.
  	To view all the Export processing messages, click View Messages.
  	To send the Export GL Journal File Messages report to a printer, click Print . Tip:  You will then see the Windows™ Print dialog window for your default printer.
  	You can freeze the Export GL Journal File Messages report by saving it to a file.   Directions: 1.  Click Save As Text .  The Windows Save As screen displays.     2.  Follow the normal Windows™ save procedure: Navigate to the appropriate location. Type a new file name, if desired. Click Save.
  	To close the window when finished, click Close.

   

• Report Sample(s), click More.

   

  To see an example of the report, click Export GL Journal File Report Sample.