IC11 UOM and Price

 10 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
lars
Veteran Member
Posts: 54
Veteran Member

    I added an IC11 item and it is a Contract PO25.6 line.

    Buyers placed PO20's against this Contract line (and the IC11 number).

    I attempted to change the unit of measure and price manually am  via an upload but was unsuccessful.

    Is it even possilbe to change change the UOM in IC11 when it is in PO25.6 and a PO2O was issued with the IC11 number?

     

    Thank you.

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
      Changing the uom for an item is complicated when the item exists on an agreement (or any other screens) and there's PO activity. Somebody might have a better way of doing this but here's what I do to change the uom, say from BX to CA and BX is the only uom on IC11: Add a temporary uom to IC11 like PK. Then change the agreement line to PK and change any open PO lines to PK (and also on any templates or pars). Then go back into IC11 and enter CA as the stock uom and add CA on the uom tab and hit Change. Then make BX inactive and hit Change. Now go back to PO25.6 and change the uom on the agreement line to CA and change the open PO lines to CA (and on any other screens). Then remove PK from IC11.
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      lars
      Veteran Member
      Posts: 54
      Veteran Member

        Thanks. You have helped me in the past.

        Would it be correct  to say that changing UOM's would not be complicated if  PO20 orders had not been placed against this IC11 item? If so, then I could simply delete the Contract line, change the IC11 UOM, and re-add the Contract line back in 25.6?

        DuPage is new to 25.6 Contracts, and so am I.There have been  numerous pricing and decription changes, and now, users want to change UOM's too, which as described, is a lot more complicated.

         

        JonA
        Veteran Member
        Posts: 1163
        Veteran Member
          UOM changes are easier when there's no transaction activity. But also the more places the item lives- IC12, PO13, PO25, PO15, IC81, etc.- the more difficult it is to change the uom structure.

          Is there a business case for changing the uom on these items?
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          lars
          Veteran Member
          Posts: 54
          Veteran Member

            When you say Business Case, I assume you mean with Lawson Support?

             

            JonA
            Veteran Member
            Posts: 1163
            Veteran Member
              No I mean what's their reasoning for needing the uom change.
              Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              lars
              Veteran Member
              Posts: 54
              Veteran Member

                The department throught they were purchasing the item, 100 at a time.

                Now they want to buy in smaller quantities, say 2, or 10 at a time, so they wanted to change from per 100 to each.

                 

                 

                Kat V
                Veteran Member
                Posts: 1020
                Veteran Member
                  Does the vendor allow it? If the lower UOM did not exist in Lawson at all - the following are our steps:
                  STEPS HOW TO ADD/CHANGE TO A LESSER/STOCK UOM
                  1. IC11 UOM Tab: add new stock UOM with all priorities 2 and click Change
                  2. Templates: PO115 UOM Job: Change Field Tab
                  • Change to new stock UOM and run in update mode
                  3. IC11 Main Tab: change stock UOM to new UOM and click Change
                  • IC11 UOM Tab: change conversion ratios as needed and click Change
                  4. Templates: PO115 UOM Job: change back to buy UOM as needed
                  5. PO25.6: Change vendor price agreement as indicated
                  • If price file does not allow UOM change (“Does not match Vendor Item”):
                  i) Go to PO13
                  ii) From Vendor Item Description field, Shift+F3 and Change (refresh info from IC11)
                  iii) Return to PO25.6 and resume


                  But the UOM on the PO has to be agreeable to the vendor or they won't get any product at all.
                  lars
                  Veteran Member
                  Posts: 54
                  Veteran Member

                    Thanks Kat V, I will try this.

                     

                    anu singh
                    Basic Member
                    Posts: 13
                    Basic Member
                      Hi, I have to change the UOM from EA to PC in IC11, IC12,PO25.6 So how to do that so can anyone please tell me the detailed steps of it. There are approx 90 Items.
                      anu
                      JonA
                      Veteran Member
                      Posts: 1163
                      Veteran Member
                        It can be tricky.  When making uom changes in IC11 the questions I ask are:
                        Are there any open PO lines (PO20)?
                        Are the items on any templates (PO15) or par locations (IC81)?
                        Are the items on any agreements (PO25.6).
                        Is the uom I need to change hard coded on any vendor item (PO13) or item location (IC12) records

                        I'll assume that EA is the only uom for these items currently since you need to change the agreement lines from EA to PC.  I would add a "dummy" uom like BX to the items first making sure to add this a valid buy uom if you have open PO lines.  If there are any PO lines that have not been received you can change the uom to BX for now.  If there's receipt or invoice activity on those lines it might be best to just let those close out before you update IC11 for those items.  Now change the uom in any pars or templates to BX.   If EA is hard coded on any IC12 or PO13 records, blank out those fields. Then change the stock uom on the MAIN tab in IC11 to PC and add PC on the UOM tab in IC11.  Your UOM set up will look like this.

                        Change the uom in PO15, IC81 and PO25.6 to PC.  Add PC to PO13 and IC12 if necessary. Now you can inactivate EA and remove BX on the UOM tab in IC11.

                        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health