Conversion Factor in IC11 UOM tab

Sort:
You are not authorized to post a reply.
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member
    I need to change a conversion factor on an item and I'm getting an error "Conversion information inaccurate".
    I need to change it so that our HL7 interface picks up the item and filters the correct charge to our Meditech ORM system.

    I discovered the same issue with a few other items as well.

    I have a couple of screen shots attached.

    Has anyone ever ran into this problem before?
    Attachments
    Stephanie
    Veteran Member
    Posts: 86
    Veteran Member
      Hi Bev,

      This is because it is inaccurate.  The lowest UOM is always at 1, I also can't see from your second print screen if you corrected the Stock UOM along with trying to correct the UOM.  This has to be done in a specific order and is a huge pain!  Also, this will skew your usage, so we typically update the description 2 field to include *U to indicate there was a UOM update.  

      These instructions aren't fancy but feel free to check them out to see if they help you at all!

      Stephanie
      Attachments
      Stephanie Kowal | skowal@rpic.com
      Bev Edwards
      Veteran Member
      Posts: 366
      Veteran Member
        Hey Steph!
        Take a look at the screen shot. It's a more complete shot.

        Is there a way to change this so EA is my lowest UOM with 1 and BX is next with 40?
        Attachments
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
          My 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
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            My 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
            Stephanie
            Veteran Member
            Posts: 86
            Veteran Member
              Hi Bev,

              Kat's steps are basically the same as what I sent in the previous post with my document but maybe the print screens will help.  If you need anything else, let me know! 

              Stephanie
              Stephanie Kowal | skowal@rpic.com
              Bev Edwards
              Veteran Member
              Posts: 366
              Veteran Member
                I need to change one more value to get this item price to calculate correctly to our Meditech system.

                It's the UOM_MULT field. It lives in the PVAGRMTLN table, but I don't see the field on the PO25.6 form.

                Where is it?
                JonA
                Veteran Member
                Posts: 1162
                Veteran Member
                  POVAGRMNTLN pulls that from ITEMMAST. It matches the agreement UOM with the correct ALT_UOM in IC11 and the corresponding conversion factor is the UOM_MULT on the agreement line.
                  Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                  Bev Edwards
                  Veteran Member
                  Posts: 366
                  Veteran Member
                    Thank you Jon! That's definitely helpful and I see that I need to change my Stock UOM, however I'm getting an error UOM is defined as an alternate UOM, cannot be changed.

                    I've made a few attempts, but no luck.

                    I've attached a screen shot.
                    Attachments
                    JonA
                    Veteran Member
                    Posts: 1162
                    Veteran Member
                      Your stock uom has to be the lowest uom (conv factor = 1). If you want to change the stock uom from EA to BX for this item you'll have to remove BX completely from the UOM tab. Then add it back in on the UOM tab and put BX in the Stk UOM field in the same change. Then remove EA from the UOM tab. But I would not recommend this if you want to track unit cost for procedural cost accounting. We have the stock uom for most supplies down to the EA, especially for items that are patient chargeable.

                      You said earlier that the wrong cost was being calculated for your Meditech system.  Assuming the uom on the agreement line was CA or BX the cost you would want to pass would be the EA cost, correct? Whatever the case/box cost is divided by 40?
                      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                      Bev Edwards
                      Veteran Member
                      Posts: 366
                      Veteran Member
                        Hi Jon,
                         Yes, that's correct. I want the EA cost to be passed to the Meditech system. From what was explained to me, there is an algorithm built into the interface that takes the CA cost and divides it by the UOM_MULT value, in this case it's 40.

                        I took some screen shots of the item set up if you want to take a look at it and see if something stands out to you. I don't know what else that may need to be changed, if anything. It looks to be set up exactly like another item we have that is set up the same way and the cost for that item is transferring correctly.

                        Bev
                        Attachments
                        JonA
                        Veteran Member
                        Posts: 1162
                        Veteran Member
                          That UOM setup looks correct to me. Which interface file are you using to send data to Meditech? IC527? IC526?
                          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                          Bev Edwards
                          Veteran Member
                          Posts: 366
                          Veteran Member
                            I'm not sure, but I posed the question via email a few minutes ago.

                            What I did notice is this. We have another item that is set up the same way. The UOM_MULT value for that item is 48 and when I dump the POVAGRMTLN table, the UOM_MULT field reflects 48.

                            For the item I'm having the problem with, that same field reflects a "1" even though 40 is what is in the IC11.

                            Any thoughts on why the POVAGRMTLN table wouldn't be updating??
                            Red
                            Veteran Member
                            Posts: 87
                            Veteran Member
                              Bev,
                              We noticed this years ago... and I do not have a response other than Lawson/Infor's answer was that the IC and PO modules do not dynamically update [each other].

                              So, here is a quick experiment. If you go to the line (PO25.6) where you see this discrepancy, and just do [C]hange on the line and then review it, I bet it updates to the current IC11.

                              For our part, I had one of my tech teammates write a script/program that actually does a [C]hange on each and every active agreement line (each and every evening). You can also do this via MS Addins, if you feel like dedicating a machine to the process.

                              I guess it would bordeline naive of me to think that there might have been a more elegant solution put in place by now.
                              Red
                              Learn from the Past. Prepare for the Future. Act in the Present.
                              Bev Edwards
                              Veteran Member
                              Posts: 366
                              Veteran Member
                                OMG!! Totally worked!

                                To my knowledge, we haven't see this scenario before, but you can bet I'll remember this trick if it ever happens again.

                                I spent time on this ridiculous item that I'll never get back again. Going home as soon as I send out my victory email.


                                Thanks Red!!

                                Thanks to you too Jon for taking a look at this for me!!

                                Bev
                                StephanieD
                                Veteran Member
                                Posts: 39
                                Veteran Member
                                  We have PO125 scheduled nightly, this job updates agreement item description, description2, and uom multiplier to match ic11.
                                  JonA
                                  Veteran Member
                                  Posts: 1162
                                  Veteran Member
                                    I thought that job only updated the item description. Interesting.
                                    Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
                                    You are not authorized to post a reply.