I'm running the following SuiteQL
select Item.Quan...
# suiteqls
Simon
12/18/2021, 11:35 AMI'm running the following SuiteQL
select Item.QuantityOnHand, Item.QuantityCommitted, Item.QuantityAvailable,Item.QuantityOnOrder
from item where itemtype = 'Assembly' and id = 68412
And I'm getting the following error
Copy code
Search error occurred: Field 'QuantityAvailable' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityCommitted' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityOnHand' for record 'item' was not found. Reason: REMOVED - Field is removed
Field 'QuantityOnOrder' for record 'item' was not found. Reason: REMOVED - Field is removedr
redfishdev
12/18/2021, 1:12 PMSELECT item, location, quantityavailable, QuantityCommitted, QuantityOnHand, QuantityOnOrder FROM inventoryitemlocations
redfishdev
12/18/2021, 1:12 PMthis may be what you are looking for
redfishdev
12/18/2021, 1:15 PMor if you have multiple locations and need sums
redfishdev
12/18/2021, 1:15 PMSelect Item.id, QA, QC, QOH, QOO
from item left outer join
(SELECT item, SUM(quantityavailable) as QA, Sum(QuantityCommitted) as QC, Sum(QuantityOnHand) as QOH, SUM(QuantityOnOrder) as QOO FROM inventoryitemlocations group by item) as itemCounts
on (itemCounts.item = item.id)
order by Item.Id
redfishdev
12/18/2021, 1:53 PMPer Tim D, what features you have on your account determine tables and columns available so what is above may or may not work for you.
s
Simon
12/19/2021, 2:10 PMthanks a lot
6 Views