Hello,
I will try to be breif. I'm trying to add fields to Checking report no 10401. These fields are from the Bank Account table and are as follows
Last Check No.
Bank Branch No.
Bank Account No.
Here is the code
dataitem(GenJnlLine; "Gen. Journal Line")
{
DataItemTableView = SORTING("Journal Template Name", "Journal Batch Name", "Posting Date", "Document No.");
column(GenJnlLine_Journal_Template_Name; "Journal Template Name")
{
}
column(GenJnlLine_Journal_Batch_Name; "Journal Batch Name")
{
}
column(GenJnlLine_Line_No_; "Line No.")
{
}
dataitem(BankAccount; "Bank Account")
{
DataItemLink = "No." = field("Bal. Account No.");
DataItemLinkReference = GenJnlLine;
DataItemTableView = sorting("No.");
column(Balance_Last_Check_No_; "Last Check No.")
{
}
column(Balance_Bank_Branch_No_; "Bank Branch No.")
{
}
column(Balance_Bank_Account_No_; "Bank Account No.")
{
}
Unfortunately, this does not work. The data that is there is simply not displayed.
The only thing I can think of is that the Bal. Account No changes depending on the Bal. Account Type and this is why it is not working.
Thanks in advance for your help.
