Dear All,
I am a BI architect and i don't have much knowledge of X++ methods. I need to calculate the Average Cost Price that is being shown at the Onhand inquiry. The value is being shown by a display method in InventSum table i.e. InventSum.AverageCostPriceUnit(). I need to write a SQL query to calculate the cost as I dont know much about X++. Could anyone help me write a query or advise a simple solution so that i can get the avg cost price using SQL. If anyone can help me with which tables are involved and what will be the logic then i can write the query myself. Thanks in advance.
*This post is locked for comments