This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Assuming that's non-configurable, you can set a custom colum on the item sublist then use a UserEventScript to set that colum for each item. The exact workings of that depend on what you want to do. Usually, all line items are at the same status at the same time so where is the benefit of having it per item?

On the last line, line items can have different status right? Some items might be back ordered, some might be fulfilled. Am I wrong?

there's a backordered column with a numerical value

Guess you can add a status text column if you want and use a script to populate the value.

That mean we have to derive it using quantity fileds only? I am looking there is something like partially fulfilled / completed instead of calculating each time :)

Yeah in transaction record definition item sublist have mulitple quantity fields (float) as you mentioned

Yes, it's derived from those quantity fields

fulfilled : 1 backordered : 2 would indicate partially fulfiled :slightly_smiling_face: