Conversion Factor in IC11 UOM tab

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?

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

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

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

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?

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.

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.

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?

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

That UOM setup looks correct to me. Which interface file are you using to send data to Meditech? IC527? IC526?

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??

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

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

We have PO125 scheduled nightly, this job updates agreement item description, description2, and uom multiplier to match ic11.

I thought that job only updated the item description. Interesting.