Open Forum

Expand all | Collapse all

Is there a way to change Item UoM with pending orders?

  • 1.  Is there a way to change Item UoM with pending orders?

    TOP CONTRIBUTOR
    Posted 11 days ago
    We're making some changes to be better able to calculate some brokerage amounts on our shipments, but these depend on a unit of measure change on all items.  I've been able to change about 97% (of 800) of the items in between orders.  In order to change the unit of measure, I first have to change the decimal places on the items, which requires that there be no open orders with that item.  This is a problem as these last 3% are in constant demand.  Is there a way to make these changes on the backend and what are the risks?  We don't track inventory (because this is a buy-sell operation) so I'm not worried about inventory counts.  We have to get this unit of measure changed before we can use our new brokerage tracking tool (Rockton's Pricing Management).  Any suggestions?

    ------------------------------
    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Is there a way to change Item UoM with pending orders?

    TOP CONTRIBUTOR
    Posted 10 days ago
    Blair,

    This is a one-time change, correct?  I would move the offending rows in SOP10200 to a temp table.  Make your change in the GP interface.  Then, move them back from the temp table to SOP10200.  You may have to do this on the purchasing side as well (if applicable).

    The usual disclaimers apply...   Write and run your scripts in a test company first.  Test.  Test.  Test.  Take an outage (all users out) of the live company for the live run.

    Good luck.

    Chris

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

    Academy - Online Interactive Learning from Experts


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