Open Forum

Expand all | Collapse all

Unit of Measure Schedule decimal places

  • 1.  Unit of Measure Schedule decimal places

    Posted May 14, 2019 12:29 PM
    When our company set up GP,  a unit of measure for each was set up as EA with 4 decimal places.  I don't know why an "each" would have 4 decimal places, but this is interfering with other functionality and we need to change it to 0 decimal places for all of our finished goods, which are and always have been discrete items.

    System documentation and all discussion posts I have been able to locate indicate that there is not a way to modify "EA" now that it has been set up and used.

    I know I can change the decimal places using the "Change Decimal Places" utility for a range of inventory Class IDs, but because I have a large number of items I really don't want to fix the UoM schedule, price list, and purchasing options for thousands of items.

    Is there any other option available that would allow us to efficiently update "EA" to 0 decimal places or maybe replace all "EA" with a new, properly defined UoM?

    Thanks for your expertise!

    Sharon Dunn
    Combined Systems, Inc.
    Jamestown PA

  • 2.  RE: Unit of Measure Schedule decimal places

    Posted May 15, 2019 10:54 AM
    This sounds like a lot bigger issue than a forum post.  Setup affects so many things down the line that I doubt there is an easy answer for this.  My suspicion is that you're going to need to talk to a specialist who can write some SQL code to create a new unit of measure and move over all the affected items and item classes - at which point you could delete the offending unit of measure.  I'd contact your partner and ask if they can recommend someone to assist.

    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise ID

  • 3.  RE: Unit of Measure Schedule decimal places

    Posted May 16, 2019 08:47 AM

    I'm with Blair on this.  This could be a huge issue that may call for a re-implementation (migrate your data to a new company with the correct configurations).  I'll add this tidbit...   I would look through all of the inventory transactions and see if any transactions from any modules (SOP, Manuf, etc.) have fractions.  If you are extremely lucky and all of your transaction are round numbers (no decimals), then I would consider allowing a professional to take on the complex task of updating your SQL tables.  If you have any transactions with decimal points, I would not attempt a SQL update.


    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries

If you've found this thread useful, dive deeper into User Group community content by role