level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

Hi Community,

 

I am getting an error when i am running process to import historic volumes, beginning inventory and shipping metrics from my data hub model. i think it is due to list used in both modules. In datahub module according to instructions i have used " SKU flat list" and in supply chain module  "P3 SKU" list is used. codes are different in both the lists. what should i do in this situation?

Screenshot (50).png

Best Answer

  • Misbah
    Answer ✓

    @saranshsaini 

     

    In your import mapping...

     

    instead of mapping "Fixed Line item" to DAT03 Historical Volume Line Item  use "Column 1"

     

    That should fix it

    Misbah

Comments

  • @saranshsaini 

     

    Ah I see what do you mean.

     

    If you look closely they are different because one is for Products and another for SKUs.

     

    For example in your screenshots P3 SKU of Level 2 Model : all these codes are for Products and not for SKUs which looks right because all the SKU's have failed to Import.

     

    Now go back to your data hub and see if your source module view looks like this. 

     

    Misbah_0-1614326039588.png

    If it is then check the Import mapping . Should be like this

    Misbah_1-1614326151155.png

     

    Hope this helps

    Misbah

     

     

  • Hey Misbah! My system module and mapping are exactly like this

  • @saranshsaini 

     

    Care to share your mapping screenshot.

  • Hey Misbah! Thanks for help previous issue is now resolved. But now there is a new error I`m attaching screenshots.

  • @saranshsaini There's something odd about  your P3 SKU list. P3 SKU Flat looks okay though. Your DAT03 Volumes module should be dimensioned with Accounts Flat as well. Do you have that set up?

    P3SKU002.png

     

    Minor issues but I suggest you reload P3 SKU with the correct item values. Should look like this:

    P3SKU001.png