Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / The value ,G/L Accoun...
Microsoft Dynamics NAV (Archived)

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

(0) ShareShare
ReportReport
Posted on by Wahyudi Purnama 40

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

  • Verified answer
    Wahyudi Purnama Profile Picture
    Wahyudi Purnama 40 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    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.

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    Wahyudi Purnama  ,

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

  • Wahyudi Purnama Profile Picture
    Wahyudi Purnama 40 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    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

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    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.

  • Wahyudi Purnama Profile Picture
    Wahyudi Purnama 40 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    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.

  • Wahyudi Purnama Profile Picture
    Wahyudi Purnama 40 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

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

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    Dear Wahyudi Purnama ,

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

  • Luc van Vugt Profile Picture
    Luc van Vugt on at
    RE: The value ,G/L Account,Item,,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

    Hi Wahyudi,

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans