Manage inventory costs

Path: Business functionality > Finance > Manage inventory costs · tier official · system inventory · narrative reviewed (checked by Opus)

Overview

This section explains how Business Central records and reports the costs of inventory. It starts with the concepts: the costing methods (Standard, FIFO, LIFO, Specific, Average), how unit cost updates on purchases and sales, and how standard cost is built from material, capacity, subcontracting, and overhead. “Managing inventory costs” gives the overview, and “Design details - Inventory costing” goes deeper into item application, cost adjustment, expected cost posting, and valuation.

Other pages cover tasks. Item charges add freight, insurance, and customs duties to landed cost. The revaluation journal creates new value entries when inventory value changes. The Application Worksheet and the fixed application page help correct wrong cost flows. A page on tracking cost adjustments covers logging, batching, and troubleshooting. The subtopic covers reporting and reconciliation with the general ledger.

Start with “Managing inventory costs” and “About unit cost calculation” to learn the model. Then go to the task pages that match your problem, such as wrong costs, extra trade costs, or a revaluation.

Key points

• Costing methods covered: Standard, FIFO, LIFO, Specific, and Average, with how unit cost updates for purchases and sales.
• Standard cost is calculated from material, capacity, subcontracting, and manufacturing overhead, and applies to purchased, assembled, and produced items.
• Item charges assign freight, insurance, and customs duties to purchase or sales documents to compute landed cost and true profitability.
• The revaluation journal appreciates or depreciates inventory by creating new value entries.
• The Application Worksheet removes and reapplies item ledger entries to fix incorrect cost flows.
• Fixed applications apply only costs, not quantities; open entries from them are closed with the Item Journal.
• Cost adjustment tracking offers logging, item batches, a tracer, and diagnostics to find problematic items.
• The subtopic covers manual cost adjustment, posting costs to the G/L, restricting backdated postings, scheduling cost jobs, and inventory periods.

Subtopics

• Report inventory costs and reconcile with the general ledger (5 pages)

More Learn pages

• About calculating standard cost: A standard cost system determines inventory unit cost based on reasonable historical or expected cost.
• About unit cost calculation: Learn how the costing method and other factors influence the Unit Cost field on items.
• Close item ledger entries that came from using fixed application: Learn how you can create a fixed application between an inbound transaction and the original outbound transaction in the item journal.
• Create new value entries for items in the inventory| Microsoft Docs: Describes how to appreciate or depreciate the value entries of one or more items in inventory by posting their current, calculated value.
• Design details - Inventory costing: This documentation provides detailed technical insight to the concepts and principles that are used within the Inventory Costing features in Business Central.
• Managing inventory costs: Cost management is concerned with recording and reporting business operating costs and includes the reporting of manufacturing costs and inventory costs.
• Remove and reapply item entries: You can view and manually change certain item application entries that are created automatically during inventory transactions.
• Track item cost adjustments: Learn how tracking adjustments to item costs can help you keep your item cost data accurate.
• Use item charges to account for extra trade costs: Use item charges to assign costs such as freight, insurance, and duties to purchases (landed cost), or non-inventoriable costs on sales shipments.

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #10094 [Main]- Standard-cost purchase receipts use Direct Unit Cost instead of Standard Cost when cumulative expected-cost rounding is enabled (code change): “preventing inventory overstatement and ensuring purchase variance is properly recognized”
• #10220 [main] Calculate Inventory - Add check to skip report processing if Warehouse Entry table is empty (code change): “Calculate Inventory report now skips its per-iteration Warehouse Entry processing”
• #10298 [main]A WIP Balance is presented incorrectly on the “Production Order – WIP” Report 5802 after Finishing Production Order Without Output Item Ledger Entry posted with new Manufacturing Setup option for no Output required. (code change): “WIP Balance is presented incorrectly on the Production Order – WIP”
• #11309 [29.X]-Post Inventory Cost to G/L fails when concatenated dimension text exceeds 250 characters (code change): “Post Inventory Cost to G/L’ report now handles dimension text longer than 250”
• #11906 [Main]-Incident 51000001968459: Issue while creating any import purchase invoice (code change): “Custom Duty is now included in inventory cost for import invoices”
• #9005 (Bug 641089) Guard Item Ledger/Value Entry No. allocation in Item Jnl.-Post Line with CommitBehavior::Ignore (code change): “Item journal posting now prevents duplicate-key errors in concurrent scenarios”
• #9118 Bugs/master GitHub event batch 1745 (code change): “Item Jnl.-Post Line changed in W1, APAC, CH, ES, IT and RU”
• #9212 Bug 629779: [Inventory] Show a single Export/Import item data action pair on Cost Adjustment and Item Card (code change): “Cost Adjustment and Item Card pages now show a single”
• #9467 [Extensibility Request] issue 30346: make InsertPostValueEntryToGL public in Item Jnl.-Post Line (code change): “reuse the standard General Ledger posting logic for inventory variances”
• #9531 [Master]- Report 152 “Calculate Low Level Code” terminates with error: “Cannot add instance as another with key %1 has already been added.” after upgrade to v28.1 (code change): “Report 152 “Calculate Low Level Code” terminates with error”
• Dynamics 365 Business Central – Some Considerations when Changing Standard Cost on an Item Card (community post): “Changing standard cost directly on an item card has two critical side effects”
• What’s New: Cost Adjustment (2025 release wave 1) (video): “cost adjustment; inventory valuation; high-volume items”
• What’s New: Cost Adjustment (2024 release wave 1) (video): “Inventory Cost Adjustment Tool; Cost Adjustment Logging Options; Item Batches”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 40 “Item Journal” · captioned “Item Journals” · on Table 83 “Item Journal Line”
• Page 506 “Item Application Entries” · on Table 339 “Item Application Entry”
• Page 521 “Application Worksheet” · on Table 32 “Item Ledger Entry”
• Page 5709 “Get Receipt Lines” · on Table 121 “Purch. Rcpt. Line”
• Page 5800 “Item Charges” · on Table 5800 “Item Charge”
• Page 5805 “Item Charge Assignment (Purch)” · on Table 5805 “Item Charge Assignment (Purch)”
• Page 5814 “Item Charge Assignment (Sales)” · on Table 5809 “Item Charge Assignment (Sales)”
• Page 5841 “Standard Cost Worksheet” · on Table 5841 “Standard Cost Worksheet”
• Page 8645 “Costing Method Configuration” · on Table 313 “Inventory Setup”
• Page 9125 “Item Application FactBox” · captioned “Item Application” · on Table 32 “Item Ledger Entry”
• Page 461 “Inventory Setup” · on Table 313 “Inventory Setup” · via Report inventory costs and reconcile with the general ledger
• Page 5828 “Inventory Periods” · on Table 5814 “Inventory Period” · via Report inventory costs and reconcile with the general ledger
• Page 9297 “Inventory - G/L Recon Matrix” · captioned “Inventory - G/L Reconciliation” · on Table 367 “Dimension Code Buffer” · via Report inventory costs and reconcile with the general ledger

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.