How to Create Super Admin

Creating SuperUser

TO CREATE SUPERUSER change values and execute:

EXEC cp_Register

0, 'Automation', 'Customer', '4466227863',

'automationcustomer360@gmail.com',

'',

'',

'',

'', '',

'automationcustomer', 'automationcustomer1',

'Automation CUSTOMER PVT LTD',

'',

'CUSTOMER',

0,

'',

0,

1, 51,

'', '',

 '',

 'Hyderabad', 'Telangana',

 '',

 '',

 'INDIA',

 'TELANGANA', '500049',

 'HYDERABAD', '', '', '',

 '', '', '', '',

 '', '', '', 0,

 4, '','', '',

 '', '', '',

 '', 'automationcustomer', 'automationcustomer1',

 0, '', '','','','','','','','';

Once the super user is created cross-check and verify the following

select * from [user];

a)      Need to enable the catalog

select * from company;

           update company set IS_CATALOG_ENABLED=1 where comp_id=14271;

b)     Userverification

select * from userverification;

update userverification set U_IS_VERIFIED=1 where U_ID=14271;

c)      Emailotpverification

select * from userdata;

update userdata set isEmailOTPVerified=1 where U_ID=14271;

d)Accesslevel

insert into useraccess(U_ID,ACS_ID,IS_VALID,DATE_CREATED,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

select 12,ACS_ID,1,GETUTCDATE(),GETUTCDATE(),0,0 from accesslevels 

Then check the parameters

Select * from parameters

update parameters set param_value='720' where param_id='7'

Change comp_id,created_by and modified parameters and execute

insert into   companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'REQ_SERIAL_NUM','1','1','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'REQ_SERIAL_NUM_PREFIX','PRM','PRM','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'DISABLE_LOCAL_GST_FEATURE','1','1','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'BEST_PRICE_FROM','2023-08-01','2066-01-01','1',GETDATE(),GETDATE(),'0','0');

insert into companyconfiguration(COMP_ID,CONFIG_KEY,CONFIG_VALUE,CONFIG_TEXT,IS_VALID,DATE_CREATE,DATE_MODIFIED,CREATED_BY,MODIFIED_BY)

values(2,'BEST_PRICE_TO','2023-08-01','2066-01-01','1',GETDATE(),GETDATE(),'0','0');

Insert the below line items from the DB by changing the companyid , createdby and modifiedby parameters

 INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Packaging and forward charges','Packaging and forward charges','','Packaging and forward charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Freight charges','Freight charges','','Freight charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Insurance Charges','Insurance Charges','','Insurance Charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

INSERT INTO cm_product (CompanyId,ProductCode,ProductName,ProductDesc,ProductNo,ProdQty,IsValid,DateCreated,DateModified,CreatedBy,ModifiedBy)VALUES(17726,'Miscellaneous Charges','Miscellaneous Charges','','Miscellaneous Charges','Numbers',1,GETUTCDATE(),

GETUTCDATE(),17344,17344);

 INSERT INTO cm_productcategory (ProductId, CategoryId, CompanyId, IsValid, DateCreated, DateModified, CreatedBy, ModifiedBy)

VALUES

    (156560, 24252, 19936, 1, '2024-07-01 11:17:03', '2024-07-01 11:17:03', 28614, 28614),

    (156561, 24252, 19936, 1, '2024-07-01 11:17:28', '2024-07-01 11:17:28', 28614, 28614),

    (156562, 24252, 19936, 1, '2024-07-01 11:18:10', '2024-07-01 11:18:10', 28614, 28614),

    (156563, 24252, 19936, 1, '2024-07-01 11:18:10', '2024-07-01 11:18:10', 28614, 28614);

Once the products are inserted into the system, change productids in the below Excel sheet and insert incoterms to the system from DB.

https://docs.google.com/spreadsheets/d/1K41LJNbaYO30c2X2LEmhzZp98iKtyICtyHcJrBUGgug/edit#gid=0

Create categories as Sourcing-PRM360 and RequirementItems 

Update the below query for RequirementItems category

update cm_Category set is_core='0' where CategoryId='23919';

Login to the portal

1. Create a Department and designation

2. Create Currency

3. Create 4 products and category as requirement items (Packaging and forwading charges,Insurance charges, Miscellaneous charges,Freight charges)

4. Insert Incoterms based on the productid

5. Create PRM-DEFAULT template

6. Create PRICE CAP in my vendors comp_name:PRICE_CAP