Open Forum

Expand all | Collapse all

Changing decimal place for inventory part

  • 1.  Changing decimal place for inventory part

    Posted 15 days ago
      |   view attached
    Hello,

    A new inventory part number was created with the currency decimal set to 0. This part number was placed on an SO and then pushed over to a PO. It let me know it couldn't change the decimal place because it was used in an SO and PO so we removed the item from the SO and canceled the line on the PO. Problem is, you can't delete the line from the PO and the PO is still open. When I tried to change the decimal place, I got the attached message on the report printed. Is there any way to change the decimal when the PO is still open but the item is canceled? We can't input the correct sale price or cost for the part with the currency decimal set at 0.

    Thanks in advance for any help or direction.

    ------------------------------
    Missi Schrupp
    Ideal System Solutions, Inc.
    Pequot Lakes MN
    ------------------------------


  • 2.  RE: Changing decimal place for inventory part

    SILVER CONTRIBUTOR
    Posted 15 days ago
    Hi @Missi Schrupp,

    Is that the only item on the PO in question? If not, have the other line items been properly received, enter/matched, canceled, etc?  If so, then moving the PO to history should resolve your issue.

    I would recommend checking to ensure you maintain history by going to Purchasing>>Setup>>Purchase Order Processing.  If you maintain history, the completed PO's move to history for viewing later.  If you are NOT maintaining history, then the routine I'm about to suggest removes them from the system.

    Once you've confirmed that you are maintaining history, go to Purchasing>>Routines>>Remove Completed Purchase Orders.  From there you can select this specific PO (or a range of PO's or all PO's) to move to history if they are properly closed.  Once that is done, you should be able to run the change decimal utility.

    If there are other open items on the PO that haven't been received and/or closed out properly, then the routine above won't move the PO to history, and the change decimal utility will continue to fail.

    Does that make sense? If you have questions, please just let me know.

    Thanks,

    Samantha


    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------



  • 3.  RE: Changing decimal place for inventory part

    Posted 15 days ago

    Hi Samantha,

    No, that is not the only item on the PO. There are about 9 other items that haven't been received or invoiced yet so the PO isn't closed. I'm pretty sure that's why it won't let me change the decimal place. I was hoping there was a way around it without having to cancel the whole PO and repurchase everything under a new one.

     

    Missi Schrupp, Full Charge Bookkeeper

    Ideal System Solutions, Inc.

    SDB, HUBZone, Minority and Woman-Owned (EDWOSB) 

    Direct: 763-255-1855

    Toll Free:  888-696-1044

    mschrupp@idealssi.com

    www.idealssi.com

     






  • 4.  RE: Changing decimal place for inventory part

    SILVER CONTRIBUTOR
    Posted 14 days ago
    Darn!  Unfortunately, no, I don't know of a way to change decimals while they are on Open PO's through the application itself.

    Technically a SQL update would be your other options (writing a script to update the item), but there are a lot of tables involved in that so I would personally avoid it  unless absolutely necessary.  If you DO decide to attempt something via SQL, I would recommend restoring to a test company, trying it there, and testing to make sure it behaves as expected before trying it in production.

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------



  • 5.  RE: Changing decimal place for inventory part

    Posted 14 days ago

    Thank you, Samantha. That isn't what I wanted to hear but kind of figured that was going to be the response. I am not going to mess with SQL so will go about it the only way I can and cancel the whole PO, move it to history, make the decimal change and then issue a new PO.

     

    Missi Schrupp, Full Charge Bookkeeper

    Ideal System Solutions, Inc.

    SDB, HUBZone, Minority and Woman-Owned (EDWOSB) 

    Direct: 763-255-1855

    Toll Free:  888-696-1044

    mschrupp@idealssi.com

    www.idealssi.com

     






  • 6.  RE: Changing decimal place for inventory part

    GPUG ALL STAR
    Posted 9 days ago
    It may help for you to first copy the lines you want to keep from the original PO so that you don't need to re-enter all of the lines.
    Kind regards,
    Leslie

    ------------------------------
    Leslie Vail
    Accounting Systems Consulting, Inc.
    DALLAS TX
    leslievail@earthlink.net 972-814-8550
    ------------------------------



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