Dynamics 365 Field Service : Manually update inventory by using inventory journals

Managing inventory effectively is critical for Field Service organizations to ensure the right parts are available at the right time. Dynamics 365 Field Service offers Inventory Journals to manually adjust inventory quantities for warehouses, vans (Field Agent stock), and other locations.

This article provides a deep-dive into inventory journals, their technical structure, and step-by-step guidance on how to use them for manual updates.

What Are Inventory Journals in Dynamics 365 Field Service?

An inventory journal is a record of manual inventory adjustments. It allows technicians, warehouse managers, and back-office staff to:

•  Add or remove stock quantities.
•  Correct discrepancies (e.g., physical count mismatch).
•  Record transfer of stock between locations.
•  Track all changes for audit and compliance.

In Dynamics 365, inventory journals are stored as Inventory Adjustment (msdyn\_inventoryadjustment) entities and use Inventory Adjustment Product (msdyn\_inventoryadjustmentproduct) as child records.

How Inventory Journals Work Technically

Here’s how Dynamics 365 handles an inventory journal under the hood:

When you post an inventory journal:

•  The quantity adjustments update msdyn\_inventory (inventory levels).
•  Changes are reflected in work orders, ensuring accurate stock availability.
•  Audit trails are created in the system for tracking.

Common Scenarios for Manual Inventory Updates

Step-by-Step: Manually Update Inventory Using Journals

Step 1: Navigate to Inventory Adjustments

1. Go to Field Service > Inventory > Inventory Adjustments.

2. Click + New to create a new journal.

Step 2: Enter Header Information

•  Name – Enter a meaningful name (e.g., “Van Stock Correction – July 2025”).
•  Warehouse – Select the warehouse or location where stock is adjusted.
•  Owner – Defaults to the current user.
•  Adjustment Date – Defaults to today; you can backdate if needed.

Step 3: Add Products to Adjust

1. Under Related > Inventory Adjustment Products, click + Add New Inventory Adjustment Product.

2. Fill in the fields:

Step 4: Review and Post Journal

•  Review all line items for accuracy.
•  Click Post Adjustment.

This triggers:

• Update of inventory quantities in `msdyn_inventory`.
• Creation of audit records for traceability.

Key Considerations & Gotchas

✔ Stock Ownership

•  Dynamics 365 tracks stock ownership (e.g., Customer Owned, Company Owned). Ensure you pick the correct type.

✔ Warehouses & Bins

•  If you use bins within warehouses, the adjustment must specify the bin location.

✔ Async Inventory Updates

• Inventory recalculations post asynchronously. Allow some seconds/minutes before the changes reflect in Work Orders.

✔ Security Roles

• Users must have proper Field Service security roles (Inventory Manager or Dispatcher).

✔ Field Agent Scenarios

•  If using mobile app, agents can initiate adjustments directly in the field (online or offline).

Advanced: Automating Inventory Journals with Power Automate

Did you know you can automate repetitive inventory adjustments?

Example: Create a Power Automate flow to:

•  Trigger on physical count completion.
•  Create `msdyn_inventoryadjustment` records.
•  Post them automatically.

This is ideal for large organizations with regular stock reconciliations.

Why Use Inventory Journals Instead of Direct Edits?

Unlike direct edits to inventory, journals provide:

• Audit trail for compliance.
• Granular reasons for adjustments.
• Integration with Field Service workflows.
• Mobile and desktop support.

Final Thoughts

Manually updating inventory using journals in Dynamics 365 Field Service ensures accuracy and transparency in stock management. It’s an essential tool for organizations aiming for operational excellence and regulatory compliance.

By understanding both functional flow and technical design, you can empower your field agents, warehouse managers, and back-office staff to maintain clean and correct inventory records.