Inventory to GL Reconciliation – Chapter 5 – The Report
When someone inquires as to how to reconcile their inventory to the general ledger or someone complains ‘my inventory does not tie to my general ledger’, my first response is a question……What report are you using to do your reconciliation? The majority of the time, the answer is ‘Inventory Valuation.’ And my second response is […]
Inventory to GL Reconciliation – Chapter 4 – Posting Groups
Inventory posting groups control the balance sheet portion on entries relating to inventory. When inventory posting groups do not ‘line up’ to the desired group of items, it typically points to a change on the item card without an associated change in the general ledger. In more drastic out of balance conditions, it could be […]
Inventory to GL Reconciliation – Chapter 3 – Posting Setups
We always talk about the importance of posting setups; no where is it as important as when it comes to subledger reconciliations. There are two posting setups that are important related to inventory subledger reconciliation – inventory posting setup and general posting setup. Inventory posting groups combine with location code values to direct general ledger […]
Inventory to GL Reconciliation – Chapter 2 – Direct Posting
What is direct posting? It’s a toggle/flag/checkbox on a general ledger account card. What does it do, you ask? It controls whether you can use the specific general ledger account in postings. And by that, I mean that you cannot manually enter the account in journals or on documents. Why is that important? By not […]
Inventory to GL Reconciliation Chapter 1- Concepts
There are a handful of concepts intricately connected and are an absolute must for understanding how inventory transaction flows throughout the system, what is affected and how the subledger is connected to the general ledger. Posting an inventory transaction has three important pieces. 1) To track quantity, records are posted to the item ledger entry […]
Get Excited!! BC version 20 Has Excel Layouts
WOW, I’m so Excited for the Excel Layouts in BC version 20 (Wave 1 2022)! I didn’t know how this would really work and I was worried that it would be hard to learn. I couldn’t wait to try it and see what could be done. I started out without any knowledge or instruction and […]
Inventory to GL Reconciliation Series – Introduction
For the past several years, I’ve presented sessions on Reconciling Inventory to the GL for Dynamics NAV and Business Central at various events such as Focus, Summit, Directions, All-Star webinars and others. With over 26 years working in BC/NAV and helping numerous customers reconcile inventory to the general ledger, my knowledge on this subject has […]
KimD and NAV|BC
Welcome my new NAV|BC Sharing site! For the last 26 years, I’ve work on this wonderful product. I’ve learned a great deal, I’m always learning more and I know I have way more to learn….so much fun! Sharing how to’s, copies of presentations, links to other sites are just some of the ways to meet […]