Column Name | Required | Default Value | 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 |
...