Level 2-Conclusion: Import Shipping Expenses into OTH01 Module

Gharbali

Hello,

I am trying to import data from my Supply chain model to FP&A model however, I am getting some errors.

Here is the source module (from Supply chain model). The timecard is "Month" for shipping cost

And here is the target module (from FP&A model). The time card is "Month".

I am trying to import the shipping cost data from Supply Chain into FP&A and in the time section I selected "Match names" and "Match items only" :

but I am getting this error: " invalid date or timecard identifier: Line items"

What I am doing wrong and how can I correct it?

Thanks,

Farhad G.

Gharbali

Seyma,

There was no such an option " Column2: Time" in the drop-down. However, what I did, I pivoted the source module and saved a new a view and it help me to select the "Time" as a column and proceed with importing the data.

Thank you.

seymatas1

Hi Farhad,

Your time mapping is correct.
Can you share a screenshot of your main mapping tab?

kakasiu0330

Hi Farhad,

Can you please double-check how time is formatted in the two modules? It can be Jan 21 in one and Jan 21 in the other one, for example. Also, please share a screenshot of your data and your main mapping tab as well. Thanks.

Gharbali

Hello @seymatas1 and @kakasiu0330 ,

Thank you for assisting me here. Please see below photos:

Time setting in Supply Chain model:

Time setting in FP&A model:

And her is the mapping screen:

seymatas1

Instead of Column Headers try to choose Column 2: Time.