Dynamics Community Forum Thread Details

Error with custom report.

Hi,

How can I obtain the related records between the 'Item Journal Line' table and the 'Reservation Entry' table in a custom report?
On the 'Production Journal' page I added a button called 'Generate Labels' and I want to show in the report the records from the 'Reservation Entry' table that are related to the 'Output' type records from the 'Production Journal' page.

I already tried with 'SetSelectionFilter' and 'SetTableView', however it shows an error with DataItem.

Thanks in advance.

Categories:

Dynamics 365 Business Central

Hello,

Here's the source code for your queries :

dataitem("Prod. Order Line"; "Prod. Order Line")
{
PrintOnlyIfDetail = true;
DataItemLink = "Item No." = field("Item No.");
DataItemLinkReference = "Production Budget Qty";
DataItemTableView = sorting("Prod. Order No.", "Line No.") where(Status = filter(Status::Finished | Status::Released));
column(Line_No_; "Line No.")
{
}
column(Prod__Order_No_; "Prod. Order No.")
{
}
dataitem("Reservation Entry"; "Reservation Entry")
{
DataItemLink = "Item No." = field("Item No."), "Location Code" = field("Location Code"), "Source ID" = field("Prod. Order No."), "Source Prod. Order Line" = field("Line No."), "Variant Code" = field("Variant Code");
DataItemLinkReference = "Prod. Order Line";
DataItemTableView = sorting("Item No.", "Variant Code", "Location Code") where("Source Type" = filter(Database::"Prod. Order Line"), "Source Subtype" = filter(3));
column(Lot_No_Reservation; "Lot No.")
{
}
column(Quantity; Quantity)
{
}
}

Hope this solution's help.

Thank You,
Shrey Chauhan

Quick Links

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