Navision File Layout

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

Note

Navision uses dataports to import data. This layout is what the AMSI customized dataport uses. Use of this format limits the Entity ID to five characters and uses the standard AMSI 4-3-3 format for account numbers. This is a fixed length format with a carriage return/line feed between each record.

Field	Position	Length	Value
PropertyId	1-5	5	Entity ID*
Deposit/Credit/Journal Entry )	6-7	2	DP (Deposit) CR (Cash Receipt) JE (Journal Entry)
Transaction date	8-13	6	Date of Record (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