web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Report for adding code in existing procedure/ trigger custom field in the code of process report

(1) ShareShare
ReportReport
Posted on by 72
Hi  ,
 
I have custom field  XY in  /Bank Acc. Reconciliation Line/. when I want to transfer to /Gen. Journal Line/ which has custom field X.
there is a report to insert data into /Gen. Journal Line/ from  /Bank Acc. Reconciliation Line/. report name is  /Trans. Bank Rec. to Gen. Jnl./
 
how to add code like this /Gen. Journal Line/ .xy:= /Bank Acc. Reconciliation Line/.xy.
 
please give me hint.
 
Warm regards
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    24,229 Most Valuable Professional on at
    Report for adding code in existing procedure/ trigger custom field in the code of process report
    Hi
    In the report there is an event that you can subscribe to to add some more fields.
     
    BR
    GR
  • Suggested answer
    YUN ZHU Profile Picture
    94,541 Super User 2025 Season 2 on at
    Report for adding code in existing procedure/ trigger custom field in the code of process report
    Hi, I just did a simple test, I hope the following information can also give you some help.
     
    Thanks
    ZHU
  • KK-20050817-0 Profile Picture
    72 on at
    Report for adding code in existing procedure/ trigger custom field in the code of process report
    Hi ZHU, BR,
     
    Thank you for the support and that too right help.
    You are great  and hope best for you
  • Community member Profile Picture
    22 on at
    Report for adding code in existing procedure/ trigger custom field in the code of process report

    To transfer the custom field value from the /Bank Acc. Reconciliation Line/ table to the /Gen. Journal Line/ table in the report "Trans. Bank Rec. to Gen. Jnl.", you'll need to customize the code of the report.

    Here's a hint to guide you:

    Inside the "Trans. Bank Rec. to Gen. Jnl." report code, locate the section where it processes each record from /Bank Acc. Reconciliation Line/ and inserts data into /Gen. Journal Line/.

    Within this section, after the data from the /Bank Acc. Reconciliation Line/ has been processed and before it's inserted into /Gen. Journal Line/, you'll need to add code to transfer the value of custom field XY.

    Utilize the appropriate syntax for accessing custom fields in the code. Depending on the programming language and platform you're working with, this syntax may vary.

    Typically, it involves referencing the field by its name, preceded by the table name. Assign the value of /Bank Acc. Reconciliation Line/.XY to /Gen. Journal Line/.XY.

    The exact syntax for this assignment will depend on the programming language or scripting language you're using. Test your code thoroughly to ensure that the custom field values are transferred accurately from /Bank Acc.

    Reconciliation Line/ to /Gen. Journal Line/ for each record processed by the report. If you encounter any specific issues or need further assistance with the code, feel free to provide more details, and I can offer additional guidance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,907

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,169 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,977 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans