Error msg

Navision Articles

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Verified) This post has 1 verified solution | 14 Replies | 4 Followers

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri posted on Dec 4, 2008 6:25
How helpful was this post/question? Please rate here:

Hi All,

 

when I want to open the  Purchase Line (ID 39) table ,it throughs an error msg.

is this a bug of  Nav 5.0 Sp1 In Version??

How can I fix it ??

 

Technical Consultant

Solution (Verified) Verified Solution

Top 10 Contributor
Male
1,104 Posts
25,347 Points
Joined: May 6, 2008
Last Online:
Mar 21, 2010 14:57
Location: Dublin
Moderator
Solution (Verified) DaveT replied on Dec 10, 2008 22:45
How helpful was this comment/solution? Please rate here:
Verified by Erik P. Ernst
Hi, It look to be as the field "Sub. order No." is a custom field added to the pruchase line table. I suspect it is type code and length 10 and is a flowfield. The flow field is returning a value of greater than 10 and thus generating the error. Again I suspect that this flowfield is meant to return an order number which is code 20. If I'm correct in the assumptions then you need to increase this field to code 20.

Dave Treanor

Dynamics Nav Add-ons
www.simplydynamics.ie/Addons.html

Please:
1. Use a meaningful title.
2. Give as much detail as possible.
3."Verify Solution" to the post that help you solve your problem.
4. Fill out your Tags - it will help other people.
5. N.B. Don't be afraid to ask - we all had to learn and are still learning Wink

All Replies

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri replied on Dec 4, 2008 6:32
How helpful was this comment/solution? Please rate here:

What will be the best ?? I want to know...

1. If I restrict to provide the String Length more than 10 into the Document No. field of the

    Purchase  Line.

2. If I increase the Length of the Sub. Order No. field of the Delivery Challan Header table.

Technical Consultant

Top 10 Contributor
Male
5,053 Posts
94,835 Points
Joined: Oct 1, 1995
Last Online:
Mar 21, 2010 23:28
Location: Copenhagen, Denmark
DynamicsNAVMVP
Moderator
SystemAdministrator
Erik P. Ernst replied on Dec 10, 2008 21:25
How helpful was this comment/solution? Please rate here:

I don't believe that it's a problem in NAV 5.0, as the fields you are referring to are not standard fields and neither is the Delivery Challan Header table (unless they are part of you localized country version).

So it's difficult to say exactly what's wrong.

But always make sure that two linked fields should be of the same type and length.

 

Best regards,
Erik P. Ernst

DUG’s Admin's Blog

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Top 10 Contributor
Male
1,104 Posts
25,347 Points
Joined: May 6, 2008
Last Online:
Mar 21, 2010 14:57
Location: Dublin
Moderator
Solution (Verified) DaveT replied on Dec 10, 2008 22:45
How helpful was this comment/solution? Please rate here:
Verified by Erik P. Ernst
Hi, It look to be as the field "Sub. order No." is a custom field added to the pruchase line table. I suspect it is type code and length 10 and is a flowfield. The flow field is returning a value of greater than 10 and thus generating the error. Again I suspect that this flowfield is meant to return an order number which is code 20. If I'm correct in the assumptions then you need to increase this field to code 20.

Dave Treanor

Dynamics Nav Add-ons
www.simplydynamics.ie/Addons.html

Please:
1. Use a meaningful title.
2. Give as much detail as possible.
3."Verify Solution" to the post that help you solve your problem.
4. Fill out your Tags - it will help other people.
5. N.B. Don't be afraid to ask - we all had to learn and are still learning Wink

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri replied on Dec 11, 2008 6:48
How helpful was this comment/solution? Please rate here:

Hi All,

 

Thanks to you both.

If I'm wrong than suggest me please.

The Sub. Order No. is a field of the Delivery Challan Header table.

and I'm geting error msg for the Length problem.

IF I increase the field length it will create other problem but I dont know where will be problems arised ??

 

Technical Consultant

Top 10 Contributor
Male
1,104 Posts
25,347 Points
Joined: May 6, 2008
Last Online:
Mar 21, 2010 14:57
Location: Dublin
Moderator
DaveT replied on Dec 12, 2008 17:47
How helpful was this comment/solution? Please rate here:

Hi

I still think the error is the the pruchase line table as opening this table if when you get the error.  I suspect it is a custom field doing a lookup to the Delivery Challan Header table.

Dave Treanor

Dynamics Nav Add-ons
www.simplydynamics.ie/Addons.html

Please:
1. Use a meaningful title.
2. Give as much detail as possible.
3."Verify Solution" to the post that help you solve your problem.
4. Fill out your Tags - it will help other people.
5. N.B. Don't be afraid to ask - we all had to learn and are still learning Wink

Top 10 Contributor
Male
2,054 Posts
27,330 Points
Joined: Jan 23, 2004
Last Online:
Mar 21, 2010 21:49
Location: Howell, MI
DynamicsNAVMVP
Moderator
DenSter replied on Dec 12, 2008 22:33
How helpful was this comment/solution? Please rate here:

I would agree that there is some sort of link between the two tables where the data types have not been set the same. I'm not convinced that simply increasing a field length is the right solution.

What I would like to know is how are you opening the table?

Not Ranked
21 Posts
250 Points
Joined: Jan 18, 2008
Last Online:
Oct 9, 2009 11:57
Shibs replied on Dec 19, 2008 8:24
How helpful was this comment/solution? Please rate here:

Hi DenSter,

     I am also facing the same issue. I am getting this sort of error when i run the purchase line table manually.

Thanks

Shibs

Top 10 Contributor
Male
5,053 Posts
94,835 Points
Joined: Oct 1, 1995
Last Online:
Mar 21, 2010 23:28
Location: Copenhagen, Denmark
DynamicsNAVMVP
Moderator
SystemAdministrator
Erik P. Ernst replied on Dec 19, 2008 10:04
How helpful was this comment/solution? Please rate here:

Is this part of the Indian localization of Dynamics NAV?

Best regards,
Erik P. Ernst

DUG’s Admin's Blog

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Top 10 Contributor
Male
2,054 Posts
27,330 Points
Joined: Jan 23, 2004
Last Online:
Mar 21, 2010 21:49
Location: Howell, MI
DynamicsNAVMVP
Moderator
DenSter replied on Dec 19, 2008 13:43
How helpful was this comment/solution? Please rate here:

Have you run the debugger while opening the table?

Seems to me that there is a bug in your version. As nobody is answering whether this is in the standard localization it's difficult to tell where to go for a solution. If it is in the standard localization then call Microsoft for support. If it is a 3rd party solution, call the company that created the solution. I am sure you are not the only one that has this problem, and there is probably a quick fix for it.

Top 10 Contributor
Female
1,526 Posts
15,251 Points
Joined: Feb 26, 2001
Last Online:
Mar 17, 2010 18:46
Location: Italy
DynamicsNAVMVP
Moderator
Anna Perotti replied on Dec 19, 2008 17:46
How helpful was this comment/solution? Please rate here:

DenSter:

Have you run the debugger while opening the table?

Alas! If the error message (as we all suspect, I think) comes from a TableRelation or CalcFormula property, debug will show nothing. Sad

 

Anna Perotti MS Dynamic Nav MVP

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri replied on Jan 28, 2009 12:32
How helpful was this comment/solution? Please rate here:

Yeap. This is a part of Indian Localization.

 

Technical Consultant

Top 10 Contributor
Male
5,053 Posts
94,835 Points
Joined: Oct 1, 1995
Last Online:
Mar 21, 2010 23:28
Location: Copenhagen, Denmark
DynamicsNAVMVP
Moderator
SystemAdministrator
Erik P. Ernst replied on Feb 26, 2009 23:25
How helpful was this comment/solution? Please rate here:

Hi Subrata,

If you feel that one of the replies answered your question, then please click on the verify solution button next to the post. This way we know that the thread is closed and it's your way to credit the person who helped you.

Thanks.

Best regards,
Erik P. Ernst

DUG’s Admin's Blog

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Top 50 Contributor
Male
363 Posts
5,295 Points
Joined: Oct 29, 2008
Last Online:
Mar 17, 2010 14:38
Location: Kolkata
subrata.bauri replied on Mar 2, 2009 7:30
How helpful was this comment/solution? Please rate here:

Sorry for this.

I have extended to 20 and now it's solved.

Technical Consultant

Top 10 Contributor
Male
1,415 Posts
21,188 Points
Joined: Aug 16, 2000
Last Online:
Mar 21, 2010 23:29
Location: Vienna, Austria, Europe
Moderator
Sponsor
Thomas Brodkorb replied on Mar 2, 2009 9:15
How helpful was this comment/solution? Please rate here:

subrata.bauri - Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

 

Thomas Brodkorb


Dynavics & DynamicSolutions Based on the improved budget situation is light at the end of the tunnel is now permanently switched on.

 

Don't forget to the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

 

Page 1 of 1 (15 items) | Get this RSS feed | Bookmark and Share