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
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.