Dear Experts
am trying to make e report from the table item and item ledger entries for remaining qty and location of an item, we have parent category and sub category in items.but while pulling the items, these 2 fields are not coming for all the items. its is only coming for some of the items only.
what may be the issue
Out of the Report
report 62003 "ITEM WISE BY LOC (Stock)"
{
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
DefaultRenderingLayout = LayoutName;
AllowScheduling = true;
dataset
{
dataitem(Item; Item)
{
DataItemTableView = where(Inventory = filter('>0'));
column(No; "No.")
{
}
column(UnitCost_Item; "Unit Cost")
{
}
column(UnitPrice_Item; "Unit Price")
{
}
column(Description; Description)
{ }
column(ShowPrice; ShowPrice)
{
}
dataitem(Item_Ledger_Entry; "Item Ledger Entry")
{
DataItemLink = "Item No." = field("No.");
column(ItemNo_Item_Ledger_Entry; "Item No.")
{
}
column(Location_Code; "Location Code")
{
}
column(ItemCategoryCode_Item_Ledger_Entry; "Item Category Code")
{
}
column(ItemParentCagetory_Item_Ledger_Entry; "Item Parent Cagetory ")
{
}
column(Remaining_Quantity; "Remaining Quantity")
{
}
}
}
}
requestpage
{
layout
{
area(Content)
{
group(GroupName)
{
field(ShowPrice; ShowPrice)
{
Caption = 'Show Price';
ApplicationArea = All;
}
}
}
}
}
rendering
{
layout(LayoutName)
{
Type = RDLC;
LayoutFile = '.\ReportLayouts\ITEMBYLOCATION1.rdl';
}
}
var
ShowPrice: Boolean;
}
