Import Shipping Expenses into OTH01 Module

katarina129
katarina129
in Integrations and extensibility
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?
Tagged:

Best Answer

  • Vinay VaradarajM
    Vinay VaradarajM
    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

  • katarina129
    katarina129

    Thank you @Vinay VaradarajM - it has worked!

  • JosAngel94
    JosAngel94

    @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.

    image.png

  • Vinay VaradarajM
    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:

    Screenshot 2023-03-09 at 10.22.04 AM.png

    In your case:

    Screenshot 2023-03-09 at 10.22.52 AM.png

    Regards,

    vinayvm

Categories