RE: Sales process hold button not indicate properly that the sales order is on hold or not
I think create smartlist will be easy to find Hold SOP
Try this SP View
create view ABC_Sales_HOLD
as
select
a.SOPNUMBE as 'SOP Number',
case a.SOPTYPE
when 1 then 'Quote'
when 2 then 'Order'
when 3 then 'Invoice'
when 4 then 'Return'
when 5 then 'Back Order'
when 6 then 'Fulfillment Order'
else ''
end 'SOP Type',
b.DOCID as 'Doc ID',
b.CUSTNMBR as 'Customer ID',
b.CUSTNAME as 'Customer Name',
case a.DELETE1
when 0 then 'HOLD'
when 1 then 'Hold has been removed'
else ''
end 'Hold Status'
from SOP10104 a
left join (select SOPNUMBE,SOPTYPE,DOCID,CUSTNMBR,CUSTNAME from SOP10100
union
select SOPNUMBE,SOPTYPE,DOCID,CUSTNMBR,CUSTNAME from SOP30200) b on a.SOPNUMBE = b.SOPNUMBE and a.SOPTYPE = b.SOPTYPE
go
grant select on ABC_Sales_HOLD to DYNGRP