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?
_99245.png "Screenshot (50).png")
Best Answer
-
In your import mapping...
instead of mapping "Fixed Line item" to DAT03 Historical Volume Line Item use "Column 1"
That should fix it
Misbah
1
Answers
-
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.
If it is then check the Import mapping . Should be like this
Hope this helps
Misbah
0 -
Hey Misbah! My system module and mapping are exactly like this
0 -
0
-
Hey Misbah! Thanks for help previous issue is now resolved. But now there is a new error I`m attaching screenshots.
0 -
@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?
Minor issues but I suggest you reload P3 SKU with the correct item values. Should look like this:
0
