Re: 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.
Comments
-
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
Success is the Intersection of Dreams and Hardwork!
3 -
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.
0 -
Instead of changing the formula of ID line item you can make use Product Flat line item to find P2 Product.
0 -
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.
0 -
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
0 -
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.
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.
0 -
Hi, @swapnil_J,
Thank you again for your hint. I populated "Product Flat" Line item.
But P2 Product doesn't have any data as well.
I tried the method of @Suneela, but I can't change the format of P2 Product and Product Flat, so I am not successful to use her method.
Best regards.
Wei
0