• Companial
  • Become a QBS Group member
    • Why to Partner with QBS?
    • CRM & Platform
    • ERP
  • Companial Partner Portal
  • QBS Academy
  • Global
    • Belgique - Français
    • België - Nederlands
    • Danmark
    • Deutschland
    • España
    • France
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
  • Global Global Global en
  • Belgique - Français Belgique - Français Belgique - Français fr-be
  • België - Nederlands België - Nederlands België - Nederlands be
  • Danmark Danmark Danmark da
  • Deutschland Deutschland Deutschland de
  • España España España es
  • France France France fr
  • Italia Italia Italia it
  • Nederland Nederland Nederland nl
  • Norge Norge Norge no
  • Österreich Österreich Österreich at
  • Polska Polska Polska pl
  • Schweiz Schweiz Schweiz ch
  • Sverige Sverige Sverige sv
  • United Kingdom United Kingdom United Kingdom en-uk
QBS group
Menu
  • Info Centre
    • Blogs
    • Events
    • News
    • References
    • Training
    • Close
  • Solutions
  • Services
    • QBS Marketplace
    • Ready to Start – Dynamics 365 Business Central
    • Ready to Start Dynamics 365 Customer Engagement
    • Ready to Go for Dynamics 365 Business Central
    • Ready to Go Activate and Accelerate Program for Dynamics 365 Business Central ISVs
    • Take the Lead
    • Upgrade Services
    • QBS Academy
    • QBS Azure Services
    • Close
  • Partner Program
    • Become a partner
    • Indirect CSP
    • ISV Program
    • Close
  • About us
    • About QBS group
    • Vision, Mission and Strategy
    • Timeline
    • Management team
    • Our Partners
    • Career
    • Close
  • Contact
Blog written by:

Jan Boes

Time to read: 5-10 minutes
Share this:
  • Share on Facebook
  • Share on Twitter
  • Share on Google+
  • Share on Linkedin
  • Share by Mail
23 April 2018

NAV posting procedures

You are here: Home » NAV posting procedures

QBS group

Tech

One of our partners requested some background information on the NAV posting procedures and what the meaning is of the different ledger entries tables.

NAV has two posting procedures:

  1. Journal: the resource is added in a journal line and a resource ledger entry is created via the journal posting
  2. Document: the resource is used in a document and a resource ledger entry is created via the document posting routine

1. Journal posting

The scenario explained in this chapter is that Linda and Mark have worked on a project for 8 hours. When these journal lines are posted, one register entry and two resource ledger entries are created.

Posting Date Resource No. Description Quantity Unit of Measure Unit Cost Unit Price
23-01-2020 LINDA Linda Martin 8 HOUR 6,30 50,40
23-01-2020 MARK Mark Hanson 8 HOUR 31,90 54,00

To be able to make this posting we need to setup resource templates, – batches and the resource itself.

1.1. Setup

In the resource template and batches information are stored including number series, source and reason codes.

The last setup step is to create the resource information.

1.2. Journal posting

Now all setup information is complete, it is time to create the journal lines and post these.

As shown the default Resource journal batch is used and the information from Linda and Mark is inserted. When the “Post” action is pressed a message is displayed if the user wants to post the resource journal lines. The user has to confirm the posting and the posting is executed and the resource ledger entries are created.

1.3. Navigation, journal register and entries

There are a number of possibilities to retrieve information from this posting.

From the resource list or card, the action “Ledger Entries” will give an overview of the resource ledger entries.

Another way to find the resource entries is to use the Navigation page

Or you can find the resource entries via the Resource register.

1.4. Technical information

Now we have covered the functional part of the posting, it is time to see the technical side.

When the “Post” button is pressed the following codeunits are executed

Codeunit ID Codeunit Name Function
271 Res.-Jnl.-Post Starting point for posting transaction
213 Res.-Jnl.-Post Batch Open dialog and execute for every line the check (211) and post (212) codeunit
211 Res.-Jnl.-Check Line Check if user is allowed to post based on user and/or general ledger setup and if no dimension conflicts can occur
212 Res.-Jnl.-Post Line Actual posting:
Create or update resource register
Create resource ledger entry

The above-mentioned journal posting is the preferred one, but if you have a lot of batches with journal lines to be posted, it is possible to post the journal lines via the batch page.

When the “Post” button is pressed the following codeunits are executed

Codeunit ID Codeunit Name Function
273 Res.-Jnl.-B.Post Starting point for posting transaction
213 Res.-Jnl.-Post Batch Open dialog and execute for every line the check (211) and post (212) Codeunit
211 Res.-Jnl.-Check Line Check if user is allowed to post based on user and/or general ledger setup and if no dimension conflicts can occur
212 Res.-Jnl.-Post Line Actual posting:
Create or update resource register
Create resource ledger entry

