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.

 

jihailey Rookie Asked on March 30, 2023 in Saved Searches.
Add Comment
1 Answers

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

Advanced Answered on March 30, 2023.

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

RE: saved search that display item receipts with landed costs (in one line)

 

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 ?

on March 31, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.