Mapping issue

Pankhuri
Pankhuri
in Modeling

HI,

 

I have one Account flat list which has code for every accounts. there is one more flat list account items which is related to items within the accounts. So one account can be related to many account items list. there is one list which consist of items  levels (1-5 numbers). so now i want to have values of account based on sum of account items related to accounts and each level numbers. like if level are 1,2,3, 3 for account items a1, b1, c1, d1., account code is 1500 for all the items. it should sum accounts based on account code and the respective levels

 

How will i be able to get the value. Please help me with the solution.

 

 

Thanks

Pankhuri

Tagged:

Comments

  • srikanthkamath
    srikanthkamath

    Hi, Could you please elaborate this issue with sample files or screenshots?

  • nathan_rudman
    nathan_rudman

    In your source module, where you have the data, you need to create a mapping line item formatted as List Account. You make a formula to map it based on the numbering of the account item.

    You can then SUM the values by that line item in your target module which has Account as a list.

  • Kanishq17
    Kanishq17

    Hi @Pankhuri 

     

    Is levels list a property of account items list or levels is a separate list and present as List formatted line item in account item module.

    In that case , if you to aggregate level values by account, you need to find account name using finditem, and create a number formatted line item and convert levels number which is list formatted to a number format using value(name(levels)), then aggregate based on account in the target module

Categories