100% stock accuracy across bags, kilograms and coffee lots in Dynamics 365
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
Bags, kilograms and lots reconcile without manual recalculation
Balances stay correct when a 60, 69 or 70 kg bag is opened for a fractional order or sample roasting.
- Opening a bag writes off the bag and posts the kilogram remainder automatically
- Each lot traceable from the trader contract to the B2B buyer
- Faster order picking and dispatch for roasters and HoReCa
Native Field Service inventory extended instead of a custom ERP
Multi-unit conversion rules run on the standard Dynamics 365 Field Service inventory engine, with sales and warehouse in one Dataverse.
- Conversion rules between bags, net kilograms and lots on the standard inventory engine
- Dynamics 365 quotes read the same lot balances the warehouse writes
- No custom ERP to maintain: the extension stays on the Microsoft platform
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.
Related solutions, industries & case studies
Industries
Defence & JVsCases
All case studies- Avtek (Modern Trucks) +300% faster development of new sales talent and fully online forecasting
- International Dual-Use Manufacturer (UA / EU / US) NDA Up to 70% lower 5-year ERP TCO across 4 countries on Microsoft Dynamics 365
- Top-3 National Consumer Electronics & 3PL Operator NDA +200% B2B order throughput for a national electronics and 3PL distributor