18.2 Inventory Adjustments, Transfers & Physical Counting

18.2 Inventory Adjustments, Transfers & Physical Counting

Quick Summary: In Microsoft Dynamics 365 Business Central, maintaining physical stock accuracy and precise cost accounting requires mastering five core operational mechanisms. Manual stock changes are posted through the Item Journal (Positive vs. Negative Adjustments), while internal moves and metadata corrections that leave total stock unchanged are handled via the Item Reclassification Journal. Multi-facility logistics spanning transit lead times are governed by Transfer Orders utilizing dedicated In-Transit Locations. Periodic stocktaking is performed via either the traditional Physical Inventory Journal or enterprise Physical Inventory Orders and Recordings. Where an adjustment needs an auditable, printable document instead of a journal line, the Inventory Receipt and Inventory Shipment documents cover intake and write-off respectively. Finally, cost integrity is maintained using the Adjust Cost - Item Entries engine prior to closing Inventory Periods.

---

Inventory Adjustments via Item Journals: Receipts & Shipments

Physical inventory in a warehouse inevitably deviates from recorded balances due to receiving variances, damage, pilferage, quality testing, or unrecorded customer sampling. Business Central utilizes the Item Journal (Alt+Q -> type Item Journals, Page 40 / Table 83) to record manual physical stock movements.

Item Journal Positive vs. Negative Adjustment Posting Flow:

[Positive Adjustment: Stock Found / Opening Load]
   ├── Table 32 Item Ledger Entry: Positive Qty, Open = Yes
   ├── Table 5802 Value Entry: Cost Amount (Actual) = Unit Cost x Qty
   └── General Ledger Posting:
         Debit:  Inventory Account (Balance Sheet Asset)
         Credit: Inventory Adjustment Account (P&L Expense / Variance)

[Negative Adjustment: Damaged Stock / Scrap / Shrinkage]
   ├── Table 32 Item Ledger Entry: Negative Qty, Closes Inbound Cost Layer
   ├── Table 5802 Value Entry: Relieves Cost based on Item Costing Method
   └── General Ledger Posting:
         Debit:  Inventory Adjustment Account (P&L Shrinkage / Expense)
         Credit: Inventory Account (Balance Sheet Asset)

Operational Entry Types on the Item Journal

• Positive Adjmt.: Records unbudgeted inventory additions (e.g., found inventory, initial stock loads, vendor bonus items). Increases physical on-hand quantity in Table 32 and establishes initial unit cost in Table 5802.
• Negative Adjmt.: Records physical stock reductions (e.g., scrap, obsolescence, spoilage, shrinkage). Decreases physical on-hand quantity and relieves inventory value based on the item's configured costing method (FIFO, LIFO, Specific, Average, Standard).

Reason Codes & Dimension Tracking

• Reason Codes (Page 259): Functional consultants should configure mandatory or default Reason Code values (e.g., SPOILAGE, DAMAGED, FOUND, SAMPLE) on adjustment lines to provide an audit trail of why adjustments occurred.
• Dimension Assignment: Attaching Department, Cost Center, or Project dimensions ensures that shrinkage or gain adjustments flow directly into the responsible business unit's income statement.

---

Inventory Receipt & Inventory Shipment Documents

The Item Journal is fast, but it is a journal: there is no document status, no header-level dimension defaulting, no paperwork to print, and nothing to reprint once it is posted. When an adjustment needs an auditable document trail — go-live stock loading, a quality-hold write-off, an insurance claim for damaged goods — Business Central provides two dedicated inventory documents.

• Inventory Receipt (Alt+Q -> type Inventory Receipts, the Invt. Receipt page) registers positive adjustments of items based on quality, quantity, and cost. Microsoft's own guidance names it the tool for preparing to go live or adding open balances.
• Inventory Shipment (Alt+Q -> type Inventory Shipments, the Invt. Shipment page) writes off missing or damaged goods.

Mandatory Prerequisite: Number Series in Inventory Setup

Neither document can be created until an administrator assigns number series on the Numbering FastTab of Inventory Setup (Page 461). Four separate fields are required:

This is the usual reason an implementation reports that inventory documents "are missing": the pages are present, but creating a new record fails because the series is blank.

Document Structure & Available Actions

