Cost of goods sold

Dynamics 365 for Finance and Operations/AX User Forum
1

I am looking for the table that has the values for the cost of goods sold or margin on a sale. I can see the numbers I need when I view totals on a sales order but can not find the table containing the numbers. Anyone point me in the right direction to find thse numbers? thanks Joe

2

Hi The COGS will be found in the InventTrans table, but it is a calculated value from CostAmountPosted+CostAmountAdjustment. You can also use the method “costValue” on InventTrans.