Unit of Measures and Bill of Materials: feet and inches

(0) Share

Report

Posted on by Community Member

I need help setting up the proper unit of measures in GP 10.0. We purchase tubing by the foot from the supplier. We then cut it into 2 inch segments and a particular Bill of Material gets 1 piece of 2inch tubing in its assembly. I think in our inventory we should carry the item by feet so we know how many feet remain in stock. Can someone help me see how these various UOM's should be set up for the Inventory Item, Purchasing, and BOM assembly?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

You always set the U/M schdule to include the smallest measurement possible. So you could set up a U/M schedule called TUBE and set it base U/M to Inch and then create INCH of 1, PAIR of 2 and FOOT of 12. So you can order in Feet so if you order 12 feet you receive 144 inches. When you build it, your asembly will call for a U/M of PAIR so you will consume 2 inches. Do not confuse U/M Schedule with U/M. A U/M Schdule consists of U/M's. You could have one U/M Schedule for each item you have in inventory.

Was this reply helpful? Yes No
Ian Grieve 22,784 on at

Like (0)

Report

Hi David,

I'm not sure storing in feet is the best option. In Dynamics GP Inventory you can only store to 5 decimal places; cutting 1 of anything into 6 does not give a 5 decimal number as the result so you would always end up using more or less than a foot when dividing down by two inch segments depending on how you choose to round it to 5 decimals.

I'd store it in 2inch segments with FOOT as the Default UofM for Purchasing. I can provide screenshots of the windows if it would be useful.

Ian

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ian, could you please provide those screen shots? They would be useful.

Was this reply helpful? Yes No
Verified answer

Ian Grieve 22,784 on at

Like (0)

Report

Hi David,

Sorry, I don't know what happened to the first image (it seems to have shrunk a lot and I'm not aware of anything I did) and I'm at home with the VM at work so I can't reproduce it quickly, although I think you can still read it (let me know if you can't and I'll have another go).

As the smallest unit of measure you deal with is a 2 inch segment I created a Unit of Measure Schedule as 2INCH with FOOT as a second unit of measure as 6 on 2INCH;

I then set the Default Purchasing U of M to FOOT with 2INCH set as Not Available;

In BOM Maintenance I added the TUBE Item which pulls through the UofM Schedule and set a quantity of 1;

Ian

Was this reply helpful? Yes No