In the header of the Invt. Receipt or Invt. Shipment page, the consultant chooses the Location Code and assigns common values — including dimensions — once, at header level. On the Lines FastTab, the Item field selects the inventory item and the Quantity field carries the number of units to add or write off.

Once posted, the documents are archived on the Posted Inventory Receipt and Posted Inventory Shipment pages, from which they can be reprinted.

Wiring the Print Layouts

Which report prints at each stage is controlled on the Report Selection - Inventory page, which exposes four Usage options: Inventory Receipt, Inventory Shipment, Posted Inventory Receipt, and Posted Inventory Shipment. This is the same Report Selection pattern taught in Section 3.2, with one exam-relevant twist: the base application ships no layouts for these usages, and the reports that are available vary by country/region localization. A consultant who promises printable receipt paperwork out of the box on a W1 deployment will find the Usage line empty.

Choosing Between the Journal and the Document

---

The Item Reclassification Journal: Relocation & Metadata Updates

Unlike standard Item Journals, the Item Reclassification Journal (Alt+Q -> type Item Reclassification Journals, Page 393 / Table 83 with Template Type = Reclass) modifies inventory parameters without altering overall physical quantities or financial balance sheet valuations.

Item Reclassification Journal Mechanics:

[Item Reclassification Journal Line: Item 1000, Qty = 50]
  ├── Source Parameters: Location = BLUE, Bin = B-01, Lot No. = LOT-A
  └── Target Parameters: New Location = BLUE, New Bin = B-08, New Lot No. = LOT-B
                │
                ▼ Post Document (F9)
       ┌────────┴────────┐
       ▼                 ▼
[Negative Item Ledger Entry]   [Positive Item Ledger Entry]
- Qty = -50                    - Qty = +50
- Location = BLUE, Bin = B-01   - Location = BLUE, Bin = B-08
- Lot No. = LOT-A              - Lot No. = LOT-B

NET RESULT: Physical Quantity Delta = 0 | General Ledger Dollar Impact = $0

Core Operational Use Cases

• Direct Location Relocation: Moving inventory between physical locations in a single step where transit time is zero (e.g., moving goods from a central warehouse floor to an onsite factory assembly staging area).
• Bin Relocations: Moving stock from one bin to another within basic warehouse locations where directed put-away and pick is not activated.
• Item Tracking Reclassification: Modifying, correcting, or assigning Serial Numbers, Lot Numbers, or Expiration Dates via the Item Tracking Lines window without re-receiving goods.
• Dimension Reclassification: Updating Department or Project dimensions associated with specific inventory batches.

---

Transfer Orders: Multi-Step Logistics Across In-Transit Locations

When inventory moves between geographically separated facilities (e.g., from a central distribution center in Chicago to a regional warehouse in Atlanta), transit lead times are significant, commercial carriers are hired, and shipping manifests are required. For these scenarios, Business Central provides Transfer Orders (Alt+Q -> type Transfer Orders, Page 5740 / Tables 5740 & 5741).

Two-Stage Transfer Order Execution Architecture:

[Transfer Order: From Location "EAST" -> In-Transit "ON-TRUCK" -> To Location "WEST"]
                       │
                       ▼ Post Shipment (F9 -> "Ship")
       ┌───────────────┴───────────────┐
       ▼                               ▼
[Posted Transfer Shipment (Page 5742)]  [Item Ledger Entry Updates]
- Decreases stock at EAST location     - Outbound Entry: EAST (Qty = -100)
- Increases stock at ON-TRUCK location - Inbound Entry: ON-TRUCK (Qty = +100)
- Line: Quantity Shipped = 100         - Legal Ownership Retained on Balance Sheet
- Line: Quantity Received = 0
                       │
                       ▼ Goods Travel (Shipping Time Formula: 3D)
                       │
                       ▼ Post Receipt (F9 -> "Receive")
       ┌───────────────┴───────────────┐
       ▼                               ▼
[Posted Transfer Receipt (Page 5743)]   [Item Ledger Entry Updates]
- Decreases stock at ON-TRUCK location - Outbound Entry: ON-TRUCK (Qty = -100)
- Increases stock at WEST location     - Inbound Entry: WEST (Qty = +100)
- Order Fully Received & Closed        - Stock Ready for Demand at Destination

