Hi,
We are looking for COGS by Item/Product Report.
Standard Report in S&M >Inquiries and Reports > Statistics > Sales Analysis by Invoice Report has COGS but it is given by customer wise.
Standard Report in S&M >Inquiries and Reports > Statistics > Gross Margin by Item Report has COGS as required.
But in case if we look at visualization point of view how can we achieve in Power BI, the above data populates from CustinvoiceTrans and InventTrans.
I couldn't find InventTrans showing up in Power BI Navigation.
Any help here is really appreciated.
Thank You
Kumar
