Manage inventory
For each physical product you trade in, you must create an item card of the Inventory type. Items you offer to customers but don't keep in inventory you can register as catalogue items, which you can convert to inventory items when necessary. You can increase or decrease the quantity of an item in inventory by posting directly to the item ledger entries, such as after a physical count or if you don't record purchases.
Inventory increases and decreases are naturally also recorded when you post purchase and sales documents, respectively. To learn more, go to Record Purchases, Sell Products, and Invoice Sales. Transfers between locations change inventory quantities across your company's warehouses.
To enhance your overview of items and to help you find them, you can categorise items and give them attributes to search and sort by.
Note
The physical handling of items is referred to as warehouse activities. Learn more at Warehouse Management Overview.
Planning for items to fulfil demand is covered as part of supply planning functionality. Learn more at Planning.
Inventory analytics
This section describes the analytical tools you can use to get insights into your inventory data.
To... | Go to... |
---|---|
Get an overview of capabilities for analysing inventory data. | Sales analytics overview |
Analyse and monitor your inventory KPIs with the Power BI Inventory apps. | Power BI Inventory app Power BI Inventory Valuation app |
Do ad-hoc analysis of inventory data directly on list pages and queries. | Ad-hoc analysis of inventory data |
Explore built-in inventory reports. | Built-in inventory and warehouse reports |
Inventory reconciliation
When you post inventory transactions, such as sales shipments, purchase invoices, or inventory adjustments, the changed item costs are recorded in item value entries. To reflect this change in inventory value in your financial books, the inventory costs are automatically posted to the related inventory accounts in the general ledger. For each inventory transaction you post, the appropriate values are posted to the inventory account, adjustment account, and COGS account in the general ledger. To learn more, go to Reconcile Inventory Costs with the General Ledger.
Even though inventory costs are automatically posted to the general ledger, it's still necessary to ensure that the costs of goods are forwarded to the related outbound sales transaction, especially in situations where you sell goods before you invoice the purchase of those goods. This is referred to as cost adjustment. Item costs are automatically adjusted when you post item transactions, but you can also adjust item costs manually. To learn more, go to Adjust Item Costs.
Related tasks
The following table outlines related tasks.
To... | Go to... |
---|---|
Create item cards for inventory items that you trade in. | Register New Items |
Structure parent items you sell as kits consisting of the parent's components or that you assemble to order or to stock. | Work with Bills of Material |
Maintain an overview of items and help you find and sort items by organising them in categories. | Categorise Items |
Assign item attributes of different value types to your items to help you sort and find items. | Work with Item Attributes |
Create special item cards for items you offer to customers but don't maintain in inventory. | Work with Catalogue Items |
Perform physical counting of your inventory with the Physical Inventory Order and Physical Inventory Recording pages. | Count Inventory Using Documents |
Perform physical counting, make negative or positive adjustments, and change information, such as location or lot number, on item ledger entries. | Count, Adjust, and Reclassify Inventory Using Journals |
View the availability of items per location, by period, by sales or purchase event, or by their use on assembly or production bills of material (BOMs). | View the Availability of Items |
Transfer inventory items between locations using transfer orders, to manage warehouse activities, or with the item reclassification journal. | Transfer Inventory Between Locations |
Reserve inventory or inbound items for sales orders, purchase orders, service orders, assembly orders, transfer orders, or production orders. | Reserve Items |
Set up item tracking so you can track item serial numbers, such as when you need to track items because of recalls. | Set Up Item Tracking with Serial, Lot, and Package Numbers |
Assign serial numbers or lot numbers to any outbound or inbound document or journal line. | Work with Serial and Lot Numbers |
Find where any serial or lot number was used in its supply chain, such as in recall situations. | Trace Item-Tracked Items |
Set up a vendor's or customer's own item description on your item card so you can quickly insert their item description on trade documents. | Use Item References |
Block items from being entered on sales or purchase lines or from being posted in any transaction. | Block Items |
Manage business operations in sales offices, purchasing departments, or plant planning offices across multiple locations. | Work with Responsibility Centres |
See also
Warehouse Management Overview
Purchasing
Sales
Managing Inventory Costs
Work with Business Central
General Business Functionality