Re: SYSY03 Account>Product Details (L3)

sosunkwo
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

SYSY03 Account>Product Details (L3)
 

In my SYS03 Account>Product Details module, I can't seem to populate my P2 Product. Everything I have tried returns a blank - doesn't show any data. I wonder what I'm doing wrong. 


 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Puneeth H P
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

Hi @sosunkwo 

 You have 'ID' line item in the 'SYS03...' module . 

Populate this line item by Display name property of the list A2 Acount>Product#  ----- : 'A2 Account>Product#'.Display name .

And you can populate P2 Product Line item by using FINDITEM('P2 Product',ID) . 

Remember 'ID' is a text formatted and 'P2 Product' line item is P2 product list formatted . 

FINDITEM searches the Text from ID in P2 Product list . 

 

Hope this helps . 

 

Thank you,

Puneeth HP 

View solution in original post

7 REPLIES 7
Puneeth H P
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

Hi @sosunkwo 

 You have 'ID' line item in the 'SYS03...' module . 

Populate this line item by Display name property of the list A2 Acount>Product#  ----- : 'A2 Account>Product#'.Display name .

And you can populate P2 Product Line item by using FINDITEM('P2 Product',ID) . 

Remember 'ID' is a text formatted and 'P2 Product' line item is P2 product list formatted . 

FINDITEM searches the Text from ID in P2 Product list . 

 

Hope this helps . 

 

Thank you,

Puneeth HP 

View solution in original post

sosunkwo
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

This worked! 🙌 Thanks a lot @Puneeth H P .

It's funny there was a step I was missing with the product search & find item in my previous approach. 

swapnil_J
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

Instead of changing the formula of ID line item you can make use Product Flat line item to find P2 Product.

Suneela
Occasional Contributor

Re: SYSY03 Account>Product Details (L3)

@swapnil_J 

 

Could you please elaborate.

I've attached my screenshots and I do not see the P2 product & Product Family line items populate the data.

Also, ID field shows the # and Product Flat doesn't have any data as well.. Any thought process in this regard is appreciated.

 

 

Suneela Molagavalli, CPA
swapnil_J
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

Hi @Suneela 

First, you need to populate data in list formatted line item -. Product flat line item using list property. 

now to populate the data in  P2 product you can make use of the Product flat line item in finditem function.

https://help.anaplan.com/en/1933a49b-40a1-4575-8dd8-0b859fd3a05b-FINDITEM 

 

 

 

 

Suneela
Occasional Contributor

Re: SYSY03 Account>Product Details (L3)

Thank you for your reply. I didn't use the product flat line item at all and was able to keep the formulae as it is and do a work around by using the code line item to display the product code.

 

@swapnil_J ,

 

With regards to using the product flat line item, did you intend to get the display name (from A2 numbered list) into the Product flat line item and then use that in the FINDITEM function?  It populated the data as needed in the P2 Product with no issues. I guess it doesn't matter if we use ID line item or product flat line item. It can be achieved either way by using the display name from the A2 list.  I've attached the screenshot for your reference. Please let me know if you had another optimized way of doing it.

 

Suneela Molagavalli, CPA
swapnil_J
Frequent Contributor

Re: SYSY03 Account>Product Details (L3)

@Suneela 

yes, data can be populated using one of these two line items.