Sage 100

 View Only

  • 1.  "The record is not in an editable state" importing UDF value into IM_ItemCost (v4.5)

    Posted 08-15-2022 18:08
    Client (on 4.5) has a UDF "Expiration Date" in IM_ItemCost, IM_LotSerialTransationHistory. I built a VI job to import the Expiration Dates into IM_ItemCost (to begin with). The job is easy. The problem is that each record fails with the message "The item is not in an editable state".  Will this require a DD hack or might it be something else?
    .




    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------


  • 2.  RE: "The record is not in an editable state" importing UDF value into IM_ItemCost (v4.5)

    Posted 08-15-2022 18:14
    GroupSort is your Lot#... and don't try to edit the LotSerial column.  If it is going to work at all, just include the Primary Key columns and your UDF.  (Hopefully it is just complaining that you are trying to add a row to the table...).


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



  • 3.  RE: "The record is not in an editable state" importing UDF value into IM_ItemCost (v4.5)

    Posted 08-15-2022 18:33
    Thanks Kevin, my Oops on the GroupSort field.  That did the trick!

    Appreciate your quick response!

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    ------------------------------

    Original Message


Related Content