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

Subscribe (1)
Report
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
• 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 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.
• 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.
• 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 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.
• 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 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.
• 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

#### 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â€¦

#1

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

#2

Martin DrÃ¡b 222,703 Super User

#3

nmaenpaa 101,138