Finance | Project Operations, Human Resources, ...

The custom script is not allowed to access the XYZ table

(1) Share

Report

Posted on by D365 beginner

636

Hi Experts,

I am getting below error while trying to run a custom script. can anyone help me to solve it please.

I am trying to update the BankTransAmountCur value for a record in the table bankAccountTrans using below class

class UAPBankTransUpdate
{

public static void main(Args _args)
{
BankAccountTrans bankAccountTrans;

if(curExt() != 'UAP')
{
throw error("This script must run in UAP entity");
}

select forupdate bankAccountTrans
where bankAccountTrans.RecId == 5637187458;

if(bankAccountTrans)
{
ttsbegin;
bankAccountTrans.BankTransAmountCur = 258000.33654;
bankAccountTrans.doUpdate();
Info("Record updated");
ttscommit;

}

I have the same question (0)

All responses (6)

Answers (0)

Waed Ayyad 9,089 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

What are the roles that are assigned to the user who was running the script? Is it admin?

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Anton Venter 20,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Please explayin why are you updating this bank transaction? If you update the amount of this transaction, you will create a difference that cannot be accounted for.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Several transaction tables are restricted to be used to make changes via custom scripts. The method name raising the error already indicates this. It is checking for supported tables. So, you can't use this table in a custom script.

As asked by others, what is the business reason for updating an amount directly in a posted transaction?

Was this reply helpful? Yes No
D365 beginner 636 on at

Like (0)

Report
Copy link

Link copied!

Thank you all for the response.

I am having system administrator role. What happened is we had made a changes in the decimal places for some quantity related extended datatype which resulted some vendor payments and related subledger transactions are not matching with some minor difference like 0.20, 0.30 etc. we have identified those transactions and we need to do this action to match them. We have successfully done the same in UAT environment using the JIT SQL access and now we need to do the same in live environment to match or correct the transactions. For sure I cannot edit the value in bank account transaction table ? then is there any other way than reversing those transactions and redoing it again ?. Thanks.

Was this reply helpful? Yes No
Anton Venter 20,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You should be able to update the transaction(s) without any issues using the SysClassRunner class instead of the custom script method. But that will require your class to be deployed to production environment though and that means down time of the production environment.

Was this reply helpful? Yes No
Suggested answer

Lauras U 959 on at

Like (1)

Report
Copy link

Link copied!

I had similar issue with updating NumberSequenceTable. Turns out that for some tables (tablegroup=Framework OR SystemTable=Yes) it needs special flighting enabled.

Special flighting: AppConsistencyCustomScriptAllow%YOUR_TABLE_NAME%

See this for details: https://community.dynamics.com/blogs/post/?postid=d2fea471-3cb5-ee11-92bd-6045bdb56f43

Was this reply helpful? Yes No