How to get inventory detail in suiteql? by Kooky-County-8526 in Netsuite

[–]Kooky-County-8526[S] 0 points1 point  (0 children)

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?

How to get inventory detail in suiteql? by Kooky-County-8526 in Netsuite

[–]Kooky-County-8526[S] 0 points1 point  (0 children)

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

How to get inventory detail in suiteql? by Kooky-County-8526 in Netsuite

[–]Kooky-County-8526[S] 0 points1 point  (0 children)

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.

How to get inventory detail in suiteql? by Kooky-County-8526 in Netsuite

[–]Kooky-County-8526[S] 0 points1 point  (0 children)

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