Microsoft Dynamics NAV (Archived)

The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

(0) Share

Report

Posted on by Wahyudi Purnama

Dear All,

I've got a trouble here, hope you can help me.

I'm just about to import "Purchase Line" using data migration in nav classic, but the result is not as expected.

Here is the error

2570.1.png

8053.3.png

I've tried to change in excel on "Type"/"Document Type" columns become "Item" or "2" the program read it as the same thing as "Item" but the error result still same.

6303.2.png

Hope you can help me, have a nice day

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Luc van Vugt on at

Like (0)

Report

Hi Wahyudi,

What is exactly the error (as I do not see any error message or something alike)? What are you expecting?

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Dear Wahyudi Purnama ,

Did you check , ItemJournalLine & ReservationEntry properly , i think its might be missing some fields

Was this reply helpful? Yes No
Wahyudi Purnama 40 on at

Like (0)

Report

Hi Luc,

I'm gonna import my data using data migration for table "Purchase Line"

but the result is this "The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid."

The data I used is from export data migration and without edited by anyone ..

I'm expecting everything is gonna fine, but I dunno why it's error ..

Maybe I'm going to use data port instead data migration..

Was this reply helpful? Yes No
Wahyudi Purnama 40 on at

Like (0)

Report

Dear Maneesha,

Thanks for your support, I'm check it already ..

but the purchase line that I import from data migration is from excel that exported by data migration in old database ..

Sorry for my bad spoken on english.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Did you try importing one line ? do you get same error. Try exporting the data from the current company and then use that excel file to replace with this data.

Was this reply helpful? Yes No
Wahyudi Purnama 40 on at

Like (0)

Report

Dear suresh, yes I try it but still failure ..

I use the dataport, since I didn't find any solution ..

hope this won't happened again in future

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

Wahyudi Purnama ,

What is the exact error message you are getting , can we see it ?

Was this reply helpful? Yes No
Verified answer

Wahyudi Purnama 40 on at

Like (0)

Report

Maneesha De Silva,

I'm really glad for your help until now, but I already give up and import using dataport and this method were success.

the error that come is like the question I ask:

The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

Was this reply helpful? Yes No