Import Shipping Expenses into OTH01 Module

Hi everyone,
 
I'm still struggling with the import into the FP&A model (Level 2 Conclusion)
 
Here's the mapping I have had:
2021-06-09 (4).png
 

And here is the error I have got:

 

2021-06-09 (5).png

 

Here's how my INV05 Shipping Export module looks like in a Blueprint mode:

 

2021-06-09 (6).png

 

2021-06-09 (7).png

Is there any chance someone could help me, please?

Best Answer

  • Hi @katarina129 ,

     

    The source view consists of summary level items as well, as can be seen in your screenshot (All regions, Americas etc), which is one of the causes for failures. You might want to use the 'select levels' in the source, and only include lowest level items (which is want you want to import).

    This way you can get rid of the error.

     

    Regards,

    vinayvm

Answers

  • Thank you @Vinay VaradarajM - it has worked!

  • @Vinay VaradarajM

    Hello, i have this same issue,

    My saved view includes summaries but i can´t find the option of 'select levels' in the source that you mention to remove them. Can you help please, TY.

  • Vinay VaradarajM
    edited March 2023

    @JosAngel94 : You can right click in the area where List items are shown on the left hand side, and it will open a menu of options where you can find 'Select Levels' or 'Reselect Levels' (if something is already selected)

    Example:

    In your case:

    Regards,

    vinayvm