Sage 100

Sage v4.5 Advanced - Client somehow wiped out GL account numbers for about 200 lines in open sales orders. What are the pitfalls in trying to add these accounts back in via a VI job. I know you are supposed to be able to use the line numbers to accomplish this but I've never done this. Last I want is another 200 lines added to the SO detail table..... Thoughts? Worth the effort or do I tell them that there is no way to do this and they will just have to key the accounts?

I would try using the line key and line sequence no and of course a back up. I think that should work.

Make sure it's a project first - because under the customer doctrine of ""you touched it you owned it - even if it's a freebie"" you'll get stuck poking around here potentially for a long time. BTDT.

I am pretty sure that it can be done in BOI. I have not tried in VI for several years as it used to just double the lines. Good case for SQL. 2 minute problem there....

Well, it DOES work using the line code!!!!! Score one for Sage and BOI. Just wish it wasn't so far between Sage scoring...........

Nice answer @Sperry...

If you do a Replace on the LineKey (not Assign or anything else) you should be able to update the lines (instead of inserting new ones) with V/I. It's same principle as getting the right LineKey with BOI. Test company first of course.