We often get the question from clients using the Dynamics NAV Average Cost Method, “Why is there a dollar value when there is zero on hand in a location, but when I run the report for all locations combined, it has a correct value?” First, we should look at the Inventory Setup. We can see… Continue reading Why Does Inventory Valuation show Zero on Hand but has a Value?
How to Set Up Additional Currencies in Microsoft Dynamics NAV
Microsoft Dynamics NAV (Navision) allows management to view reports in a second currency in addition to the base currency. Many companies have divisions or sister companies in foreign countries. Those companies are quite likely to be required by local governments to use the local currency for G/L reporting. The parent company may wish to view… Continue reading How to Set Up Additional Currencies in Microsoft Dynamics NAV
Managing Inventory Periods in Microsoft Dynamics NAV
Inventory periods are used to manage posting of inventory adjusting entries. Adjusting entries will post in the period the original transaction unless inventory periods are closed on a monthly basis. Creating and closing inventory periods will prevent the inventory adjustments from posting in that period. If the posting date of the original transaction is in… Continue reading Managing Inventory Periods in Microsoft Dynamics NAV
Understanding Concurrent Capacities on Dynamics NAV Routing Lines
There is a field in the Dynamics NAV Routing Line named Concurrent Capacities. The question is, “What is it used for?” We hope to answer this question through the use of a practical example that will hopefully demonstrate its usefulness. We set up a simple example to illustrate the use of this field. Figure 1 –… Continue reading Understanding Concurrent Capacities on Dynamics NAV Routing Lines
Try This One Weird Old Trick to Write NAV Records!
I understand that this is a trick that “they” don’t want you to know about, and I’ve heard that it cuts down a bit of your belly fat each day. I’m not sure who “they” are, and I certainly haven’t noticed any reduction in my own belly fat, but that’s still what I’ve heard. Anyway,… Continue reading Try This One Weird Old Trick to Write NAV Records!
ArcherPoint Microsoft Dynamics NAV Developer Digest – vol 20
The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another. As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions… Continue reading ArcherPoint Microsoft Dynamics NAV Developer Digest – vol 20
Recording Reasons behind Discretionary Discounts
You’ve given your cashiers the ability to make discounts at the Point of Sale, you have also added limits to the amount of discounts they can give, it is now time to learn why a discount was given. Without clarity into why discounts are given, you will never understand the reasons behind your sales numbers.… Continue reading Recording Reasons behind Discretionary Discounts
Quick Reporting in Dynamics NAV Using Microsoft Excel Pivot Tables
Yesterday a client called and asked if there was a report in Dynamics NAV that listed inventory on hand and in which warehouse bins the inventory was located. We did not find a report for this, so we thought that if we could get to the Bin Contents Table, we could export the data to Excel and create a… Continue reading Quick Reporting in Dynamics NAV Using Microsoft Excel Pivot Tables
Winning Manufacturers: What Are They Doing That You Are Not? (Part 2)
In our last blog post, we addressed three prime examples of manufacturers who are winning the race by implementing some innovative automation and integration techniques. Here are three more from our eBook: Mobile Accessibility – As with many long-established companies, an auto parts manufacturer was getting by with an aging accounting solution, homegrown Materials Resource… Continue reading Winning Manufacturers: What Are They Doing That You Are Not? (Part 2)
How to Get Customer Data Without Being Intrusive
As retailers, Big Data helps drive decisions. We can better understand how many times a person comes to a store, what buying patterns to associate with our customers, which sales work, and so much more. By having access to consumer data, you open up a possibility to create lifetime customers that are loyal to your… Continue reading How to Get Customer Data Without Being Intrusive