RE: Saved Search (Quantity Sold Formula)

Hello everyone,

I have a question about the problem I am experience.

Problem with formulas is,

Saved Search Merging

Formula converting or Kit/Package Items and their sold quantity to the single item. Which means,when we sold Kit/Package item for example N9888-99-4 (quantity sold 1) there is exactly 4 quantities. Because that Kit/Package consists of 4 items. And this formula works well for me.

DECODE({item.memberitem},NULL,{item},{item.memberitem})

DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity})

 

However, I am not able to add any other fields. I tried to add Display Name fields with same formula (example below),and I am not get results as I expected. Display Name does not appears on all items and sold Quantity are not accurate.

DECODE({item.memberitem},NULL,{displayname},{item.memberitem})

 

Could you be so kind and help me out with this ?

If you any other question please let me know.

Source formula,

http://www.netsuiterp.com/2018/12/saved-search-to-show-quantity-sold-for.html

Kind Regards

Sobic Rookie Asked on February 10, 2020 in Items.
Add Comment
1 Answers

You probably want to make your formula have a default value for when an item does not have a display name. You are grouping by display name, so different items without display names will be grouped together.

I would recommend using NVL or NVL2 to return a default value for when the display name is empty. Its makes since to use the original value of {item} as the default.

Intermediate Answered on February 11, 2020.
Add Comment

Your Answer

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