I want to select a Non Inventory item, how can I d...
# suiteqls
Simon
08/30/2024, 1:26 AMI want to select a Non Inventory item, how can I do it ?
select id from ???? non-inventory ?
n
Nathan L
08/30/2024, 1:41 AMSelect id
From item
Where type = “noninv”
Nathan L
08/30/2024, 1:41 AMNot entirely sure about the string for non inventory in the where clause.
But yeah you just grab from the item table
s
Simon
08/30/2024, 1:18 PMI have another question, where can I find the file name ? I mean 'invtpart' is TYPE.INVENTORY_ITEM,
Assembly, TYPE.ASSEMBLY_LINE,
NON_INVENTORY_ITEM,
etc...
n
Nathan L
08/30/2024, 1:23 PMIm sure there is a list somewhere, but this is what i always do to figure it out. Its quick and easy
Nathan L
08/30/2024, 1:23 PMOthCharge
Markup
Service
NonInvtPart
Subtotal
InvtPart
Description
s
Simon
08/30/2024, 4:09 PMgreat but when it's type to update, we have to use
TYPE.INVENTORY_ITEM,
TYPE.ASSEMBLY_LINE,
NON_INVENTORY_ITEM,
.
.
where is that list ?
n
Nathan L
08/30/2024, 4:48 PMs
Simon
08/30/2024, 6:31 PMExcellent. Thank you very much
🫡 1
7 Views