Tax-Compliant Tobacco Distribution on Odoo 18 for Mega Wholesale

Industry

Wholesale Distribution (Cigarettes, Cigars and Tobacco)

Headquarters

United States

Presence

Texas, Florida, Mississippi, New Mexico

Previous System

Microsoft Dynamics

Aktiv Software

Our Solution

Odoo 18

About Mega Wholesale

Mega Wholesale is a US based wholesale distributor of cigarettes, cigars, cigarillos and pipe tobacco, serving wholesale and retail customers across several states. It buys cigarettes in cartons, applies each state’s required tax stamps, and delivers the stamped product to retailers and end customers.

Because the products fall under state excise regulation, the business depends on strict separation of stamped and unstamped stock, bin level traceability, and a wide set of statutory reports for state authorities. Operations previously ran on Microsoft Dynamics, spreadsheets and manual calculations.

The Challenges

Legacy System Migration from Microsoft Dynamics

Critical data sat in Dynamics and spreadsheets, in structures that did not map cleanly into an ERP.

No System Driven Tax Stamp Compliance

Unstructured Credit Control

Rigid Pricing and Discount Handling

No Shelf Life Traceability

Inventory Overstocking, Stockouts, & Sleepless Nights

Limited Warehouse Traceability and Controls

No roll number tracking, no mandatory adjustment reasons, and no structured returns or damage handling.

Our Solution: Odoo 18

Sales

customer pricing, credit enforcement and automated tax stamps

Purchase

automated procurement with real-time vendor prices

Inventory Management

bin level control with stamped, unstamped and state segregation

Accounting and Invoicing

state compliant invoicing on one financial record

Implementation Phases

Phase 1

Migration Strategy

Dynamics and spreadsheet data did not map one to one into Odoo, so Aktiv built a scripted migration with validation, logging and error handling at each stage.

Key focus areas

Customers and vendors with permit numbers and expiry dates
Billing hierarchy rebuilt from Bill-to numbers
Product variants derived from description text
Chart of accounts, pricelists, units of measure, warehouses and bins

Phase 2

Discovery and Planning

Aktiv mapped the highest risk workflows with Mega Wholesale's team, documenting each as a user story with requirement, specification and success criteria before any build.

Key focus areas

Data migration from Microsoft Dynamics
Tax stamp application and state compliance
Bin level movement and stamped versus unstamped segregation
Statutory reporting by state
Credit control, pricing and vendor price rules

Phase 3

Core Implementation and Customization

The ERP was built on Sales, Purchase, Inventory, Accounting, Contacts and Employees, with custom modules added only where regulation or operations required.

Key focus areas

Tax stamp automation by state
Allowed Bins enforcement on every stock move
Credit limits at order and invoice
Pricing, discount and vendor price automation
Shelf life and expiry tracking
State and internal reporting suite
Warehouse traceability, returns and document standards

Functional and Operational Overview

Data Migration from Microsoft Dynamics

Tax Stamp Automation

Bin Level Inventory Management

Credit Limit Control

Pricing, Discount and Vendor Price Automation

Shelf Life Traceability

Regulatory and Operational Reporting Suite

Warehouse Traceability and Operational Controls

1 Data Migration from Microsoft Dynamics

Problem Statement

Dynamics data did not map one to one into Odoo

Accounts carried billing hierarchies, permits and multiple contacts

Products had no attribute structure, but the business runs at variant level

Prices were tied to customers and groups, not products

Solution

Customers and vendors imported with permits, expiry dates, search names and multiple contacts

Bill-to contacts auto linked to their billing parent as an invoice address

Variants derived by matching template and variant descriptions

Allowed bins, pricelists (customer and group, with validity) and all foundations imported by script

Impact

All customers, vendors, products, pricelists and accounting consolidated in Odoo

Billing hierarchies preserved rather than rebuilt by hand

2 Tax Stamp Automation

Problem Statement

Stamp application is the most regulated step in the process

The right state stamp must be applied in the right quantity

Stamp stock must be consumed on delivery

Stamp cost must reach the customer without a separate line

Solution

Tax Stamp flag at category level, inherited onto the order line and user overridable

Add Stamps matches the product group to the customer’s state and adds the right stamp

Quantity computed from tax reporting pack size, converting cartons to stamps

Confirmation prompt when a stamp does not match the customer’s state

Stamp stock deducted on delivery; quantities flow to invoices, transfers and returns

Stamp cost merged into the cigarette unit price on printed documents

Impact

Stamps applied, calculated and deducted by the system, matched to state

No manual stamp math on order lines

3 Bin Level Inventory Management

Problem Statement

Stock moves through WIP, unstamped, stamped and customer stages, each variant in a set bin

Standard Odoo allowed any location, making stamped and unstamped separation unreliable

Solution

Allowed Bins on each variant defines the locations it may occupy

Bin filtering applied to receipts, deliveries, transfers, adjustments and manual updates

Transfer Product screen shows on hand quantity with a transfer all action

