Probably LineSeqNo.

tried that. it didn't work.

What you need to do is look at the data in the  works table. You do this by previewing a sales order and the going and finding the file created. It will look like this SO_SalesOrderWrkBNH051708323245.M4T  where BNH is the user code and the rest is a time stamp.  Rename the SO_SalesOrderWrk.M4T to backup and then delete the user code and time stamp. Then pull the data with either Excel or Access and see how system builds the file.

My mistake. you were correct. I was looking at the "line key" not the "Line SeqNo" Thanks.

Hi KathyW, happy to see that the community helped you figure out a solution!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey