PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/17/2013 6:39 AM by  Laura
Need Help Pulling in UOM pricing in PO28
 1 Replies
Sort:
You are not authorized to post a reply.
Author Messages
David M
MMIS Coordinator
Owens and Minor
Basic Member
(25 points)
Basic Member
Posts:11


Send Message:

--
10/16/2013 3:48 PM

    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

    Laura
    Accounting Systems Analyst
    National Heritage Academies
    Basic Member
    (45 points)
    Basic Member
    Posts:19


    Send Message:

    --
    10/17/2013 6:39 AM
    Could you do a query on the POLINE table?
    You are not authorized to post a reply.