Hello! I'm trying to dredge data out of NetSuite using SuiteQL, and it's going great except for these two fields -- Quantityonorder and Quantityavailable. I can use both in an Item saved search by way of {quantityonorder} and {quantityavailable}, but in SuiteQL these fields give an error. Here is my query:

    SELECT 
        Item.id,
        Item.itemid,
        Item.displayname,
        Item.cost,
        Item.upccode,
        Item.totalquantityonhand,
        Item.quantityonorder,
        Item.quantityavailable
    FROM 
        Item
    WHERE
        Item.isinactive = 'F'

This works perfectly except for the last two columns, which return the error: "Field 'quantityavailable' for record 'item' was not found. Reason: REMOVED - Field is removed". I believe it is the same issue mentioned at the bottom of this article under the "Multi-Location Inventory" heading, which states that it's the result of having Multiple Locations enabled: