Sage Evolution
Space shortcuts
Page tree
Skip to end of metadata
Go to start of metadata 
select 
StockLink
, cSimpleCode
, Code
, CASE  WHEN iItemCostingMethod = 0
			THEN 'Average'
		WHEN iItemCostingMethod = 1
			THEN 'Latest'
		WHEN iItemCostingMethod = 4
			THEN 'Manual'
		END as CostingMethod
 from stkitem
  • No labels