web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Inventory Costing for Multiple Units of Measure

(0) ShareShare
ReportReport
Posted on by 65

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

*This post is locked for comments

I have the same question (0)
  • DanS Profile Picture
    5 on at
    Re: Inventory Costing for Multiple Units of Measure

    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.

  • Ron Draganowski Profile Picture
    1,575 on at
    Re: Inventory Costing for Multiple Units of Measure

    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

     

  • Edd Profile Picture
    5 on at
    Re: Inventory Costing for Multiple Units of Measure
    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans