Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

GL/ Register

Posted on by Microsoft Employee

I get the sense that Navision loosely uses the terms G/L and general journal interchangeably. You post journal entries in the general journal, and the entries are then posted to the genral ledger ("T accounts". But it seems to me that if you wanted to view the general journal in Navision, you would call up the G/L register.

Is this correct? Thanks.

*This post is locked for comments

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: GL/ Register

    It contains the general ledger register that is created every time a general ledger entry is posted.

    It is create when posting of a journal in the General Ledger, Sales & Receivables, or Purchases & Parables application areas; posting of sales orders, invoices and credit memos; posting of purchase orders, invoices and credit memos; and finance charge calculations and batch jobs (such as the Adjust Exchange Rates and Post Inventory Cost to G/L batch jobs). G/L entries can also result from importing consolidated company financial statements.

    You can see the G/L registers for the General Ledger, Sales & Receivables, and Purchases & Parables application areas under the Registers menu item on each application area's main menu.

    G/L registers may also contain customer and vendor ledger entries that have the same entry number as a G/L entry.

    Every register shows the first and last entry numbers of its entries.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: GL/ Register

    Hi Mjmillar,

    G/L Register Table: "contains the general ledger register that is created every time a general ledger entry is posted". It is not used to view the General Journal.

    I think you can open General Journal Worksheet directly by using system Search function (top right search text box) or from Journal Batch -> Edit Journal.

    Some helpful links:

    www.youtube.com/watch

    msdn.microsoft.com/.../hh168755(v=nav.90).aspx

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: GL/ Register

    Users use General Journals (or, some time they are called Financial Journals) to input (fill in) the data for future posting. Then, when they post this data, it disappears from the journal but then appears as posted data in the other ledgers. It can be General Ledger (or G/L Entry table), as well as in addition other ledgers (e.g., Customer and Detailed Customer Ledgers, VAT ledger, etc.) - depending on the nature of the posting. As you correctly mentioned, the General Ledger is meant to keep T-accounts information (as well as some other additional information, such as e.g. dimension values, transaction numbers, source ids, etc.).

    However please note that users also fill in and post transactions via other documents - e.g., sales and purchase invoices, etc. - however when the posting takes place, NAV anyway pushes the posting procedure through the same General Journal posting procedure.

    When user makes a posting that results in General Ledger records (T-accounts), a separate special table is also filled, and this is G/L Register. You can refer to it as a sort of a log that shows which user had created certain entries and when, and how they were created. Normally, users are not interested in this information, unless they would like to reverse one full register for some reason. Refer more to G/L Register information: msdn.microsoft.com/.../hh171493(v=nav.90).aspx

    So, referring to your question: when you post the General Journal, this info disappears from there. The result of the posting you would see in General Ledger, and the information about who had done certain entries and when you will find in G/L Register.

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: GL/ Register

    Hi there,

    the G/L register is the bundle "header" of a general journal or a document - or an automatic posting, like adjust cost on inventory. From there you can look up all entries that belong to this register and have been generated in one posting. It can contain several transactions, though.

    For reference in NAV:

    * ledger entry - posted entries, non-changeable on all ledger-defining fields

    * journal - unposted entries, not necessary the same structure that is posted (ex: VAT)

    * register - record that bundles all entries of a posting.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans