Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Deleting a UOM

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
JonA
Veteran Member
Posts: 1163
Veteran Member
1/28/2020 4:49 PM

    We have an issue which I'm sure many also have where end users choose CS for case instead of CA.  Many of our EDI vendors accept CS for case but send CA on the advanced ship notice and invoice line which causes errors in processing.  It's very rare that we would use CS for cassette and in reality EA can be used.  I'd like to inactivate CS but that's not an option in IC00, I can only delete to remove it as a choice for the end user.  My question is - how might deleting a UOM that has been used previously on reqs and POs (I would make sure all lines with CS are closed or change the uom to CA on any open lines) affect old data?  Could we see data corruption if the UOM doesn't exist in IC00?

    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    1/28/2020 10:03 PM
      Yes - you can get data corruption. I deleted BOX for BX and some of the POs reopened. Even fewer simply refused to close again and I kept having to use PO99s and wait for them to be purged out.

      That said, it might still be worth it. Cardinal's website keeps telling my users CS when CA is what is coming EDI and it's really not worth the headache it's causing.
      Jeff N
      Advanced Member
      Posts: 32
      Advanced Member
      2/11/2020 1:52 PM
        You can build a translation table in EDI for UOM. ie you enter CA on the PO but the EDI translation sends CS to the vendor. You then also have an inbound translation that takes it the other way.

        An issue we seem to be having with mostly lab vendors is they have (for example) a box of 10 that they are calling an "EA". I think it is confusing to have an "EA" break-down into a lower UOM so we have been able to use the translation table method for most of them.
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        2/19/2020 9:40 PM
          What's the List name? Can you do this by TPID?