Finance | Project Operations, Human Resources, ...

Where is Reason Comment field store in DB from module Budget Register Entry

(0) Share

Report

Posted on by edwin90

Dear Expert,

How I can get Reason Comment information, I didnt get the field in BudgetTransactionHeader.

Is there anyway to get the Reason Comment data in Budget Register Entry?

I have the same question (0)

All responses (5)

Answers (0)

Hana Xue 7,131 Microsoft Employee on at

Like (0)

Report

RE: Where is Reason Comment field store in DB from module Budget Register Entry

Hi，

The reason comment is a description of the reason code, perhaps you can find it in the General Ledger -> Journal Setup -> Financial Reasons.

For more information you can view the links below:

Financial reason feature extension - Finance | Dynamics 365 | Microsoft Learn

About financial reason codes | Microsoft Learn

Best Regards,

Hana

This post is my own opinion and does not necessarily reflect the opinion or view of my company.

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
edwin90 on at

Like (0)

Report

RE: Where is Reason Comment field store in DB from module Budget Register Entry

Dear Hana,

If you look my Budget Register Entry,

I didn't use Reason Code, just Reason Comment, and the textbox is enable editted (custom)

However, I already try use Financial Reason, the field just show the "Default Comment".

What I want is if you fill with something custom like "General adjustment - Period 01-05 May 2023".

Wheres D365FO store the "General adjustment - Period 01-05 May 2023"?, becuase we just get "General adjustment" in description ReasonTable

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report
RE: Where is Reason Comment field store in DB from module Budget Register Entry

Hi, ReasonComment is a edit method and you didn't mentioned where do you want to access it. To access it you need table buffer of BudgerRegisterHeader table.

Check below code for reference

ReasonTableRef reasonTableRef; //Keyword 'This' is for BudgetTransactionHeader table buffer select ReasonComment from reasonTableRef where reasonTableRef.RecId == this.ReasonTableRef;

Was this reply helpful? Yes No
Hana Xue 7,131 Microsoft Employee on at

Like (0)

Report

RE: Where is Reason Comment field store in DB from module Budget Register Entry

Hi,

Generally, the reason comment field is an explanation of the reason code, which you can customize in the screenshot I mentioned above. It is associated with a reason code, similar to a purchase order reason code and reason comment. If you want to know its location, you can check the screenshot provided by Mohit.

Best Regards,

Hana

This post is my own opinion and does not necessarily reflect the opinion or view of my company.

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
edwin90 on at

Like (0)

Report

RE: Where is Reason Comment field store in DB from module Budget Register Entry

Hi Mohit,

Great!!.. ReasonTableRef is what I need..

The edited ReasonComment store on that Table.

Thanks!

Was this reply helpful? Yes No