Hello ladies and gens, I'm trying to get custom it...
# suitescript
b
Hello ladies and gens, I'm trying to get custom item number fields with SuiteQL but i can't seem to access these records. I can see the memo: "Test Memo" in the results but not my custom fields. I do have edit level for the permission of my role...
s
try select that field by name rather than
*
b
Hello Shawn, I’ll get a field not found error if I select by using the field id.
This is the error i encounter when trying "InventoryNumber.custitemnumberlastcyclecountdate"
I wonder if its a permissions issue?
s
that could be, or if that field is a calculated field or actually comes from somewhere else (i.e. if it's not stored on the lot number record in the first place, just shown on that form)
b
Hmm I just check in the records catalog, and it seems that none of my itemnumbercustfields are found. Has anyone been able to query these custom fields?