On-hand by unit of measure

Shawn Thomas
Shawn Thomas used Ask the Experts™
We sell hose by the foot to customers and buy it in 10, 25 and 50 ft rolls.  We can also sell the entire roll.  My inventory unit is in feet and by default the on-hand inventory is displayed that way.  The problem is that I can see 2500 ft of an item in inventory, but don't know how many 10, 25 or 50 ft rolls make that up.  Is there a way of displaying how many rolls of each length make up the total footage displayed?  This would be in Dynamics AX 2012.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The feet is basic unit for hose so the inventory value is correct from this point of view. You can do nothing more if you don't distinguish hose package units in the inventory...

You'll need three more inventory items named "Hose 10 feet roll" etc. and unit of measure conversion which will tell how to recalculate package into feet for each such inventory item.

You can also define another inventory location named e.g. "Shop" where all the hoses (on open rolls) will be measured in foot.

Of course, above item split will require additional calculation for some reports...


Thanks for your help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial