ODBC Query Current Quantity On Hand per Location from Report Builder

Open a Custom Current Inventory Snapshot by navigating to Reports > Inventory/Items > Current Inventory Snapshot > Customize. The left panel displays a Quantity to Order folder which contains suggested fields to be displayed in the report.

This sample ODBC query will return the Current Quantity on Hand, Average Cost, Current on Hand Value and Reorder Point of items based on specific location.

SELECT LOCATIONS.FULL_NAME, ITEM_LOCATION_MAP.ITEM_ID, INVENTORY_ITEMS.FULL_NAME,
ITEM_LOCATION_MAP.ON_HAND_COUNT,ITEM_LOCATION_MAP.AVERAGE_COST,
ITEM_LOCATION_MAP.ON_HAND_VALUE,ITEM_LOCATION_MAP.REORDER_POINT
FROM "Full Access".ITEM_LOCATION_MAP
INNER JOIN "Full Access".INVENTORY_ITEMS ON ITEM_LOCATION_MAP.ITEM_ID = INVENTORY_ITEMS.ITEM_ID
INNER JOIN "Full Access".LOCATIONS ON ITEM_LOCATION_MAP.LOCATION_ID = LOCATIONS.LOCATION_ID
WHERE LOCATION_ID = [LOC_ID]

*LOC_ID = Internal ID of  location