GL/ Register

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No