Description of Issue:
Customers have added many parts to SedonaOffice and found that they are not available in their Service Application (Sedona-X or FSU).
OR
The box to mark parts as Available to FSU (service) is grayed out and will not allow them to mark the box to make them available to service.
Fixes:
Run script below first:
//Select
p.Part_Code As 'Part_Code',
p.Description As 'Part_Description',
p.Service_Part As 'Service_Part',
p.Sales_Part As 'Sales_Part'
From
IN_Part p
Where
p.Part_Id <> 1
Order By
p.Part_Code
Next, run script below to update the N (No) value to Y (Yes) value. This will update all parts as available to Service.
//update in_part set service_part = 'Y'
