Sage 100

 View Only

  • 1.  Unable to Change an Item Code

    Posted 01-21-2023 13:15
    Edited by Robert Wood 01-23-2023 13:27
    A customer is trying to use the IM Delete/Change utility and change an existing item code to a new item code. She has the current item code in the Starting and Ending fields, and has entered a new code in the New Item Code field. The system returns the message: Skip - ItemCode not on file.

    Any ideas?


    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------


  • 2.  RE: Unable to Change an Item Code

    Posted 01-21-2023 13:19
    Imported?  Maybe unprintable character at end of the item code.  Can you view in DFDM?

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 3.  RE: Unable to Change an Item Code

    Posted 01-21-2023 13:45

    Also check out for " because I've seen that cause issues with renumbering – especially if she's importing them in. It will import with """ or "" depending on how the file was created.

     




    Original Message


  • 4.  RE: Unable to Change an Item Code

    Posted 01-21-2023 13:19
    I would first check the item in DFDM to make sure there's no hidden character or leading space in the item code. 

    Bill
    ________________________________________________
    Bill Pfahnl
    Nims & Associates
    |direct| 707.781.6307
    |office| 707.781.6300





  • 5.  RE: Unable to Change an Item Code

    Posted 01-21-2023 13:20
    Two things:

    1. If it is just one time, make sure she didn't already run it by accident and forget to clear.
    2. I would have her setup the item code she is metering into just to rule it out. 

    Sent from my iPhone





  • 6.  RE: Unable to Change an Item Code

    Posted 01-21-2023 13:41
    These are all great suggestions. I'll check things out once she can let me in. Thanks, everyone!

    Karen

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------

    Original Message


  • 7.  RE: Unable to Change an Item Code

    Posted 01-21-2023 14:03
    The customer just replied:

    I just figured it out! Sage does not like me copying and pasting from Excel into the Utility. So I completed the entry w/o copying and pasting, and it worked!

    I will thank you all, as she thanked me, for working on a Saturday.  :-)

    Karen

    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    90 Minds Secretary
    ------------------------------

    Original Message


  • 8.  RE: Unable to Change an Item Code

    Posted 01-23-2023 11:55
    Copy - Paste from Excel does include extra characters for sure.  Sometimes Sage programming removes the extras, but not in some places, like that screen.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 9.  RE: Unable to Change an Item Code

    Posted 01-23-2023 09:43
    Is there a BM?






Related Content