I have amassed a number of useful CASE statements, which can be incorporated into SQL queries run against Dynamics GP. When Querying the Manufacturing Order Status Field in Dynamics GP (MANUFACTUREORDERST_I): use the following case statement to return text versions of the default statuses in Dynamics GP:
case WO010032.MANUFACTUREORDERST_I
when 0 then
'invalid entry'
when 1 then
'Quote/Estimate'
when 2 then
'Open'
when 3 then
'Released'
when 4 then
'Hold'
when 5 then
'Canceled'
when 6 then
'Complete'
when 7 then
'Partially Received'
when 8 then
'Closed'
else 'ERROR'
End MO_Status
Here is a list of the Dynamics GP Tables containing MANUFACTUREORDERST_I
ISSP0201 – Manufacturing Series Sales Order Preferences
MOP10213 – MOP Order Activity
MOP1070 – MOP Edit MO Status Header
MOP1071 – MOP Edit MO Status Line
MOP3000 – MOP Variances
MOPGetMOVariances
MOPV1100 - MFGMOList
MOPV3001
MPO10001 – MRP CRP Scheduled Orders
mvarMOStartEndQtys
PK010033 – MOP Item Master
SOPS113B – MOP Sys Preferences
WO010032 – Manufacture Order Master
WO010213 – Manufacture Order History
