RE: saved search that display item receipts with landed costs (in one line)
I am trying to create a saved search that shows item receipts with landed costs.
I followed Oracle’s video and could make a saved search that shows item receipts with landed costs, but landed cost is not shown in one single line.
For example,
Item Cost Freight Other Landed COst
XXX 3000 0 0
XXX 1000 0
XXX 0 2000
For one item, there are 3 lines ,, but I want to combine them in one single line.
My current result columns are as follows :
date : Maximum
Item : Group
Cost : Maximum
Formula(currency) : Maximum , CASE WHEN ({memo} LIKE ‘%landed cost category%’) AND ({item} = {item.name}) THEN {amount} else 0 END
What should I change?
Thank you in advance.
Hi,
Your table shows Item, Cost, Freight, Other, Landed Cost.
You list columns as Date, Item, Cost, Formula.
I think we’re missing something here. Could you perhaps share some screenshots?
Thanks,
Chris
Hi, sorry I should’ve better elaborated my question.
I just used a random name for landed cost category.
so, this is what my column looks like
and
Item Cost Freight Other Charges
XXX 3000 0 0
XXX 1000 0
XXX 0 2000
above is what my actual saved search looks like…
any suggestion ?
