How to Create a Journal Entry in Excel and Upload it to Dynamics 365 Business Central

A client recently asked me for instructions on how to create journal entries in Excel and then be able to “Copy and Paste” or “Upload” the entry from Excel to Business Central (If I had a dollar for every time I’ve heard “QuickBooks can do it…”). I had been addressing this before by showing a… Continue reading How to Create a Journal Entry in Excel and Upload it to Dynamics 365 Business Central

Using NAV Item Journal to Issue Items to Different Expense Accounts

Scenario: You would like to Debit different General Ledger Expense Accounts when you issue stockroom material using the Dynamics NAV Item Journal. For instance, if the engineering department uses stock room inventory for a project, you would like to debit the Engineering Expense Account for the cost of the inventory. Without doing any additional setups,… Continue reading Using NAV Item Journal to Issue Items to Different Expense Accounts

Which GL Account Will Purchase Receipts and Invoices Post to?

The other day, the question came up about how to determine which Dynamics NAV General Ledger Accounts are posted to for a Purchase Receipt and Invoice. First, we need to find our way to the Item Ledger Entry for the receipt you want to analyze. Figure 1 – Item Ledger Entry showing the receipt to… Continue reading Which GL Account Will Purchase Receipts and Invoices Post to?

Ensuring All Items are Posted When Using a Nightly Batch Job

Running Adjust Cost-Item Entries and Posting Cost to G/L in Microsoft Dynamics NAV Whether you use the Dynamics NAV automatic features to run the Adjust Cost-Item Entries and Post Cost to G/L processes during nightly batches or run them manually, nearly all of the time these processes work correctly and produce the correct results. However,… Continue reading Ensuring All Items are Posted When Using a Nightly Batch Job

Reducing the Quantity of Inventory Sub-Ledger Entries

We often hear the comment that Dynamics NAV posts too many Inventory Sub-Ledger entries to the General Ledger. There is a way in Dynamics NAV to reduce the number of General Ledger entries when running the batch report “Post Inventory Cost to G/L”. When running the batch report, select “Per Posting Group” and the system… Continue reading Reducing the Quantity of Inventory Sub-Ledger Entries

Hints on Navigating on an Item Ledger Entry in Microsoft Dynamics NAV

We frequently use the Dynamics NAV Navigate tool and Microsoft Excel to verify Item Ledger Entry postings to the General Ledger. When Navigating on an Item Ledger Entry that involves both a purchase receipt and a purchase invoice, you must do two Navigations to see all of the General Ledger postings. We start our scenario… Continue reading Hints on Navigating on an Item Ledger Entry in Microsoft Dynamics NAV

General Ledger Postings for Microsoft Dynamics NAV Subcontracting

In an earlier blog, we explained the setup for Microsoft Dynamics NAV Subcontracting, and now we will explain the General Ledger Postings for a Sub Contract Production Order. Quick Start Guide for Setting up Microsoft Dynamics NAV Subcontracting We have set up a Work Center called SUBCONTRACT that points to the SUBCONT General Product Posting… Continue reading General Ledger Postings for Microsoft Dynamics NAV Subcontracting

Connecting GL Entries to Value Entries in Microsoft Dynamics NAV

When trying to figure out what caused a posting to the Dynamics NAV General Ledger, there is a handy tool in Dynamics NAV you can use. If you are in the Dynamics NAV General Ledger Entries and want to know what Value Entry/Item Ledger Entry caused the posting, you could ‘Navigate’ or use the available… Continue reading Connecting GL Entries to Value Entries in Microsoft Dynamics NAV