Handling Mixed Unit Sales (Cases + Bottles) in Decimal Format – Beer Industry

(5) Share

Report

Posted on by Sumit Singh

10,220

Hi Community,

This query is related to the beer industry, where sales typically happen in cases (e.g., 1 case = 24 bottles). However, there are scenarios where a customer order includes both full cases and individual bottles—for example, 24 cases and 7 bottles.

Currently, the user needs to manually calculate and enter the total quantity in decimal format (e.g., 24.29167) based on the case-to-bottle conversion. This is not only time-consuming but also prone to errors.

Is there any standard functionality in Business Central that allows users to:

Enter quantities in mixed units (e.g., "24 cases + 7 bottles")
Or have the system automatically calculate the decimal equivalent
Or any alternative approach or extension that can simplify this process?
Any suggestions or best practices would be greatly appreciated.

Regards,

Sumit Singh

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (4)

Report

Hello,

Business Central doesn't support mixed-unit entry (like 24 cases + 7 bottles) out of the box, but this can be effectively handled using the Unit of Measure (UOM) setup. You can define Case as the base UOM (e.g., 1 Case = 24 Bottles) and allow users to enter quantities in either unit. However, for mixed entries, a custom extension is the best approach - this can introduce a secondary input field (e.g., cases and bottles) and auto-calculate the total in base units.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Verified answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (4)

Report

This could be handled by creating 2 lines on the order, one uses case as UOM, the other bottle. Below is an example.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (3)

Report

Hello,

You can use "Unit Of Measure" Setup defining "Case" as the Base UOM and "Bottle" as an alternate UOM with a conversion rate (e.g., 1 case = 24 bottles).

This allows users to enter quantities in either unit, and the system automatically converts them, eliminating manual decimal calculations.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (2)

Report

This could be handled by creating 2 lines on the order—one using Case as the unit of measure and the other using Bottle. This way, users can enter the exact quantities without needing to calculate decimals manually.

Mark this as the verified answer if helpful. ✅

Was this reply helpful? Yes No