Have you look at ITMWRH representation.

This is the same representation used on Read-only page called Product Warehouses, which is under Read-only pages, Common Data, Product warehouses

This representation on detail facet has some quantities

I have looked at that representation, yes, but it does not seem to contain data that matches what I'm seeing in the front-end. The sample data has a product BMS001 with 460 quantity at site AO012, but that data cannot be found by querying the ITMWRH representation.

I received an email from Sage support yesterday regarding this issue:

"There is no standard template available for products with location and QTYs on hand that matches your request. Instead you need to create a custom template with the requested information. The new/modified template should have the STOCK table in it with the requested fields for QTY and Location. The STOCK table has the item reference, location and location type, QTY, LOT, SATUS among other fields.

If you need assistance creating new templates, you might want to contact your partner or Sage Professional services."

So it looks like inventory quantities are not available through the standard API, which is absolutely insane.

Thanks for your help anyway, I'll have to figure something out with the client because this is now becoming something that future clients will need to set up in advance of our integration. Terrible.

I have looked at that representation, yes, but it does not seem to contain data that matches what I'm seeing in the front-end. The sample data has a product BMS001 with 460 quantity at site AO012, but that data cannot be found by querying the ITMWRH representation.

I received an email from Sage support yesterday regarding this issue:

"There is no standard template available for products with location and QTYs on hand that matches your request. Instead you need to create a custom template with the requested information. The new/modified template should have the STOCK table in it with the requested fields for QTY and Location. The STOCK table has the item reference, location and location type, QTY, LOT, SATUS among other fields.

If you need assistance creating new templates, you might want to contact your partner or Sage Professional services."

So it looks like inventory quantities are not available through the standard API, which is absolutely insane.

Thanks for your help anyway, I'll have to figure something out with the client because this is now becoming something that future clients will need to set up in advance of our integration. Terrible.

Try STKCNSSDIM representation, it shows 460 qty for AO012.