Finance | Project Operations, Human Resources, ...

Budget control update error

(0) Share

Report

Posted on by atef@83

777

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 (2)

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