Nominal Accounts and Journals

To import Nominal Ledger transactions you need to identify two import files; one for the transaction records (NHEAD) and another for the analysis records (NDETL). The table shows the database files that are updated when Nominal Ledger accounts and journals are imported, along with the mandatory fields that must be part of the import file.

The Importer works the Open Period Accounting (OPA) feature to update the Nominal Ledger with transactions supplied in a DBF or CSV file. For more information, see the Importer & Open Period Accounting Help topic.

Type of File

Databases Updated

Mandatory Fields

Nominal Accounts

NACNT

NA_ACNT

NA_CNTR

NA_DESC

NA_TYPE

NA_SUBT

Nominal Journals

You can choose to import Nominal Journals only, or to import Nominal Journals and post them as transactions to the Nominal Ledger.


Select the Update Nominal option on the Import Wizard to import journals and post them to the Nominal Ledger.

You can choose whether to update the current or previous financial year. You can select any period in the previous year or any period in the current year up to the current period.

This is only available if the Real Time Update of Nominal option is selected in the System - Maintenance - Company Profiles command.

NHEAD

NH_REF

NH_DATE

NH_NARR

NH_DRTOT

NH_CRTOT

NH_VATANAL

 

NDETL

ND_REF

ND_ACCOUNT

ND_DRAMNT

ND_CRAMNT

If importing a detail line that includes a VAT code:

ND_TAXDATE (tax point date - this is mandatory if the VAT code used is not beyond the scope of VAT)

ND_VATCDE

ND_VATVAL

ND_VATTYP

ND_TAXDATE

ND_VATVAL