Small and medium business | Business Central, N...

Values not Coming Al Code

(0) Share

Report

Posted on by LearnBC

190

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;

}

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: Values not Coming Al Code

Please try to change below two columns in your report.

column(ItemCategoryCode_Item_Ledger_Entry; Item."Item Category Code")

{

}

column(ItemParentCagetory_Item_Ledger_Entry; Item."Item Parent Cagetory ")

{

}
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Values not Coming Al Code

hello

do you apply a grouping in the report?

however the table relation in a flowfield is not needed
DAniele
LearnBC 190 on at

Like (0)

Report

RE: Values not Coming Al Code

Yes there are flow fields

tableextension 62004 "Parent Categ_Item LedgrEntry" extends "Item Ledger Entry"

{

fields

{

// Brought a new field to get the item sub category on Item Card Page

field(62004; "Item Parent Cagetory "; Code[20])

{

FieldClass = FlowField;

Caption = 'Item Parent Category';

Editable = false;

TableRelation = "Item Category" where("Has Children" = const(true));

CalcFormula = lookup("Item Category"."Parent Category" where(Code = field("Item Category Code")));

}

modify("Item Category Code")

{

Caption = 'Item Sub Category';

}

}

}

In the Report
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: Values not Coming Al Code

hello

you must actually ensure that you have the link on the 'Item Ledger Entry' with the item when you go to retrieve those fields

in the card they are valued but I think they are physical fields in the Item table

or are they flowfields on the "Item Ledger Entry"?

DAniele