This page is currently being edited by {{ model.editingBy }}.

SmartFusion Modules > Fund Ledger > Parameters > Journal Entry Import File Definition

Recent Changes: 
6.181 - fixed a bug that would duplicate the stored file definition if a layout was set to fixed width first prior to being set to a delimited layout

6.78 - Added option for definition file to be both an import and export

Introduction

This screen allows for the creation of definition files for the importing of journal entries. The same file can also be used as a post-to-ledger export file for UB, TX, AR and CP.

Explanation of Definition File Details

Description
Use as import only or Use as import and export
Fixed length fields or Delimited fields
Delimited character
One amount field

Debit is + Credit is -
D or C in Amount Type (Amount Type must precede amount fields)

Implied Decimal
Date Format
Number of Header Records
Number of Trailer Records
Detail Record Fields

Account Number
Posting Detail or Account Description
Debit Amount
Credit Amount
Date
Batch
User
Amount Type

{{ $tag }},

This page was last updated {{ model.lastModified }} ago by {{ model.createdBy }}. History The page has been updated. Click here to reload.

{{ model.title }}

Introduction

Explanation of Definition File Details