(For more resources related to this topic, see here.)
Master data is all the key information to the operation of a business. Third-party companies, such as customers and vendors, are part of the master data. The items a company manufactures or sells are also part of the master data.
Many other things can be considered master data, such as the warehouses or locations, the resources, or the employees.
The first thing you have to do when you start using Dynamics NAV is load your master data into the system. Later on, you will keep growing your master data by adding new customers, for instance. To do so, you need to know which kind of information you have to provide.
We will open a customer card to see which kind of information is stored in Dynamics NAV about customers. To open a customer card, follow these steps:
- Navigate to Departments/Sales & Marketing/Sales/Customers.
- You will see a list of customers, find No. 10000 The Cannon Group PLC.
- Double-click on it to open its card, or select it and click on the View icon found on the Home tab of the ribbon.
The following screenshot shows the customer card for The Cannon Group PLC:
Customers are always referred to by their No., which is a code that identifies them. We can also provide the following information:
- Name, Address, and Contact information. A Search Name can also be provided if you refer to your customer by its commercial name rather than by its fiscal name.
- Invoicing information: It includes posting groups, price and discount rates, and so on. You may still not know what a posting group is, since this is the first time those words are mentioned in this article. At this moment, we can only tell you that posting groups are important. But it’s not time to go through them yet.
- Payments information: It includes when and how will we receive payments from the customer.
- Shipping information: It explains how do we ship items to the customer.
Besides the information you see on the card, there is much other information we can introduce about customers. Take a look at the Navigate tab found on the ribbon.
Other information that can be entered is as follows:
- Information about bank accounts so that we can know where can we request the payments. Multiple bank accounts can be set up for each customer.
- Credit card information, in case customers pay using this procedure.
- Prepayment information, in case you require your customers to pay in advance, either totally or partially.
- Additional addresses where goods can be shipped (Ship-to Addresses).
- Contacts: You may deal with different departments or individuals from your customers.
- Relation between our items and the customer’s items (Cross References).
But customers, just as any other master data record, do not only have information that users inform manually. They have a bunch of other information that is filled in automatically by the system as actions are performed:
- History: You can see it on the right side of the card and it holds information such as how many quotes or orders are currently being processed or how many invoices and credit memos have been issued.
- Entries: You can access the ledger entries of a customer through the Navigate tab. They hold the details of every single monetary transaction done (invoices, credit memos, payments, and so on).
- Statistics: You can see them on the right side and they hold monetary information such as the amount in orders or what is the amount of goods or services that have been shipped but not yet invoiced.
- The Balance: This is a sum of all invoices issued to the customer minus all payments received from the customer.
Not all the information we have seen on the customer card is mandatory. Actually, the only information that is required if you want to create a transaction is to give it a No. (its identification) and to fill in the posting group’s fields (Gen. Bus. Posting Group and Customer Posting Group). All other information can be understood as default information and setup that will be used in transactions so that you don’t have to write it down every single time. You don’t want to write the customer’s address in every single order or invoice, do you?
Let’s take a look now at an item card to see which kind of information is stored in Dynamics NAV about items. To open an item card, follow these steps:
- Navigate to Departments/Sales & Marketing/Inventory & Pricing/Items.
- You will see a list of items, find item 1000 Bicycle.
- Double-click on it to open its card.
The following screenshot shows the item card for item 1000 Bicycle:
As you can see in the screenshot, items first have a No., which is a code that identifies them. For an item, we can enter the following information:
- Description: It’s the item’s description. A Search Description can also be provided if you better identify an item using a different name.
- Base Unit of Measure: This is the unit of measure in which most quantities and other information such as Unit Cost or Unit Price for the item will be expressed. We will see later that other units of measure can be used as well, but the Base is the most important one and should be the smallest measure in which the item can be referred.
- Classification: Item Category Code and Product Group Code fields offer a hierarchical classification to group items. The classification can fill in the invoicing information we will see in the next point.
- Invoicing information: This includes posting groups, costing method used for the item, and so on.
- Pricing information: This is the item’s unit price and other pricing configuration.
- Foreign trade information: This is needed if you have to do Instrastat reporting.
- Replenishment, planning, item tracking, and warehouse information: These fast-tabs are not explained in detail because they are out of the scope of this article. They are used to determine how to store the stock and how to replenish it.
Besides the information you see on the item card, there is much other information we can introduce about items through the Navigate tab found on the ribbon.
As you can see, other information that can be entered is as follows:
- Units of Measure: These is useful when you can sell your item either in units, boxes, or other units of measure at the same time.
- Variants: These is useful when you have multiple items that are actually the same one (thus, they share most of the information) but with some slight differences. You can use variants to differentiate colors, sizes, or any other small difference you can think of.
- Extended Texts: These is useful when you need long descriptions or technical info to be shown on documents.
- Translations: These is used so that you can show an item’s descriptions in other languages, depending on the language used by your customers.
As with customers, not all the information in the item card is mandatory.
Vendors, resources, and locations
We will start with third-parties: customers and vendors. They work exactly the same way. We will just look at customers, but everything we will explain about them can be applied to vendors as well. Then, we will look at items, and finally we will take a brief look at locations and resources.
You can apply to vendors the same concepts learned with customers, as they work exactly the same way. You can also apply to resources the concepts learned with items.
We have seen in detail how customers and items work as master data. You can apply the same concepts to other master data. For instance, vendors work exactly the same way as customers. The concepts learned can be used in resources and locations, and also to other master data such as G/L accounts, Fixed Assets, Employees, Service Items, and so on.
This article provides a brief introduction on master data. Also, we can add new customers, items, vendors, resources, and location into the master data when working with Microsoft Dynamics NAV.
Resources for Article:
- Microsoft Dynamics NAV: Customizing Relationship Management [Article]
- Microsoft Dynamics NAV 2009: Creating a Matrix Form [Article]
- Microsoft Dynamics NAV 2009: Designing Forms [Article]