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.
Go to Solution.
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 .
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.
Instead of changing the formula of ID line item you can make use Product Flat line item to find P2 Product.