Skip to main content
Indi Vision Microsoft Partner (CSP)

100% stock accuracy across bags, kilograms and coffee lots in Dynamics 365

3 units bag, net kg and import lot tracked for every coffee position
100% stock accuracy across bag counts, kilograms and lot numbers
0 double entry between sales pipeline and warehouse stock
Outcome100% stock accuracy across bags, net kilograms and import lots
StackMicrosoft Dynamics 365 Field Service, Dynamics 365 Sales, Microsoft Dataverse
DeliveryExtension of the native Field Service inventory engine, no custom ERP build
SecuritySales and warehouse data inside one Microsoft Dataverse perimeter
Read as:

Lots reserved inside the quote, so micro-lots are not oversold

Managers see free stock per lot in bags and kilograms while building a Dynamics 365 quote and reserve it for the client on the spot.

  • Reservation tied to a specific origin lot, not a generic coffee item
  • Whole-bag and kilogram orders quoted from the same lot balance
  • Free-to-sell stock across warehouses visible in real time
Challenge

Green coffee arrives in bags of 60, 69 or 70 kg depending on origin, while roasters order whole bags or kilograms from one harvest lot. Standard CRM catalogs could not hold bags, net kilograms and lots at once, so stock was recalculated by hand.

Architecture Dynamics 365 Field Service, Dynamics 365 Sales

Instead of a custom ERP, the native inventory engine of Dynamics 365 Field Service was extended with multi-unit conversion rules, lot reservation inside the sales quote and automatic bag unpacking for fractional orders.

Verified Outcome 3 units, 100%

100% stock accuracy across bags, kilograms and lots in Dataverse; sales reserves lots in real time and confirms B2B orders with 0 double entry.

Architecture & Implementation Details

Warehouse and lot accounting in bags, kilograms and import lots on Microsoft Dynamics 365 Field Service

CoffeeMaxGreen is a Ukrainian importer and B2B distributor of green coffee. It buys from European coffee traders and origin producers in Latin America, Africa and Asia, and supplies Ukrainian roasters and HoReCa partners.

Before: one bag, three units, manual recalculation

Green coffee has no fixed packaging. It arrives in jute and GrainPro bags whose standard weight depends on the country of origin (for example 60, 69 or 70 kg). Customers order whole bags, or a few kilograms from one harvest lot as a sample. Standard CRM catalogs could not hold stock in bags, net kilograms and origin lots at the same time, so balances were recalculated by hand and errors reached the warehouse.

Architecture decision

Building a custom ERP from scratch was ruled out. Instead, Indi Vision extended the native warehouse and inventory engine of Microsoft Dynamics 365 Field Service:

  • Three linked units per item: every green coffee position is held in physical bags, exact net kilograms and its import lot;
  • Lot reservation in the quote: a sales manager reserves coffee from a specific origin lot inside the Dynamics 365 quote, so rare specialty micro-lots cannot be oversold;
  • Fractional unpacking: when a full bag is opened for a small order or sample roasting, bag and kilogram balances are adjusted automatically;
  • Sales and warehouse on the same data: the commercial team sees free-to-sell stock across warehouses in real time.

Results

  • 100% accuracy across bag counts, net kilogram balances and batch numbers in one Microsoft Dataverse contour.
  • Faster order confirmation and dispatch for Ukrainian roasters and HoReCa partners.
  • No double entry between the sales pipeline and physical warehouse stock.
  • Each lot is traceable from the contract with the European trader to the final B2B buyer.

Tailor Dynamics 365 Field Service & Warehouse Logic to Your Distribution Model

Explore how our Dynamics 365 Field Service and CRM Development practices adapt Microsoft Cloud to industry-specific inventory rules.

ARCHITECTURE & PILOT REQUEST · RESPONSE WITHIN 1 BUSINESS HOUR

Request a 10-Day Data Pilot or Architecture Review

Book a 30-Min Slot via Microsoft Bookings