Microsoft Dynamics NAV - C/SIDE Solution Development -

Microsoft Dynamics NAV – C/SIDE Solution Development

Locus IT ServicesMicrosoft Dynamics NAV – C/SIDE Solution Development

Lesson 1: Prerequisite Knowledge

Prerequisite Knowledge

Prerequisite Knowledge : Before you begin to work on posting, it is important to know about journal tables, ledger tables, and some of the elements that are involved in posting.

Journal, Ledger and Register Tables and Pages

Journal tables, ledger tables, and posting code units are at the core of every posting process in Microsoft Dynamics NAV 2013.

Journal Tables 

A journal is a temporary work area for the user. Users can insert, change, and delete all records in journals. A journal consists of three tables.

Table Remarks
Journal Template Journal templates represent transaction types, such as sales, cash receipt, inventory, or reclassification. There is typically only one journal template per transaction type, but users may decide to define more.
Journal Batch Batches may represent various logical subtypes of the same transaction type. For example, users may have different cash receipt batches for different bank accounts or customer groups, or different inventory batches for different locations or item types. Sometimes, batches represent different users who use them to physically separate transactions that are entered by different users.
Journal Line Journal line tables store the information about the transaction itself.

Lines belong to batches, and batches belong to templates. The “Journal Structure” figure shows how journal tables are related to one another.

The Journal Page

The primary page to enter information into journals is called by the transaction type, and followed by the word Journal, for example: Sales Journal, Cash Receipt Journal, Resource Journal, or Consumption Journal. The page is of type worksheet, and uses Journal Line as its source table.

The primary key of a Journal Line table is a composite key, and consists of the Journal Template Name, Journal Batch Name and Line No. fields. The user never enters information into any of these fields directly. Instead, the Journal page sets the field according to the following rules:

  • The Journal page that the user accesses sets the Journal Template Name If there are more templates for the same Journal page, then users must select the template when they start the Journal page. They cannot change the template unless they close and then reopen the Journal page.
  • The journal page also sets the Journal Batch Name However, the user may change the Batch Name field at the top of the page.
  • The Line No. field keeps each record in the same template and batch unique. The batch page sets the Line No. field automatically through the AutoSplitKey property.

The Journal page lets users enter and edit the journal lines that will later be posted into ledger tables. As long as the lines are in the journal, users can freely change or delete them, and they have no effect until the user posts the journal. Users can even leave the lines in the journal table indefinitely.

Locus IT Project Management Office
What’s it?