[roberth]

I am trying to pull average cost from an inventory item. The record shown in the UI has an average cost populated, viewing it via the &xml=T param also shows average cost, yet when I get the record via web services or even via SuiteAnalytics Connect the average cost is showing null.

How can I source this in?
This is a cached copy. Click here to see the original post.

[ktarog]

Hi,

For the Web Services, I was able to get the Average Cost using the methods, get and search. It was returning the value as shown on the item record.

As for SuiteAnalytics Connect, the field is to be computed as shown on the query below:

SELECT Sum(item_location_map.average_cost)FROM Administrator.item_location_map item_location_mapWHERE (item_location_map.item_id=140)

Hope this helps.

[roberth]

Thanks ktarog,

The query you provided does not match our item record though – I also assume you meant to use the AVG function, not sum to calculate the average cost?

[Author]

Posts