Skip to main content

Notifications

Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Item sold in feet, pro...
Small and medium business | Business Central, N...
Suggested answer

Item sold in feet, produced in rolls, 5 decimal places is not enough to convert

(1) ShareShare
ReportReport
Posted on by Community member 44
We have an item that is produced and stored in ROLLS, but sold in FEET.  Normally this would not be an issue, however the conversion between ROLLS and FEET cannot be accurately achieved with just 5 decimal places of precision. 

For example, 1 ROLL of XYZ part is 1400 FEET.  With 5 decimal places, the alterative unit of measure would look like this:



.00071 x 1400 = .994.  The production order created from a sales order for 1400 feet would be for .994.  Rounding that up to 1 on the production order would leave .006 in inventory.
 
Has anybody else out there had to deal with this issue before, and if so, how did you manage it?  
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    The unit of measure code is in the production order lines, not in the header:
     
     
    Having reservations is fine.
     
    Also, if you didn't want to change the base unit of measure, the only other option would be to do some sort of adjustment at month end. For example, as per your example if you produced and sold 1 roll in a month, you would have .006 in inventory left over. You would do an item journal negative adjustment or phys. inventory count to get this .006 out of inventory.
     
     
    Valentin Castravet
    Zander ERP Services
     
  • Community member Profile Picture
    Community member 44 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    I see what you mean now, Valentine.  It is not really a good option because it leaves room for too much human error, but it is an option.
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,377 Super User 2024 Season 2 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    from the screenshot, the base uom is set up as roll. the maximum decimal places in BC is 5 by default, I don't think you could change it to a higher number without causing complications.
    the best way is just use feet in bom or manually deal with the rounding if customer insists using roll in bom.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    after you create the prod. order and refresh it, manually change the uofm to roll
  • Community member Profile Picture
    Community member 44 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    For some reason, I have not been able to get that to work.  The BOM has ROLL as the unit of measure code, and I have an item with a base unit of measure of FEET.  Every time I create a production order for the item, it creates it in feet and not a roll.  I must be missing something.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    And that will work. On the item card your base uofm will be feet, your sales uofm will be feet, and your manufacturing batch uofm will be rolls: Use the Manufacturing Batch Unit of Measure - Business Central | Microsoft Learn 
  • Community member Profile Picture
    Community member 44 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    Valentin, appreciate the weigh in.  I agree with your solution, but the client is looking for alternatives so they can maintain producing in rolls and selling in feet.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Item sold in feet, produced in rolls, 5 decimal places is not enough to convert
    I believe 5 is the max amount of decimals. Best practice is to setup the base unit of measure as the smallest unit, in your case this would be feet. If feet is the smallest you would not have this issue.
     
    In the Item Units of Measure Page you would have FT Qty. Per Unit of Measure as 1, and RL Qty. Per Unit of Measure as 1400.
     
    You can change the base unit of measure for an existing item card if the quantity in inventory is 0. If its not zero you can use an item journal with a negative adjustment to get it to zero, change the base unit of measure, do a positive adjustment to put the quantity back in inventory. Alternatively, you can create a new item card with the correct base unit of measure. 
     
     
    Valentin Castravet
    Zander ERP Services

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans