News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Budget control update ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Budget control update error

(0) Share

Report

Report

Posted on by atef@83

757

Dear All

when i try to create budget control and do all the setup , i create budget registry but when click update i got this error

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]BudgetControlProcessProc ( in SysRaiseErrorProc): Trying:exec BudgetControlCheckBudgetProc :BudgetControlCheckBudgetProc: Trying:MERGE INTO BudgetSourceTrackingSummary:Cannot insert the value NULL into column 'RECID', table 'MicrosoftDynamicsAX.dbo.BUDGETSOURCETRACKINGSUMMARY'; column does not allow nulls. UPDATE fails.(515) at line 1268 at line 68

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

AlinaC on at

Like (0)

Report

RE: Budget control update error

Hi atef083,

Some things that the developer can check:

- the error seems to refer to the fact that the system cannot insert in BudgetSourceTrackingSummary table a null RecId. The RecId is not part of the INSERT statement since it should be defaulted on the table - hence please check the Default on columnRecID for this table

- might try to run a DBsync if the above is missing
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Budget control update error

Hi atef083,

I would recommend asking a developer for some help to debug things for the mentioned lines.

Best regards,

Ludwig

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans