Clearing up Old Received but Not Invoiced Purchase Orders in NAV

It is not uncommon to find clients who have posted Purchase Receipts but have not invoiced that receipt correctly. In order for Microsoft Dynamics NAV to accurately value inventory and Cost of Goods Sold, all Purchase Receipts must be invoiced. The question, then, is, “How do I clear out the old received but not invoiced… Continue reading Clearing up Old Received but Not Invoiced Purchase Orders in NAV

Published
Categorized as General

My Dynamics NAV Database is Huge! What is using up all that space?

“We’re gonna need a bigger boat.” Roy Scheider, “Jaws” Maybe a disk drive is starting to get full.  Maybe backups take too long to run.  Whatever the reason, sometimes it’s nice to know what is using up all of that database space.  There are two ways to figure out which tables are to blame –… Continue reading My Dynamics NAV Database is Huge! What is using up all that space?

Published
Categorized as General

How to Determine Who Has a Table Locked in Microsoft Dynamics NAV

I recently fielded a support call from a frantic customer that went something like this: “Help! Nobody can post anything! All we get is a message that Item Ledger Entry is locked by another user! AAAAAAHHH!!!” Very useful. The system knows enough to realize there is a block, but won’t bother to tell you which… Continue reading How to Determine Who Has a Table Locked in Microsoft Dynamics NAV