Cost of Goods Table

(0) Share

Report

Posted on by Community Member Microsoft Employee

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)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Cost of Goods Table in AX 2012 R3

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Cost of Goods Table in AX 2012 R3

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

jgracak on at

Like (0)

Report

RE: Cost of Goods Table in AX 2012 R3

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
André Arnaud de Cal... 291,134 Super User 2024 Season 2 on at

Like (0)

Report

RE: Cost of Goods Table in AX 2012 R3

Hi,

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