2. Document posting

It is possible to post resource information in a sales order, so the customer gets an invoice for the worked hours.

The scenario explained in this chapter is that Linda and Mark have worked on a project for customer “The Cannon Group PLC” for 8 hours.

Posting Date Resource No. Description Quantity Unit of Measure Unit Cost Unit Price
23-1-2020 LINDA Linda Martin 8 HOUR 6,30 50,40
23-1-2020 MARK Mark Hanson 8 HOUR 31,90 54,00

2.1. Document posting

The following sales order is created and posted (ship and invoice).

2.2. Navigation, journal register and entries

The navigation options described in paragraph 1.3 will still work to find the sales order posting entries. One additional option is possible: from the sales invoice, the action “Navigate” on the “Actions” ribbon gives an overview which entries have been created during the posting.

2.3.  Technical information

When the “Post” action on the Sales Order page is pressed Codeunit 80  “Sales-Post” will be executed to create the ledger entries.

During the posting routine, for every line is checked what type it has and when it is a Resource type line, the information from the sales line will be copied to a resource journal line and that journal line is checked and posted.

The code line ResJnlPostLine.RunWithCheck(ResJnlLine) starts the resource posting.

Codeunit ID Codeunit Name Function
212 Res.-Jnl.-Post Line Actual posting:
Create or update resource register
Create resource ledger entry

Yes, you already came across that number. The same posting codeunit is used in the journal and in the document posting routines.

3. NAV Ledger Entries

The second part of the question was that within NAV there are a lot of different ledger tables. Where are they used for?

That question is a bit tough as there are indeed a lot of ledger entry tables

No. Name
21 Cust. Ledger Entry
25 Vendor Ledger Entry
32 Item Ledger Entry
169 Job Ledger Entry
203 Res. Ledger Entry
271 Bank Account Ledger Entry
272 Check Ledger Entry
281 Phys. Inventory Ledger Entry
317 Payable Vendor Ledger Entry
379 Detailed Cust. Ledg. Entry
380 Detailed Vendor Ledg. Entry
5601 FA Ledger Entry
5625 Maintenance Ledger Entry
5629 Ins. Coverage Ledger Entry
5832 Capacity Ledger Entry
5907 Service Ledger Entry
5908 Warranty Ledger Entry

And even more entry tables. The first eight are shown, the others can be found via the NAV object designer.

No. Name
17 G/L Entry
96 G/L Budget Entry
160 Res. Capactity Entry
179 Reversal Entry
254 VAT Entry
265 Document Entry
271 Bank Account Ledger Entry
272 Check Ledger Entry

So which table is a ledger entry and which isn’t? As mentioned in paragraph 1.3 a ledger entry has to have an accompanying register table. In the following table the register and the ledger entry tables are combined.

No. Register table No. Ledger Entry table
45 G/L Register 17
254
G/L Entry
VAT Entry
46 Item Register 32
5802
5832
Item Ledger Entry
Value Entry
Capacity Ledger Entry
51 User Time Register –
87 Date Compr. Register –
240 Resource Register 203 Res. Ledger Entry
241 Job Register 169 Job Ledger Entry
1105 Cost Register 17
1104
G/L Entry
Cost Entry
1111 Cost Budget Register 96
1109
G/L Budget Entry
Cost Budget Entry
1205 Credit Transfer Register –
5617 FA Register 5601 FA Ledger Entry
5636 Insurance Register 5629 Ins. Coverage Ledger Entry
5934 Service Register 5907 Service Ledger Entry
5936 Service Document Register –
7313 Warehouse Register 7312 Warehouse Entry
99000848 Registered Absence –

Conclusion

It’s hard to define what a real ledger entry table is and what not. And things get worse. In previous NAV versions you could just press F1 to get at least some information why the table and fields where created. Unfortunately, information is moved from MSDN towards Microsoft Docs  but I can’t find the information there.

When you search for MSDN and G/L Register you get information from the table and field information can be found via the link “List of Fields in the Table”.

Searching on Microsoft Docs won’t give you any results

What can you learn from this post?

  • Define your posting routine and use it
  • Define a proper naming convention schema and stick to it
  • Define a proper data model and update it

MORE ARTICLES

