Create View If Not Exists In Acumatica Customization

Hello everybody,

today I want to leave a short post on how to create some custom view in Acumatica Customization if that view doesn't exist:

if not exists (select * from sysobjects where name='CustomerSelector' and xtype='V')
begin
exec (
    'CREATE view [CustomerSelector] as 
		select Distinct b.CompanyID, cc.Phone1, a.City, a.CountryID, b.TaxRegistrationID, c.CuryID, cc.Salutation, c.CustomerClassID, b.Status
		from BAccount b inner join customer c on b.BAccountID = c.BAccountID inner join [Address] a 
		on a.BAccountID = b.BAccountID inner join Contact cc on cc.BAccountID = b.BAccountID'
		)
 
end

This code will create view CustomerSelector only if such view doesn't exist in Acumatica

Looking to streamline your Acumatica experience with custom solutions? If you need tailored views, automation, or any other customization, let’s make it happen! Leave a request for a customization today, and let’s build the perfect solution for your business needs.