Sage 100

I have a client that upgraded from 4.3 to 2014. They had a VI job they were using ""change next on"" but with 2014 I can't get it to work with Next. They have a column in a spreadsheet that S/O invoices need to be grouped on regardless of other header records that are imported. The field on the spreadsheet is up to 36 characters - Any ideas?

The Next is now automatic when it detects a change on the Header fields. I'm not sure if a UDF on the Header will trigger the Next but you can try creating a UDF and importing the 36 character field into that. If not, maybe you can truncate the 36 to 15 and import to the Customer PO field or maybe the comment field. I know the PO triggers a Next because I use it everyday.

Thanks, that worked. There was a post on Sage City that alluded to using the column in the next operator in VI which worked up to a certain amount of characters.

Glad it worked, just curious, did you end up creating a UDF or using one of the existing fields on the Header?

Created a new UDF. They already use comment and PO for something else.