ASCII File Layout

Use this format to create the file used to import data into the AMSI DOS G/L system.

 

Field

Position

Length

Value

PropertyId

1-5

5

Entity ID*

Deposit/Credit/Journal Entry

6-7

2

DP (Deposit), CR (Cash Receipt) or JE (Journal Entry)

Transaction date

8-13

6

Date of record* as YYMMDD

RefCheckNo

14-19

6

Check or reference number*

GlDesc

20-49

30

Description/income code*

GlAcctNo

50-59

10

GL Account Number (AMSI format)*

AmtToGl

60-71

12

Amount of Transaction

Reference

72-86

15

GL Transaction Reference*

AR Period*

87-90

4

YYMM

GL Period*

91-94

4

YYMM

Reversal Flag

95

1

R or blank

Example:

01MEAJE050701AUTO07Lease Charge-Rent:02-201      4017000       -1020.00RPM08          05070507

01MEAJE050701AUTO07Lease Charge-Rent:02-201      1200000        1020.00RPM08          05070507

01MEACR050701AUTO07Cash Receipts-Rent:02-201     1200000       -1020.00RPM0Meadow7    05070507

01MEADP050701AUTO07Cash Receipts-Rent            1010           1020.00RPM0Meadow7    05070507

 

See Also

AME, Interface Tab

Transfer to GL File Layouts Overview

Transfer to GL Tab

Transaction Descriptions for Transfer to GL Files

Online Payments Interface for Transfer to G/L

Transfer to G/L for Online Payments

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.