Cost of Goods Table

(0) Share

Report

Posted on by Community Member

Dear All,

We are using Microsoft Dynamics 2012 R3. Every day sales in our retail stores by item code can be track in system but we don't know the exact report/table name for the COGS by item code. There is a report Inventory Ageing Report in AX which available data but is there any other table or report can give the item wise COGS?

*This post is locked for comments

All responses (4)

Answers (1)

Sort by

André Arnaud de Cal... 307,101 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

The table InventSum provides actual information on cost prices for products that do have on-hand stock.
Verified answer

jgracak on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you are looking for the current cost price of the item that can be found on the On-Hand form in Inventory and Warehouse management module.

Kind regards,

Josip
Community Member on at

Like (0)

Report
Copy link

Link copied!

What back end table would that be stored in?
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you are referring to On-Hand form, backend tables are InventSum and InventDim with the relation InventSum.InventDimId == InventDim.InventDimId.

Thanks,

Chaitanya Golla