To delete a company

Finance and Operations/AX Technical Forum
1

Hi,

When a user tries to DELETE one of the companies, he gets a meesage

User “x” is not authorized to delete a record in the table ‘DEL_PBATRANSLATECONSISTOF’ . Request den

Cannot edit a record in Translation table(DEL_PBATRANSLATECONSISTOF). Access Denied; You donot have sufficient authorization to modify data in database

I checked the GROUPS for the user, this particular user is already added to the ADMIN Adminstrators.

What else needs to be checked?

regards

2

Hi,

It is due to table property set incorrectly. Go to this table and change MaxAccessMode property to Delete and try again.

Regards,

3

Hi,

Thanks for the reply.

I checked this property and MaxAcessMode was already set to DELETE.

What else could be wrong.

regards

TP

4

Hi Thomas,

Please try to set the table property SecurityKey = null

Regards

Anas Al-Khalili

5

I have the same problem. Where exactly do I change that?

6

Hi,

Please find attached screen shot, basically you have to set the AOSAuthorization property to NONE

regards

TP

7140.AOSAuthorization property.JPG
7140.AOSAuthorization property.JPG1280×800 188 KB

7

thx Anas for your help…

8

Hello,

When I delete a company in AX2009, I have the same error on Table “LedgerTrans”.

I check that there is no record in ledgerTrans for the company I delete.

I try set table property “Security key” to Null, MaxAccessMode to Delete, but still get the same error.

Finally I need to change the table property “AOSAuthorization” to None.

9

First try to delete the transactions by running the sysDataBaseTransDelete class

and then try to delete the company…