Anyone Have Sales Gross Margin Dashboard?

Epicor ERP 10
21

I had 1 bug I fixed in mine. It didn’t play nice with Sales Kit so I had to do something like

	(IIF(OrderDtl.KitFlag <> 'C', IIF(InvcHead.CreditMemo = 1 and InvcDtl.RMANum <> 0, InvcDtl.OurShipQty * -1, InvcDtl.OurShipQty) * InvcDtl.MtlUnitCost, 0)) as [Calculated_MaterialCost],
	(IIF(OrderDtl.KitFlag <> 'C', IIF(InvcHead.CreditMemo = 1 and InvcDtl.RMANum <> 0, InvcDtl.OurShipQty * -1, InvcDtl.OurShipQty) * InvcDtl.LbrUnitCost, 0)) as [Calculated_LaborCost],
	(IIF(OrderDtl.KitFlag <> 'C', IIF(InvcHead.CreditMemo = 1 and InvcDtl.RMANum <> 0, InvcDtl.OurShipQty * -1, InvcDtl.OurShipQty) * InvcDtl.BurUnitCost, 0)) as [Calculated_BurdenCost],
	(IIF(OrderDtl.KitFlag <> 'C', IIF(InvcHead.CreditMemo = 1 and InvcDtl.RMANum <> 0, InvcDtl.OurShipQty * -1, InvcDtl.OurShipQty) * InvcDtl.SubUnitCost, 0)) as [Calculated_SubcontractCost],
	(IIF(OrderDtl.KitFlag <> 'C', IIF(InvcHead.CreditMemo = 1 and InvcDtl.RMANum <> 0, InvcDtl.OurShipQty * -1, InvcDtl.OurShipQty) * InvcDtl.MtlBurUnitCost, 0)) as [Calculated_MaterialBurdenCost],