Using the MRP Explosion Stored Procedure

— To turn on Stored Procedure MRP
IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName = ‘UseMRPStoreProcedure’)
BEGIN
UPDATE CompanySettings SET BVal = 1 WHERE KeyName = ‘UseMRPStoreProcedure’
END
ELSE
BEGIN
INSERT INTO CompanySettings (KeyName, BVal) VALUES (‘UseMRPStoreProcedure’, 1)
END

— To turn off Stored Procedure MRP
IF EXISTS (SELECT * FROM CompanySettings WHERE KeyName = ‘UseMRPStoreProcedure’)
BEGIN
UPDATE CompanySettings SET BVal = 0 WHERE KeyName = ‘UseMRPStoreProcedure’
END

About Vincent Stefanetti

Vincent Stefanetti Senior Consultant MAX Manufacturing Software Working with MAX and Related Technologies Since 1987 MAX ERP System Implementations and Projects MAX, Dynamics GP, Synergy, Event Manager, Crystal Reports, SQL Reporting Services, Database and System Migrations and Updates, MAX Training Classes - All Levels, Custom Reporting.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *