Skip to main content
Business Central forum
Suggested answer

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

editSubscribe (1) ShareShare
ReportReport
Posted on by 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?  
Categories:
Attachments
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 4,167 Super User 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 3,640 Super User 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 4,167 Super User 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 4,167 Super User 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 4,167 Super User 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

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,166 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,703 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans