drathod
Contributor

Level 2 Model Building conclusion - Import

Hi,

I am having some trouble importing the Shipping cost export into the OTH01 Non-Employee Expenses module. I am getting the below error. I have also provided additional screenshots. Can someone please help me on where I may be going wrong?

I'm so close to finishing up Level 2. this is one of the things that is tripping me up.

drathod_0-1627072060511.png

drathod_1-1627072131641.png

drathod_2-1627072149515.pngdrathod_3-1627072169717.png

drathod_4-1627072458164.png

drathod_5-1627072479208.png

5 REPLIES5
ashish.banka
SuperContributor

@drathodIt seems that the issue is with E1 Departments. It seems you have selected "All Departments" which is top level due to which you might be getting error. If you are using "Fixed Item" in the mapping tab, you need to select a single child list item from E1 Departments in place of "All Departments" which seems to be top level.

AB

drathod
Contributor

@ashish.banka

I am still getting an error when importing. Does it have something to do with the date?

drathod_0-1627265261830.png

drathod_1-1627265311415.png

ashish.banka
SuperContributor

@drathodYou might be right. Please check the date / time format of the source module and the target module. If the formats are different, you can map the source time format with target time format using the Time tab.

ashishbanka_0-1627276589656.png

AB

drathod
Contributor

@ashish.banka

I got most of it fixed. just got an error regarding the code. Is there something special i have to do when it comes to having that subsidiary view?

drathod_0-1627312417020.png

ashish.banka
SuperContributor

@drathodThat's great. For the errors which you are getting, it seems that you have both G3 Location as well as its Code in the Saved View. I guess while importing you can ignore one of them in the mapping tabs.

AB