Monday, October 27, 2014

CASE Statement for Inventory Item Master Item Types [IV00101].[ItemType]

I have amassed a number of useful CASE statements, which can be incorporated into SQL queries run against Dynamics GP. When Querying the Item Master Table in Dynamics GP (IV00101), use the following case statement to return text versions of the default Item Type field (ItemType):

case [IV00101].[ItemType]
      when 1 then 'Inventory'
      when 2 then 'Discontinued'
      when 3 then 'Kit'
      when 4 then 'Misc Charges'
      when 5 then 'Services'
      when 6 then 'Flat Fee'
      else 'ERROR'
end   ItemTypeText

1 comment: