×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

You cannot insert a row

You cannot insert a row

You cannot insert a row

(OP)
I'm getting an error  "You cannot insert a row" in sale transaction entry window as a end user and a sa user. This only happens when I am trying to add an item in between an existing order that is still "open" status from an order that's been created through eConnect. I've created an sales order manually and attempted to do the same. It actually allows me to insert no matter who I'm logged in as.
Any suggestion on why this will happen?  

RE: You cannot insert a row

This blog post by Mariano Gomez should help understand why you are not able to insert rows: http://dynamicsgpblogster.blogspot.com/2008/07/scrolling-windows-and-line-sequence.html

Inserting rows should not be dependent on user security.  Is it possible that your eConnect import is specifying line sequence numbers instead of letting them default?

Victoria Yudin
Dynamics GP MVP 2005 - 2011
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

RE: You cannot insert a row

(OP)
It it a good article and I do understand the concept behind it now. But is it only the numbering restriction? I haven't tested this or checked this but if the numbers are generated with 16384 and so on, I shouldn't have trouble inserting a new line in between if the order only has 2 or 3 lines. So is there GP restriction for those particular eConnect order/line items that will prevent from inserting a row?

RE: You cannot insert a row

This will be controlled by your eConnect import, not GP.  If you pass in values for the line number sequence as part of your import, that's what will be used.  Otherwise, if you're not passing them in, they will default to 16384, 32768, etc.  

There is a related thread on the GP Community Forum that you might want to keep an eye on or chime in on: https://community.dynamics.com/product/gp/f/32/t/68908.aspx.

Victoria Yudin
Dynamics GP MVP 2005 - 2011
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

RE: You cannot insert a row

(OP)
Thanks for the suggestions. I followed the community.dynamics.com and found out that the eConnect actually incremented by 1 for the sequence number.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close