We have normal items and child items which our customer can place orders, eg
widget1
widget1 : widget1-red
widget1 is the parent item which is not colored
widget2 is same as widget1 which is red in color. For inventory management purposes, we make widget2 as child of widget1
1) customer's sales order will have part# as "widget1-red" instead of "widget1 : widget1-red"
2) customer can also order "widget1"
When we print out Packing List/Invoices, Netsuite will default to :
"widget1" qty 10
"widget1 : widget1-red" qty 20
As this will cause confusion to our customer, we want it to be printed as
"widget1" qty 10
"widget1-red" qty 20
I have created custom fields to remove the ":" but it didn't work. What I have done is this :
1. "Customization", "List, Records & Fields", "Transaction Column Fields", New
2. Label = "Ordered Part #", Type = "Free Form Text", Store Value = off
3. Under "Validating and Defaulting" tab, Formula = on
4. Default Value = CASE WHEN {parentitem} IS NULL THEN {name} ELSE SUBSTR({name},INSTR({name},':')+2) END
When I try to print out under Packing List with the custom field "Ordered Part #", the error is "ERROR: Field ‘parentitem’ Not Found"
I have tested the same formula in a saved search and it worked, except that the field name is {parent} instead of {parentitem}
Any thoughts?