Question

Excel Add In : Not able to modify/create/delete users

  • 12 December 2022
  • 5 replies
  • 97 views

Userlevel 1
Badge +4

Hello,

In migration Job, I would like to create a quick excel migration to modify a value of the field Tax_Liability in the LU Customer_Delivery_Tax_Info.

But impossible tu update this field, excel add in refuse to let me modify this value. 

“Access denied. User SFAUR is not allowed to add/edit/delete users in the company”

I tried with IFSAPP but same result… 

What is the option to grant me the right to update this kind of field !?


5 replies

Userlevel 4
Badge +8

Hi @sfaure 

Is your user already available in the overview for “Users per Company” and the company FR250-14?

 

Another possibility depends on your user and the roles/permission sets this user is assigned to. That means you need a permission set with activated system privilege “ADMINISTRATOR” and activated activity “Manager Users” (e.g. IFS_ADMIN has normally these privileges).

 

/Jens

Userlevel 1
Badge +4

Hello Jens,

Thanks for your answer. 

I tried your solution but the problem stays the same.

My user is already available in the overview for “Users per Company” and the company FR250-14.

I have the same permission set as ifsadmin which is FND_ADMIN...

Userlevel 4
Badge +8

Can you change it manually in the client with your user? Are you using IFS Applications or IFS Cloud?

 

Permission set details for FND_ADMIN:

System Privileges: ADMINISTRATOR is ticked?

AND

Activities: IFS Administration → ManageUsers is ticked?

 

I suppose this is not your first migraition job in this environment isn’t it?

So your User is in the screen Data Migration Basic Data, Tab User, and has the privilege UpdateAllowed?

 

Userlevel 1
Badge +4

Yes, Yes, and Yes :) 

 

But nice try :P 

I’m using IFS Applications, and I can do it manually !

 

 

 

Here the tax liability was in TAX. Manually, i could change to EXEMPT

Badge

Try defining yourself or IFSAPP temporary as a Financial User and try again.

Reply