level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

saranshsaini
Occasional Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

@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

View solution in original post

6 REPLIES 6
Misbah
Moderator

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

@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

 

 

saranshsaini
Occasional Contributor

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

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

Misbah
Moderator

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

@saranshsaini 

 

Care to share your mapping screenshot.

saranshsaini
Occasional Contributor

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

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

Misbah
Moderator

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

@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

View solution in original post

JaredDolich
Moderator

Re: level 2 Sprint 2.3.9.1 Import data into DAT03 Historic Volumes module

@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

 


Jared Dolich