PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/09/2016 8:53 AM by  Kat V
Items and unit price
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
maharuchi
Advanced Member
(52 points)
Advanced Member
Posts:28


Send Message:

--
05/06/2016 12:06 PM
    Hello - I am trying to build a Crystal Report for all IC11 items along with their unit price. .What table can I use for unit price? If I use ICTRANS I get multiple records for same item with different unit price.

    Thanks for your help.
    brupp
    Sr. Data Analyst
    UC Health
    Veteran Member
    (303 points)
    Veteran Member
    Posts:127


    Send Message:

    --
    05/06/2016 2:51 PM
    Hello - I have a report that has a formula for unit price - POVAGRMTLN.BASE_COST / POVAGRMTLN.UOM_MULT. You would need to link ITEMMAST to ITEMLOC, then ITEMLOC to ITEMSRC, then ITEMSRC to POVAGRMTLN. I didn't build this report so there might be an easier way to get there. Hope this helps.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (1831 points)
    Veteran Member
    Posts:625


    Send Message:

    --
    05/09/2016 8:53 AM
    If you do not have the non-stock built in IC12 - the formula from brupp is how to determine the cost.
    You are not authorized to post a reply.