In the bustling cities of the Sword Coast—from Waterdeep’s merchant squares to the shady alleys of Luskan—one thing is clear: magic sells. Whether you’re a potion purveyor, an arcane gear supplier, or an enchanted scroll distributor, knowing which magical products bring the highest margins is critical for growth.
In this post, we’re using Dynamics 365’s Product Profitability Reports, Item Sales Margins, and Sales by Product Category to reveal the top 10 most profitable magical items currently moving through the Faerûnian economy.
How We Calculated Profitability
We pulled data from the Waterdeep Trading Company’s Dynamics 365 environment, combining:
- Sales revenue from the Order to Cash module
- Cost of Goods Sold (COGS) via Inventory Valuation
- Gross Margin % based on item group (Magical Items, Potions, Scrolls, etc.)
Profit = (Sales – COGS) × Volume Sold
Top 10 Magical Products by Profit
Key Insights for Inventory & Trade Managers
- Healing Potions dominate—they’re cheap to produce, high in volume, and in constant demand. Set reorder thresholds in your Item Coverage settings.
- Arcane Saddles are low-volume, high-margin—ideal candidates for Trade Agreements with aerial suppliers and custom production runs.
- Scrolls offer recurring revenue—track parchment, ink, and scribing labor as bundled production cost drivers.
- Teleportation services represent a unique product-as-a-service model—handled as a non-stock item but linked to high-value invoicing and permit records.
Dynamics 365 Tips to Track Magical Profitability
- Use Item Groups and Product Categories to segment magical vs. mundane goods.
- Enable Standard Costing or FIFO for better margin clarity on alchemical and enchanted items.
- Run the “Gross Margin by Product” report in Cost Management > Inquiries and Reports.
- Tag products with attributes like Arcane Level, Guild Certification, or Spell School to enable dimensional profitability analysis.
What’s Next?
If you’re a trading company operating across Faerûn, your profit isn’t just about what you sell—it’s about knowing what sells best, to whom, and how consistently. With Dynamics 365, you have the tools to track product-level performance across every district, ward, and plane.
Curious what the margins are on a Flask of Faerie Fire or a Golem Core? Start building your magical profitability matrix today with our Bare Bones Templates and Fantasy Item Master demo packs at adnd365.com/start.
A Tinkerers Notebook 