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

Screenshot_(51)_99245.png

Screenshot_(52)_99245.png

Screenshot_(50)_99245.png

Accepted answers

Misbah

@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

All comments

Misbah

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

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

Hope this helps

Misbah

saranshsaini

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

Misbah

@saranshsaini

Care to share your mapping screenshot.

saranshsaini

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

Screenshot_(59)_99291.png

Screenshot_(61)_99291.png

Screenshot_(60)_99291.png

JaredDolich

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

Misbah

@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

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?