Hello,
I need to build an Excel query or application that will pull in all Units of Measure and there pricing for all "active" items. The direct screen that I know I can find this info for "manually" is PO28. I can't find a report in Lawson that will do this and I have tried to build the query and applicaton from Excel addins myself and have had no luck.
expanded description of problem-- If i pull in the item master data, it only will pull in the base cost which is usually the highest unit of measure price. the problem is that lets say the price is at Case and I need the Box or Each price for my report. I have no easy way to get this info other than manually doing the math/conversion to get the other UOM pricing. Or looking it up in PO28 which for 100 items or more can take all day. I hope this all makes sense.
Can anyone help, any ideas?
Thanks so much
David