Pease help me understand why am able to see averagecostmli in NetSuite but not in NSAW. NSAW has a different rate which is not giving the correct inventory value. How can I get averagecostmli in NSAW to use for calculations?
NS query:
sum (ail.quantityonhand * ail.averagecostmli) AS total_inventory_value
FROM
inventoryitemlocations ail
JOIN
Item item ON item.id = ail.item
WHERE
ail.location=523 -- 0
select sum (ail.quantityonhand * ail.averagecostmli) AS total_inventory_value
FROM
assemblyitemlocations ail
JOIN
Item item ON item.id = ail.item
WHERE
ail.location=523 -- 23796189.95