54
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.
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
