L2 Model Building - Sprint 1 - 1.4.3.1 Create SYS12 SKU Details Module

LucaB
LucaB
in Academy Discussions

Hello, I am stuck on this: when importing the CSV file to populate the newly created above module I got an error I'm struggling with.

This is the SYS12 SKU Details Module created as requested in the training exercise:

image.png


this is the CSV file to import

image.png

this is the message I got after importing the file

image.png


It seems that the codes into the CSV file I'm importing are wrong despite the flat lists "Products Flat"  and "Location Flat" are already populated with the same codes:

image.png


image.png

Unless the flat lists are incorrectly populated…
Could someone help me understand what I'm doing wrong?

Many thanks in advance!
Luca

Best Answer

  • Dikshant
    Dikshant
    edited January 2 Answer ✓

    IN SYS12 Line Items tab, you can unmap the product code mapping. As You can make it formula-driven, like PARENT(ITEM('P3 SKU'))

Answers

  • Dikshant
    Dikshant

    Module does not have SKU dimension. Add the dimension from here:

    image.png

  • LucaB
    LucaB

    Thank you! I added the missing dimension.
    However, I'm still having an issue with probably doing something wrong in the import:

    image.png

    My mapping seems fine:

    image.png
    image.png
    image.png

    but I do not understand why the Location code "lands" in the Product field and the Product code into the Location field.

    Thanks

  • LucaB
    LucaB

    Thank you

Categories