Locations classified by state, with on hand split by state on the variant

Stamped and Unstamped columns added to the stock report

Return and Damage locations with defined movement rules

Impact

Enforced stamped versus unstamped separation and state wise visibility

Wrong bin moves blocked at entry, not fixed later

4 Credit Limit Control

Problem Statement

Credit was assigned by customer type but not enforced

Orders could be confirmed and invoiced past the limit

Child accounts bypassed the parent’s exposure

Solution

Credit limits enabled globally and per customer

Credit Limit and Amount Receivable shown on the order

Over-limit orders prompt to proceed or place the customer on hold

Held customers cannot transact until payment or an authorized limit change

Child orders checked against the parent billing account

The same check runs at invoice creation

Impact

Credit enforced across orders and invoices, including child accounts

Exposure surfaced before confirmation, not after invoicing

5 Pricing, Discount and Vendor Price Automation

Problem Statement

Pricing had to respect customer and group agreements and their validity dates

Sales worked in fixed discount amounts, not percentages

Vendor prices went stale between orders

Solution

Pricelist rules extended to target a single customer within a shared pricelist

Rules checked against validity dates, falling back to standard pricing

Fixed amount discount field converted internally to a percentage

Vendor prices auto update from the last received PO, logged in the chatter

Impact

Vendor prices stay current automatically

Negotiated discounts entered directly and applied within valid dates

6 Shelf Life Traceability

Problem Statement

Shelf life varies by product

Expiry had to be tracked from the moment stock arrives

Solution

Shelf life set per product in days, months or years

Expiry calculated automatically on receipt or manufacturing

An action recalculates expiry on existing stock when settings change

Impact

Expiry tracked automatically from the point stock enters the warehouse

7 Regulatory and Operational Reporting Suite

Problem Statement

Every state prescribes its own report format, unit of measure and classification

Reports built outside the ERP were not traceable to their transactions

Solution

Sales Customer Wise, merged by shipping address with a multi state option

Sales Tax, in the selected unit of measure

Texas Tobacco Sales and Purchase Invoice, by tax class

Florida Tobacco Sales, by customer state

MSA, with UPC, class of trade and on hand inventory

Retail, mapped to Texas Comptroller item and unit codes

Vendor and Customer reports with subtotals and totals

Inventory Valuation in the prescribed export format

SAMS Club Group Order, consolidated with a category summary

Shared filters and unit conversions, sourced from invoices and bills, with credit notes as negatives

Impact

A full statutory and operational suite generated from invoice and bill data

Reports run from live data, not assembled by hand

8 Warehouse Traceability and Operational Controls

Problem Statement

No roll number tracking on receipts and transfers

No mandatory reason on manual adjustments

No structured returns or damage handling

Erroneous purchase orders could not be archived

Solution

Unique Roll Number on receipts and transfers, printed on documents and hidden on deliveries

Mandatory memo on every manual inventory update, kept for audit

Erroneous POs archivable, with validation against open receipts

New contacts default to the United States

Audit trail can be deactivated for authorized corrections

Impact

Full traceability via roll numbers, adjustment memos and return and damage locations

Every manual adjustment carries a recorded reason

What Changed for Mega Wholesale

Results & Business Impact

Mega Wholesale replaced a fragmented Dynamics and spreadsheet setup with a single Odoo 18 platform, with every figure traceable back to the underlying transactions.

Customers, vendors, products, pricelists, transactions and accounting unified in Odoo.

Stamps applied, calculated and consumed by the system, matched to state, with a mismatch gate.

Allowed Bins on every stock move, with stamped and unstamped split by state.

State and internal reports generated straight from invoice and bill data.

Limits enforced at order and invoice, including child accounts, with hold and release.

Expiry tracked from the point stock enters the warehouse.

Roll numbers, mandatory adjustment memos and dedicated return and damage locations.

Invoices, picking lists and delivery slips aligned to regulatory and brand needs.

Sales, purchase, inventory and accounting on one system, traceable to source transactions.

Be our next success story

Let’s Talk!

Customer Success Stories

Not to flex, but these are some Real results. Real wins.

4.7

is our

average

Aktiv Software Pvt. Ltd. followed up on the project as promised.

Bjorn Midtlien

CEO, Digitus Nordic AS

Rather than focusing on short-term fixes, their approach is pragmatic, focused on sustainable, long-term results.

Kasper G

Owner, Nordic by Choice

Their solution has helped us reduce our project managers' time for invoicing from a week to two days.

Kateryna Mykhailenko

Manager, ToxMinds

On a scale of 1-10, we would rate Aktiv’s partnership as 11.

Fabrice Beaux

CEO, InterHyve Sàrl

About Us

Aktiv is Odoo certified partner offering end-to-end implementation services.

We don’t just implement ERP, we bridge the gap between technology and your workforce, ensuring smooth adoption, empowered employees, and maximized ROI.

With over 10+ years of experience implementing Odoo for SME and Enterprise clients, we know how to assist you in your digital transformation journey. It’s what we do the best!