The Waterdeep Trading Company (WDTC) doesn’t just traffic in grain sacks and crossbow bolts. From spell-scrolls to silks, it handles a sprawling catalog of goods that straddle two very different economic planes: the mundane and the magical. And if there’s one thing Greta Ironfist has learned over the years, it’s this: you cannot value a crate of pickles the same way you value a Potion of Invisibility.
In this post, we explore how WDTC uses multi-ledger inventory valuation in Microsoft Dynamics 365 to accurately represent the true cost and value of its wildly diverse product lines.
The Problem: Two Economies, One Ledger?
Most trading companies operate within a single economic model. Standard costing methods like FIFO or Weighted Average are enough when you’re just shipping barrels of oil or bundles of lumber.
But for WDTC, the reality is more complex:
- Mundane goods like iron nails or flour operate on predictable market logic.
- Magical goods fluctuate based on arcane scarcity, planar trade politics, or adventuring trends.
Using a single valuation method across both types would either overstate the value of cheap goods or understate the risk in magical inventory.
The Solution: Valuation by Product Class in Dynamics 365
Using item model groups and inventory valuation methods, WDTC configured Dynamics 365 to assign different costing logic based on product category:
Example: Cloak vs Crate
Let’s break down two sales scenarios:
Cloak of the Emberward (Magical Item)
- Purchase Cost (initial): 250 gp
- Market spike after a regional fire elemental outbreak
- Revaluation: 300 gp
- Selling Price: 450 gp
- Costing Method: Moving Average
- Margin: 150 gp
Crate of Iron Nails (Mundane Item)
- Purchase Cost: 10 gp
- Stable demand across regions
- Selling Price: 15 gp
- Costing Method: FIFO
- Margin: 5 gp
This separation ensures that magical price volatility does not distort the margin reports of common products, and vice versa.
Why It Matters to WDTC
- Accurate financial reporting by product class
- Better guild compliance when reporting to trade unions and arcane oversight bodies
- Risk visibility for magical goods with erratic supply chains
- Profit segmentation that separates stable trade income from speculative arcane revenue
Regional Valuation Adjustments
Faerûn isn’t one economy. It’s dozens. Prices vary by city, faction, and even by time of year.
For instance, Elixir of Haste sells at:
- 200 gp in Waterdeep
- 300 gp in Icewind Dale
- 150 gp in Calimport
WDTC uses financial dimensions tied to region to track where margins are highest. This allows Greta to reroute magical inventory dynamically and ensure magical surplus in saturated markets is reallocated before losses hit the books.
Final Thoughts
Managing two economies under one roof is no easy task. But with the right inventory valuation configuration in Dynamics 365, the Waterdeep Trading Company turns complexity into clarity.
So next time you’re weighing whether to ship a box of rope or a case of scrolls, ask yourself: do you know what it’s really worth, and how it affects your ledger?
For more Faerûn-based business wisdom, get your copy of the guides at adnd365.com/start. You can also request access to our current demo database and see how it’s all set up. Just log in to https://public.adnd365.com using:
Email: npc@adnd365.com
Password: N0nPl@yC#822!
A Tinkerers Notebook 