Hello Netsuite Community!
We're currently running into an issue accessing line numbers in a list, in order to sort them properly in a separate suitelet.
For context, we have a custom record that allows adding notes at the bottom, where these notes are also custom records of their own. We then use the information within the main record and the notes records to make a PDF file using an advanced PDF template.
We use this system for service report custom records, where then employees can add notes regarding to the service provided and then a report with all the info can be printed, using that advanced PDF template.
The notes custom record is set up where it works as a list, and it allows reordering when the main record is in edit mode. This then translates properly onto the PDF that gets created with the advanced PDF template.
The issue that we are having is that we have a separate suitelet that allows us to consolidate several service reports into a single one and then it displays everything using inline HTML. When pulling the note records using a suitescript saved search (result.getValue(result.column[x])), the only way it can order these is by alphabetical order ascending or descending, which results in the notes being in the wrong order.
We tried accessing the {linenumber} field through a saved search but it seems to be inaccessible that way.
Is there a way we can access the line numbers in a list so that we can use this to order list items in a suitescript?
Thanks in advanced!