Inventory Costing for Multiple Units of Measure

• 03-27-2008 4:30 PM

  Jason Joined on 02-18-2008 Posts 1	Inventory Costing for Multiple Units of Measure Reply Contact Does anyone know if this can be done in GP?  As an example, I sell products by the piece, but they get manufactered by a unit of volume of the piece (Ft3).  Thanks,   Jason

• 03-28-2008 6:27 AM

  In reply to

  DanS Joined on 03-11-2008 Posts 1	Re: Inventory Costing for Multiple Units of Measure Reply Contact While I am not completely certain of this it should be straightforward.  Set up your inventory item with the FT3 default unit/stocking UofM and have the UofM schedule equate 3 FT = 1 FT3.  Produce your item in FT3 and I think it should work.

• 03-28-2008 6:55 AM

  In reply to

  Ron Draganowski Joined on 10-04-2007 St. Paul, MN Posts 35

  Re: Inventory Costing for Multiple Units of Measure Reply Contact Yes, this certainly is possible, just as the previous poster has indicated.  We have a client doing just this, manufacturing at one unit of measure and then selling at a smaller unit of measure.  GP supports this, so long as FT3 = qty 3 of FT. Only note: be careful on custom reporting.  You'll always want to be sure of your calculations, and factor in the Qty in base unit of measure column (QTYBSUOM, I think).   Multiply that times the QTY field to get the base units being sold.  In your case, the base units could be EITHER FT or FT3.  I would recommend FT, because if you use FT3 then then you're going to run into rounding issues on qty conversions, since you'll always be multiplying by .33333.   Ron Draganowski Senior Solution Developer Olsen Thielen Technologies, Inc. rdrag@ottechnologies.com www.ottechnologies.com   Find me on LinkedIn: http://www.linkedin.com/in/rondraganowski

  Tags: Microsoft Dynamics GP, Inventory, Manufacturing

• 05-30-2008 11:25 AM

  In reply to

  Edd Joined on 05-30-2008 Posts 1

  Re: Inventory Costing for Multiple Units of Measure Reply Contact You might need to set-up a Unit-of-Measure schedule for each item, to relate the volume in cubic feet to the piece.  Use cubic-feet unit as the base, but select "each" (or piece, unit, package, whatever you use) as the "Default Selling U-of-M".Be cautious when creating the "Unit of Measure" schedules, as the set-up screen is frustratingly counter-intuitive. Most people learned math using equations structured as such:  "A x B = C"  So would read the input screen as "eggs times twelve equals dozen".  For unknown reasons, the screen is set-up as "dozen = twelve times eggs" - or "eggs equals .08333 times dozen".  It is not made clear from the input screen; the explanation is two levels down in the "help" menu.