Transfer Order Architecture & Configuration

• Transfer-from Code: The origin shipping facility.
• Transfer-to Code: The destination receiving facility.
• In-Transit Code: A specialized virtual location where the Use As In-Transit toggle is set to Yes on the Location Card (Page 5703). In-transit locations cannot have bins or physical warehouse handling; they represent stock legally owned by the business that is currently aboard trucks, trains, or container vessels.
• Transfer Routes (Page 5742): Defines the default logistics parameters between specific From/To location pairs, including the default In-Transit Code, Shipping Agent Code, Shipping Agent Service Code, and calendar-based Shipping Time formulas (e.g., 3D).

The Two-Stage Transfer Posting Flow

1. Post Shipment (F9 -> Ship): Decreases inventory at the origin warehouse, increases inventory at the virtual in-transit location, generates a Posted Transfer Shipment, and updates line Quantity Shipped. The corporate balance sheet maintains full asset ownership.
2. Post Receipt (F9 -> Receive): Decreases inventory at the in-transit location, increases inventory at the destination warehouse, generates a Posted Transfer Receipt, and marks the order complete.

---

Inventory Counting: Physical Inventory Journal vs. Physical Inventory Orders

Accurate financial statements require regular verification of physical stock against ledger balances. Business Central offers two distinct counting methodologies:

Methodology 1: Physical Inventory Journal (Page 392)

Ideal for standard, single-user stocktaking procedures:

1. Calculate Inventory: The user executes the Calculate Inventory batch job (Report 722). Business Central scans Item Ledger Entries and populates the journal with theoretical stock in the Qty. (Calculated) field as of a specified posting date.
2. Perform Count: Warehouse personnel count items and enter observed quantities into Qty. (Phys. Inventory).
3. Calculate Variances: The system computes the variance: $\text{Quantity} = \text{Qty. (Phys. Inventory)} - \text{Qty. (Calculated)}$. If actual > theoretical, Business Central sets Entry Type to Positive Adjmt.; if actual < theoretical, it sets Entry Type to Negative Adjmt.
4. Post: Posting updates Item Ledger Entries to align theoretical stock with physical reality.

Methodology 2: Physical Inventory Orders & Recordings (Pages 5875 & 5879)

Designed for enterprise warehouse environments requiring structured multi-person counting, blind count sheets, and strict segregation of duties:

• Physical Inventory Order (Page 5875): The master planning document created by the inventory manager. Lines are calculated using location and item filters.
• Document Locking: Setting Lock = Yes on the order header freezes all inventory transactions (picks, receipts, adjustments, shipments) for the included items and locations, preventing data corruption during the physical count.
• Physical Inventory Recordings (Page 5879): The manager creates one or more child recording sheets from the order. Recordings can be assigned to different warehouse workers and printed as blind counting sheets (omitting theoretical quantities to ensure unbiased counting).
• Recording Completion: Count crews enter observed quantities and click Finish. Multiple recordings can be consolidated into the master order.
• Order Finalization & Posting: The inventory manager reviews variances between calculated and recorded quantities. Once verified, the manager clicks Finish on the order and posts it, generating corrective ledger entries.

---

Cost Adjustment & Inventory Closing Procedures

The Dynamic Costing Engine & Adjust Cost - Item Entries

In modern supply chains, inbound purchase invoices or freight landed costs often arrive weeks after goods have been received, consumed, or sold. The Adjust Cost - Item Entries batch job (Report 795 / Codeunit 5895) detects cost discrepancies on inbound entries and ripples those adjustments forward through the application chains into outbound entries (sales shipments, transfer shipments, assembly consumption).

Cost Adjustment Forward Rippling Engine:

[Jan 5: Receive 100 units @ Expected Cost $10.00]
   ├── Value Entry: Expected Cost $1,000
   │
   ▼ (Jan 10: Sell 100 units on Sales Order)
[Jan 10: Post Sales Shipment & Invoice: COGS recognized @ $10.00 = $1,000]
   │
   ▼ (Jan 25: Vendor Invoice Arrives with Price Increase: Actual Cost = $12.00]
[Jan 25: Post Purchase Invoice: Value Entry Actual Cost Variance = +$200]
   │
   ▼ Run "Adjust Cost - Item Entries" (Report 795)
