SYS03 Account>Product Details, P2 Products

Hello,

I am trying to load data in P2 Product line item. I am using FINDITEM(List, Text) but I am not getting any result. In my module ID and Code are in Text format but they didn't work. I created DAT03 module to turn P2 Product list to Text and referred to DATA03 in the formula but still didn't populate the data. What am I doing wrong here.

Screenshot_29-10-2024_92758_us1a.app.anaplan.com.jpeg

Screenshot_29-10-2024_92822_us1a.app.anaplan.com.jpeg

Thanks

Accepted answers

AjayM

In this course context, since 'Product flat' and P2 lists share same name and code, you may use finditem upon name or code of the property [Ex: finditem(p2,code(A2.display name))].

Otherwise, like @JMVasicek suggested, you could extract P2 code from A2 code using mid/right functions, and then use that extracted code within finditem. Ex: if A2 code is A01_P01 (concatenation of Account code and P2 code), use RIGHT function to extract "P01" value, and then use it in finditem.

All comments

AjayM

For a FINDITEM to work, you should pass either name or code of the corresponding list as an argument. You can't use 'ID' or 'code' lineitems directly here because they both are of A2 list, not of P2.

Either try to extract P2 relevant code portion from A2's code for finditem, or simply check if A2 list has the relevant property that can be simply pulled into SYS module.

Cheers!

JMVasicek

Hello @Gharbali,

Here are a couple of reasons why your FINDITEM isn't working:

First, I would assume that the code of Account>Product is a concatenation of Account Code and Product Code (such as Acct123|Prod456). The FINDITEM won't find that concatenation in the Product list.

Second, I see that DAT03 is dimensioned by P2 Product, which has different dimensions than SYS03, so it's not picking up the P2 Product code.

Instead, try one of the following:

If you capture P2 Product or Product Flat when creating the Account>Product list via import, try referencing that. (It appears the Product Flat relationship exists, so if you have a Product Flat to P2 Product relationship, simply reference that link using a LOOKUP on your Product Flat line item.)
If that relationship isn't created when building the Account>Product list, you can use text parsing formulas (FIND, LEFT, RIGHT, MID) to derive the product code. Then your FINDITEM should work. (Option 1 is preferable if possible, since it cuts out this intermediate step)

Gharbali

@AjayM

Thank you for assisting me. Speaking of A2 properties, I have the "Display Name" but since it is also List, it doesn't work. That's why I tried to extract the name in DAT03. However, it is also not working. Any advise?

Screenshot_29-10-2024_114652_us1a.app.anaplan.com.jpeg

AjayM

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…