Template: Journal Entry


Column Name

Required

Note


Journal Entry Transaction











            

JournalDate


X

Identifies the date that the Journal Entry will post to the GL

HeaderComment



Reference



JournalStatus

X

The value can either be ‘New’, ‘Approved’ or ‘Ready to Post’.

Currency


The value defaults to the Company currency if not provided.

ExchangeTable


The value defaults to the first exchange table with the selected currency when the currency entered is other than the company currency.

RateType


The value can either be ‘Multiply’ or ‘Divide’.  The value defaults to the Exchange Table Rate Type when an existing Exchange Table is entered.

ExchangeRate


The value entered is used to calculate the Home Debit and Home Credit amounts.  The value defaults to the Exchange Rate Type when an existing Exchange Table is entered.

AccountNumber

X

Identifies the GL Account for the Journal Entry Transaction.

DebitAmount

X

Each row in the template must have a value entered for either the Debit or Credit amount.

CreditAmount

X

Each row in the template must have a value entered for either the Debit or Credit amount.

Project



LineComment