[Automated Adjustment Value Entry Generated]
   ├── Outbound Sales Entry Adjusted: Additional COGS = +$200
   └── Updates General Ledger via Post Inventory Cost to G/L (Report 1002)

Inventory Setup Governance

• Automatic Cost Adjustment: Configurable on Inventory Setup (Page 461) as Never, Day, Week, Month, Quarter, Year, or Always. In high-transaction distribution warehouses, setting this to Always can cause database deadlocks during peak picking hours; setting it to Day and executing Report 795 via a nightly Job Queue is the recommended best practice.
• Automatic Cost Posting: When enabled, value entries immediately post to the General Ledger. If disabled, the accountant must periodically run Post Inventory Cost to G/L (Report 1002).

Closing Inventory Periods

Inventory Periods (Alt+Q -> type Inventory Periods, Page 5828) enforce financial cutoffs. Selecting Close Period verifies that all item costs have been adjusted up to the period end. If unadjusted entries exist, the system blocks closure. Once closed, users cannot post any inventory transactions on or before the period ending date.

---

Operational Inventory Documents Comparison

---

Step-by-Step UI Execution Workflows

Workflow A: Performing Stock Count using Physical Inventory Journal

1. Press Alt+Q, type Physical Inventory Journals, and select the related link (Page 392).
2. In the action bar, click Prepare -> Calculate Inventory (Report 722).
3. In the request page, enter the Posting Date (e.g., 01/31/2026) and Document No. (e.g., COUNT-01).
4. Set item or location filters if counting specific zones. Ensure Items Not on Inventory is checked if you wish to verify zero-stock items. Click OK.
5. Print count sheets by selecting Post/Print -> Print (Report 701).
6. Warehouse staff count physical stock. Enter the counted values into the Qty. (Phys. Inventory) column on each line.
7. Verify that the Quantity field calculates the difference and automatically sets Entry Type to Positive Adjmt. or Negative Adjmt.
8. Click Post/Print -> Post (F9) to commit the count variances.

Workflow B: Executing a Two-Step Transfer Order Across Locations

1. Press Alt+Q, type Transfer Orders, and click New (Page 5740).
2. Set Transfer-from Code to EAST, Transfer-to Code to WEST, and verify the In-Transit Code populates with ON-TRUCK.
3. On the Lines FastTab, add Item 1000, Quantity = 50.
4. In the action bar, click Posting -> Post (F9), choose Ship, and click OK.
5. Verify that 50 units depart EAST and are now located in ON-TRUCK.
6. When the delivery truck arrives at the destination facility, open the Transfer Order, click Posting -> Post (F9), choose Receive, and click OK.
7. Verify the order closes and inventory is available in location WEST.

---

Common Configuration Pitfalls & Exam Traps

• Pitfall 1: Entering Total Counted Stock in Item Journal Quantity Field. In a standard Item Journal, the Quantity field represents the adjustment delta, not the final count. Entering total stock on hand into an Item Journal will severely distort inventory balances; users must use the Physical Inventory Journal to calculate variances automatically.
• Pitfall 2: Moving Stock Between Locations via Item Journals. Using negative adjustments at one location and positive adjustments at another breaks item cost tracking, distorts sales/cogs history, and prevents in-transit visibility. Transfers must use Transfer Orders or Item Reclassification Journals.
• Pitfall 3: In-Transit Location Lacking the In-Transit Toggle. If an administrator creates a transfer route using a standard warehouse location that does not have Use As In-Transit checked on the Location Card, Business Central blocks the transfer order posting.
• Pitfall 4: Closing Inventory Periods Without Running Cost Adjustment. Attempting to close an Inventory Period while unadjusted Value Entries remain will trigger system warnings and distort Cost of Goods Sold; Adjust Cost - Item Entries must always precede inventory period closure.
• Pitfall 5: Inventory Documents Without a Number Series. The Inventory Receipt and Inventory Shipment pages always exist, but a new document cannot be created until Invt. Receipt Nos., Posted Invt. Receipt Nos., Invt. Shipment Nos., and Posted Invt. Shipment Nos. are filled in on the Numbering FastTab of Inventory Setup. Equally, do not promise printed receipt paperwork on a W1 deployment: the base application includes no layouts for the four Report Selection - Inventory usages.