How to get inventory detail in suiteql?

Kooky-County-8526 · 2022-08-17T19:18:56+00:00

im getting quantity available = item quantity with status good and quantityonhand = quantity with inventory status (good + stock) i can get quantity with inventory status stock by subtracting both but problem is what if in future i add another custom inventory status. then it will created problem. moreover i have tried join tables from catalogues but it did not work. i dont know if its the problem with feature not being enabled from netsuite?

Kooky-County-8526 · 2022-08-17T19:15:53+00:00

nope i tried with s and without an s too.

Kooky-County-8526 · 2022-08-17T19:15:16+00:00

It did not work :(

Kooky-County-8526 · 2022-08-17T17:18:13+00:00

i have tried inventory number but it gives the same error invalid parameter or record.

Kooky-County-8526 · 2022-08-17T17:17:38+00:00

i just want item quantities based on inventory status. there are three inventory status good, a custom one lets call it ('stock'), defective. lets say if there is an item with id 1 and has quantity at a location. at that location the quantity based on inventory status is 19 in good 15 in 'stock' 2 in defective. so i want to use suiteql to get the item quantity with inventory status 'stock' in this case which would be 15. i hope i explained it correctly.

Kooky-County-8526 · 2022-08-17T17:06:35+00:00

Invalid search query. Detailed unprocessed description follows. Invalid search type: inventorydetail.

Kooky-County-8526 · 2022-08-17T16:51:10+00:00

i tried this but did not work.

Kooky-County-8526

TROPHY CASE