• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Items and unit price

 2 Replies
 0 Subscribed to this topic
 24 Subscribed to this forum
Sort:
Author
Messages
maharuchi
New Member
Posts: 0
New Member
5/6/2016 4: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
Veteran Member
Posts: 165
Veteran Member
New Poster
New Poster
Congrats on posting!
5/6/2016 6: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
Veteran Member
Posts: 1020
Veteran Member
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
5/9/2016 12:53 PM
If you do not have the non-stock built in IC12 - the formula from brupp is how to determine the cost.