Setup Inventory in D365 Business Central [Step-by-Step Guide]

Setting up inventory management in Microsoft Dynamics 365 Business Central is the foundation of a healthy supply chain. Without a proper configuration, your balance sheet will never align with your warehouse reality, leading to “ghost inventory” and financial discrepancies. This guide provides a practical, step-by-step framework to configure your system for maximum accuracy and efficiency. If you need hands-on assistance, Dynamics 365 consulting services can help tailor these configurations to your specific industry needs.

The Core Logic of Inventory in Business Central

Inventory management in Microsoft Dynamics 365 Business Central operates on the principle of Item Ledger Entries. Every time an item is bought, sold, adjusted, or moved, the system creates a ledger entry that tracks the quantity, value, and location. To get this right, you must define the global rules that govern these entries before you upload a single SKU.

The system relies on three primary pillars: Master Data (the Items), Locations (where they sit), and Posting Groups (how they talk to the General Ledger). According to Microsoft’s official documentation, accurate setup is critical for automated replenishment and cost control.

Step 1: Configuring the Inventory Setup Page

The Inventory Setup page is the control center for your global inventory policy. Search for “Inventory Setup” in the Business Central search bar to begin.

Key Fields to Configure:

• Automatic Cost Posting: Set this to Yes if you want the system to post inventory value changes to the General Ledger (GL) every time a transaction occurs. For high-volume businesses, setting this to No and running a batch job at the end of the day can improve system performance.
• Expected Cost Posting to G/L: Enable this to see the estimated value of received but not yet invoiced items on your balance sheet. This provides a more accurate view of your financial position during the month.
• Default Costing Method: While defined per item, you can set a global default (usually FIFO or Standard).
• Item Nos.: Define the number series for your items (e.g., ITEM-0001).

Step 2: Creating and Managing Item Cards

The Item Card is where you store the DNA of your product. In Microsoft Dynamics 365 Business Central, items are classified into three distinct types. Choosing the wrong type can break your reporting.

Table 1: Item Types in D365 Business Central

Item Type	Description	Typical Use Case
Inventory	Tracked by quantity and value. Impacts the balance sheet.	Raw materials, finished goods, components.
Non-Inventory	Not tracked by quantity, but costs are tracked.	Consumables like tape, labels, or office supplies.
Service	Tracked as labor or time units. No physical stock.	Consulting hours, installation fees, repairs.

When creating Item Cards, ensure you define Base Units of Measure. Note that Business Central allows for multiple units of measure (e.g., Buy in Pallet, Sell in Pieces), but the Base unit must be the smallest possible increment to avoid rounding errors.

Also Read: How to Evaluate an ERP Implementation Partner (2026 Guide)

Step 3: Selecting the Right Costing Method

Your costing method dictates how the system calculates the value of your inventory and the Cost of Goods Sold (COGS). This is a critical decision; changing it later requires complex adjustments or creating new items. Our about our team page highlights experts who specialize in these financial reconciliations if you find yourself stuck.

Comparison of Costing Methods:

1. FIFO (First-In, First-Out): The oldest items are sold first. This is standard for most retail and distribution businesses.
2. Standard: Uses a fixed, predetermined cost. Common in manufacturing to measure performance through variances.
3. Average: Calculates the weighted average cost of all units in stock. Ideal for commodities like fuel or grain.
4. Specific: Used for high-value items with serial numbers (e.g., cars, luxury watches) where the exact cost of a specific unit must be tracked.

Step 4: Linking Inventory to the General Ledger

This is where many setups fail. Inventory Posting Groups act as the bridge between your warehouse actions and your financial reports. Without these, you will have quantities in the system but no dollar value on your Profit & Loss statement.

You need to configure two main types of posting groups:

• Inventory Posting Groups: These represent the What (e.g., Finished Goods, Raw Materials, Resale).
• Inventory Posting Setup: This is a matrix where you map Location Codes and Inventory Posting Groups to specific GL Accounts.

Table 2: Inventory Posting Setup Example Matrix

Location Code	Invt. Posting Group	Inventory Account (Balance Sheet)
MAIN	RAW MAT	10100 – Raw Materials
MAIN	FINISHED	10200 – Finished Goods
REMOTE	RESALE	10300 – Goods for Resale

Also Read: How to Successfully Migrate from Dynamics GP to D365 Business Central

Step 5: Location and Bin Configuration

Where is your stock? If you have one warehouse, you need at least one Location Code. If you have a complex warehouse, you will need to enable Bin Mandatory settings.

For high-precision operations, consider enabling Directed Pick and Put-away. This allows Microsoft Dynamics 365 Business Central to suggest exactly where a worker should place an item based on its size or turnover rate. Implementing these advanced warehouse features can reduce picking errors by up to 15% and increase storage density.

Practical Inventory Setup Checklist

Use this checklist to ensure your environment is ready for go-live:

1. Inventory Setup: Are numbering series defined for Items, Transfers, and Adjustments?
2. Posting Groups: Are all Inventory Posting Groups mapped to valid GL accounts?
3. Units of Measure: Are Base Units of Measure standardized (e.g., all “EA” for Each)?
4. Costing: Have you confirmed the costing method with your accounting department?
5. Locations: Are all physical warehouses, service vans, or 3PLs created as Locations?
6. Categories: Are Item Categories set up for granular reporting?
7. Opening Balances: Have you prepared an Item Journal with quantities and unit costs for migration?

Frequently Asked Questions

1. Can I change the costing method after I start transacting?

No, you cannot change the costing method on an Item Card once there are ledger entries. To change it, you must clear the stock, block the item, and create a new item card with the correct method.

2. What is the difference between “Inventory” and “Non-Inventory” items?

Inventory items track physical quantity (e.g., “We have 10 chairs”). Non-inventory items track the purchase/sale cost but not the quantity on hand (e.g., “We spent $50 on cleaning supplies”).

3. Why doesn’t my inventory value match my General Ledger?

This usually happens if “Automatic Cost Posting” is turned off or if you have un-invoiced receipts. Run the Post Inventory Cost to G/L report to synchronize the values.

4. How do I handle item variants (e.g., different sizes or colors)?

Use Item Variants on a single Item Card instead of creating a new card for every color. This keeps your inventory clean and simplifies reporting.

5. What is the “Reordering Policy”?

This is a setting on the Item Card that tells Business Central how to suggest purchase orders. Options include Fixed Reorder Qty. (order when stock hits X) or Lot-for-Lot (order exactly what is needed for current demand).

Conclusion

Setting up inventory in Microsoft Dynamics 365 Business Central is more than just listing products; it is about building a data architecture that supports growth. By correctly configuring the Inventory Setup page, defining robust Posting Groups, and choosing the right costing methods, you ensure that your operations and finance teams are looking at a single version of the truth.

The next step after setup is mastering Replenishment and Planning to automate your purchasing cycles. If your current setup feels overwhelming or if you’re experiencing data discrepancies, engaging with Microsoft Dynamics 365 consulting services can provide the audit and corrective action needed to get back on track.