You may also find this interesting

  • Do you really need the Business Central Universal Code Initiative? Are you shocked? Let’s hope not…

    What’s the Business Central Universal Code Initiative? For a […]

  • Directions EMEA: Moving to Dynamics 365 Business Central SaaS: How to Deliver a Thriving Revenue Stream

    The Microsoft Dynamics 365 Business Central SaaS customer base […]

  • Directions EMEA in Milan and we as QBS Group will be there!

    It was a tough year without meeting each other […]

  • QBS Group has been announced 8th time in a row by Microsoft for Inner Circle for Microsoft Business Applications 2021/22.

    QBS Group has achieved the prestigious 2021/2022 Inner Circle […]

  • Cosmos versus Azure SQL and how to integrate with Dynamics 365 Business Central #MSDYN365BC

    One of the highest-scoring FAQs from partners and customers […]

  • HELP! My Application Insights EXPLODES!

    At QBS Group we are promoting the use of […]

  • How to use the Dynamics 365 Business Central API with C# in Service-to-Service scenarios

    A question that was raised more frequently than others […]

  • Look back at the Microsoft Dynamics 365 Business Central 2020 Release Wave 2 Launch Event

    Microsoft has arranged an absolutely splendid launch event for […]

  • Get the latest insights at the Directions EMEA 2020 and get inspired by QBS Group.

    Directions4Partners Virtual 2020 is focusing on bringing state-of-the-art keynotes […]

  • Closer Cooperation between QBS Group and 1Click Factory

    As of September, Soren Fink Jensen, CEO of 1ClickFactory […]

  • QBS Group is announced by Microsoft for Inner Circle for Microsoft Business Applications 2020/21

    QBS Group has achieved the prestigious 2020/2021 Inner Circle […]

  • QBS Summer School 2020

    Even with the new normal, summer remains the perfect […]

  • Best practices of migrating your customer to Business Central SAAS

    “Migrating Dynamics NAV customers to Dynamics 365 Business Central […]

  • UPDATE – QBS Group support through the COVID-19 outbreak

    On this page, we will be collecting all the […]

  • When Revenue Generation Hits the Top of the Agenda

    (To download the article in pdf format: Revenue Generation Top […]

  • Getting ready for Inspire 2019

    Representing the QBS partner community. Being a Microsoft (Dynamics) […]

  • D365 Business Central April 2019 update – key findings

    April 19 2019 Dynamics 365 Business Central Release   Our […]

  • Interview on QBS group getting shareholder majority in 1ClickFactory

    QBS GROUP TAKES THE MAJORITY OF 1CLICKFACTORY SHARES Microsoft […]

  • Press release: QBS group becomes majority shareholder of 1ClickFactory

    Leusden, The Netherlands, April 2019   QBS group and […]

  • Daily reports from eXtreme 2019, Amsterdam

    Our Dynamics Expert Arjen Jansen is providing daily reports […]

  • Business Central is now available in Microsoft Graph – could this be the end of RapidStart?

    Business Central API in Microsoft Graph Dynamics 365 Business […]

  • QBS group becomes the 1ClickFactory representative in Benelux

    1ClickFactory has, with effect from January 1, 2019, changed […]

  • How to integrate Power BI in Dynamics 365 Customer Engagement dashboards

    You are well familiar in the world of ERP […]

  • Update Dynamics 365 Business Central

    This series of webinars is intended to share the […]

  • Hot news from Directions EMEA 2018

    Like every year, QBS group is attending Directions EMEA […]

  • We’re on the verge of something big – reflections on Directions EMEA 2018

    With Directions EMEA 2018 coming to an end, there […]

  • Introduction in D365 Marketing

    Dynamics 365 Marketing is the new kid on the […]

  • Dynamics 365 Business Central Explore Workshops
  • It’s that time of year again

    Dear Dynamics partners, It’s that time of year again, […]

  • The world is no longer black or white…

    ERP + CRM = Dynamics 365 = QBS group […]

  • The moment you stop learning, you stop leading…

    ‘Stagnation is to decline’ that is the motto. So […]

  • Business Report Directions EMEA 2018 – Reserve your copy now!

    Are you not able to attend Directions EMEA 2018 […]

  • Update Dynamics 365 Business Central

    This series of webinars is intended to share the […]

  • QBS group is growing!

    Even though the world is getting smaller all the […]

  • eLWIS Has Left the Building – Goodbye to Customization of ERP Systems

    If you are in the ERP-industry, you have undoubtedly […]

  • Microsoft partner success with Dynamics 365 Business Central: Building a high volume sales engine

    This spring saw the long-awaited release of Microsoft Dynamics […]

  • Overcoming no decision

    Who’s your worst competitor? You would think that your […]

  • The Strength of PowerApps: Accelerate your business with PowerApps

    A constant message during Inspire was about partners adding […]

  • QBS group achieves the 2018/2019 Inner Circle for Microsoft Business Applications

    Leusden, The Netherlands – August 1st, 2018 “QBS group is […]

  • Hot News from Inspire 2018

    Microsoft’s most important partner event of the year is […]

  • Thoughts from Inspire Day 3

    Today started with the keynote from Satya Nadella, and […]

  • Fresh from Inspire – we inform you about the latest and greatest in Microsoft’s Business applications product news

    The latest insights into the Microsoft’s Business applications product […]

  • Thoughts from Inspire Day 2

    Today started again with a keynote from Gavriella Schuster, […]

  • Thoughts from Inspire Day 1

    So, Inspire the largest Microsoft partner conference ever started […]

  • This is how we got posted on AppSource!

    QBS is constantly paying attention to help partners keep […]

  • Ready to Go – Keep Your App Up-to-date
  • Ready to Go – Set-up Extension Testing
  • Ready to Go – Scope Your Extension Development
  • Update Dynamics 365 Business Central

    This series of webinars is intended to share the […]

  • What happens in Vegas…

    Dear Microsoft Dynamics partners, It’s that time of year […]

  • Business Report Microsoft Inspire 2018 – Order your copy now!

    Here’s where QBS group can help you out. We […]

  • Update Dynamics 365 Business Central

    This series of webinars is intended to share the […]

  • It’s GDPR Day!

    Suddenly the calendar is almost on May 25 ’18 […]

  • Introduction into Microsoft Dynamics 365 for Project Service Automation (PSA).

    On this CRM Inspirational Webinar, Arjen Jansen will host an […]

  • The impact of the higher update frequency on customer satisfaction (and your own business!)

    Microsoft is moving all her business solutions into the […]

  • To upgrade or replace that is the question

    Dynamics 365 Business Central completes you customer dialogue In […]

  • Build your businesses muscle and keep fit (in the QBS gym).

    Don’t worry we are not suggesting here that you […]

  • Hot news from the eXtreme 365 EMEA event

    The most important Microsoft Dynamics partner event in the […]

  • Update on Dynamics 365 Business Central

      This series of webinars is intended to share […]

  • “Finally!”

    “Finally!” was one of the reactions I heard stated […]

  • The Cloud – Impact on Business Valuations

    The shift to the Cloud is well underway, and […]

  • What can Dynamics CRM Partners expect from eXtreme365 EMEA 2018?

    eXtreme 365 is the annual event for Microsoft Dynamics […]

  • How to effectively present your winning proposal

    Too often, proposals for new Microsoft Dynamics solutions are […]

  • The QBS Academy helps us by offering a practice-oriented program that is tailored to our needs as a Dynamics partner ….

    “The result of the QBS Academy is that our […]

  • The evolution of Dynamics 365 opens the door for new opportunities

    Being a Dynamics CRM partner today is like dancing on a volcano – far from boring!

  • The Dynamics 365 Acceleration Program has enabled us to acquire the global perspective of implementation of Dynamics 365 for Sales.

    Sofkia Consulting and development. “Within the process of continuous […]

  • MKB365 : “We are ready for Dynamics 365”

    “The result of the Dynamics 365 Acceleration Program is […]

  • “Ever change a winning team”

    “Ever change a winning team” Alex Ferguson, former football […]

  • Why should I care about IoT as an Microsoft D365/NAV partner?

    Adoption of Internet of Things solutions across industries continues […]

  • Creating the winning Quotation

    Your quotation is the first legal document in any […]

  • Looking back at 2017

    As we close our books on 2017, we start […]

  • But do I really need to blog?

    If you want to be noticed and visible online […]

  • What’s new NAV 2018

    Understanding these new possibilities is crucial for your product and / or marketing plans.

  • 4 Business reasons to start a CRM practice

    Microsoft switches from single category products like Dynamics NAV […]

  • GDPR … and what now ?

    Starting from 25 May 2018 there is going to be a […]

  • Stand and Deliver, your customers will be mine!

    Upgrade your Customers NOW! Or Someone else WILL.

  • QBS Azure Services
  • Upgrade Services
  • Organisational Structure
  • QBS Academy
  • Slimstock and QBS group join forces to strengthen QBS partner capabilities

    Leusden, 21th of September 2017 Slimstock: market leader in inventory […]

  • Part 4 Microsoft Dynamics Development Preview

    Microsoft released during last Christmas an Azure Virtual Machine […]

  • Dynamics NAV Development: Extensions or Extinction?

    No one wants to be a dinosaur, it does […]

  • VS Sistemas “QBS group helps us build our road to success.”

    The strategy of VS Sistemas is to improve its […]

  • C2IT Business Solutions about QBS group

    C2IT Business Solutions is a part of C2IT A/S. […]

  • The fact that we belong to a larger organisation gives our customers security.

    Verito delivers Microsoft Dynamics NAV to charity organisations and […]

  • Adfocom “Partner Care saved us a lot of time.”

    Adfocom is an IT service provider based in Alphen […]

What people say about QBS Group

  • Giuseppe Sica

    CEO at Info Studi

    We’ve published a Business App for Dynamics 365 Business Central: QBS partnership joined a key role and so we are the first in Ita

    Read the reference case
  • Ferry Schrijnewerkers

    Owner en Co-founder at MKB365

    Since the start of our company 4 months ago, we have already completed 12 Dynamics 365 for Sales implementations.

    Read the reference case
  • Jan Penning

    Managing Director

    The QBS Academy helps us by offering a practice-oriented program that is tailored to our needs as a Dynamics partner.

    Read the reference case
  • Ricardo Cartagena

    CEO

    The Dynamics 365 Acceleration Program has enabled us to acquire the global perspective of implementation of Dynamics 365 for Sales

    Read the reference case
  • Ronald Hoek

    Co-founder MKB365

    "We are ready for Dynamics 365"

    Read the reference case
  • Joaquim Antón Gimeno

    GRUPO CHOICE

    "Our relationship with QBS group allows us to improve our marketing strategy."

    Read the reference case
  • Sofkia

    "Our alliance with QBS group has been very important in the development of our business strategy."

    Read the reference case
  • VS Sistemas

    "QBS group helps us build our road to success."

    Read the reference case
  • Berith Skov - C2IT Business Solutions

    “We are very satisfied with the services provided by and through QBS group."

    Read the reference case
  • Herke ICT Group- Karing Buzing

    We are once again part of a NAV community.

    Read the reference case
  • Owe Loonstra - Verito

    Manager Sales & Marketing

    The fact that we belong to a larger organisation gives our customers security.

    Read the reference case
  • Adfocom - Jeroen Kersten

    Partner Care saved us a lot of time.

    Read the reference case
  • NavAzure - Michael Francois Knudsen

    “It is important to me, that I through QBS become part of a greater network, where partners can share experience"

    Read the reference case
  • Blisss - Dirko Wijers

    Without the help from QBS group we wouldn’t have succeeded.

    Read the reference case

Program

  • Become a partner
  • Indirect CSP for Microsoft Resellers
  • ISV Program
  • Our Partners
  • Contact

Info Centre

  • References
  • Blog
  • Training
  • Event
  • News
  • Newsletter

Services

  • Dynamics 365 for Sales Acceleration Program
  • Upgrade Services
  • QBS Academy
  • QBS Azure Services

Follow QBS group

© Copyright QBS group 2023
  • Cookie Policy
  • Privacy Policy
To upgrade or replace that is the question The impact of the higher update frequency on customer satisfaction (and your...
We are now Companial!

This is our old website, we’re now Companial.

The content on this page might be outdated.

Enjoy all the new information on our new website.

 

Go to Companial

Please complete the form

Contact us, please complete this form

Join QBS Group, please complete this form

Join QBS Group please complete the form

Join QBS Group, please complete the form

Sign up QBS Group Membership

Send me an email.
Please complete the form


If you are not seeing the form, please check your ad-blocker settings.

Microsoft’s Power platform - Webinar 12 November 2019 - Austria

Download Center

Please complete the form

Please complete the form

Please complete the form

Register for this event
QBS
  • Global
    • Belgique - Français
    • België - Nederlands
    • Danmark
    • Deutschland
    • España
    • France
    • Italia
    • Nederland
    • Norge
    • Österreich
    • Polska
    • Schweiz
    • Sverige
    • United Kingdom
  • Info Centre
    • Blogs
    • Events
    • News
    • References
    • Training
    • Back
  • Solutions
  • Services
    • QBS Marketplace
    • Ready to Start – Dynamics 365 Business Central
    • Ready to Start Dynamics 365 Customer Engagement
    • Ready to Go for Dynamics 365 Business Central
    • Ready to Go Activate and Accelerate Program for Dynamics 365 Business Central ISVs
    • Take the Lead
    • Upgrade Services
    • QBS Academy
    • QBS Azure Services
    • Back
  • Partner Program
    • Become a partner
    • Indirect CSP
    • ISV Program
    • Back
  • About us
    • About QBS group
    • Vision, Mission and Strategy
    • Timeline
    • Management team
    • Our Partners
    • Career
    • Back
  • Contact

This website uses Cookies to give you the best experience. Agreed by clicking the 'Accept' button. After you've clicked on "Accept" you accept QBS group Privacy Statement.

Scroll to top