Is there a way to create a custom field that point...
# suitescripts
screnshaw
02/07/2022, 8:31 PMIs there a way to create a custom field that points to the Item Fulfillment Status and return the A, B statuses?
The status on item fulfillment returns a letter whereas the status on my custom record returns a number id. ðŸ˜
b
battk
02/07/2022, 8:37 PMwrite code to do the lookup
battk
02/07/2022, 8:37 PMyou can probably hardcode it if you really wanted to
s
screnshaw
02/07/2022, 8:37 PMYeah, that's what I have. I"m just having to go off of text.
The custom field returns something like 132 whereas the item fulfillment status returns 'A'
screnshaw
02/07/2022, 8:38 PMIt messes up their stuff too, because I need the field to filter a custom record based on the shipping status. Netsuite's out of the box solution doesn't work i believe because the IF returns A whereas the custom field (list/record) returns 132
b
battk
02/07/2022, 8:39 PM132 should be shipped
s
screnshaw
02/07/2022, 8:39 PMit may be 130
screnshaw
02/07/2022, 8:40 PMSo A != 130 is the proble
b
battk
02/07/2022, 8:40 PMand it cant return C, thats not unique enough, multiple transactions have a status with the id C
s
screnshaw
02/07/2022, 8:41 PMSo there's basically no way, without text, to do this because rec.getValue("shipstatus") only returns a letter
b
battk
02/07/2022, 8:41 PMhardcode the conversion from A to 130 and C to 132
s
screnshaw
02/07/2022, 8:42 PMNetsuite lol. That's the stuff that's a little ridiculous.
i
Israel Gonzalez
02/08/2022, 4:29 AMWould .getText instead of .getValue work?
s
screnshaw
02/10/2022, 12:33 PMThat's what I ended up doing. Don't want to use get text, but I guess it's not the end of the world in this case to do that