Dynamics Community Forum Thread Details

AL Code Help in report

Hello All

i have developed a report for the inventory remaining stock. but in our item Master all of the items have Item category and Subcategory is there. but while running the Report those category details was coming only in some of the items.

how can we correct it?

ITem Master Categories are there

Out of the Report

/// 
/// Report ITEM WISE BY LOC (Stock) (ID 62015).
/// 
report 62015 " ITEM WISE BY LOC (Stock)"
{
    UsageCategory = ReportsAndAnalysis;
    ApplicationArea = All;
    DefaultRenderingLayout = LayoutName;
    AllowScheduling = true;

    // report is created for getting item/stock report for sales team and Stock Taking

    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;

}

Quick Links

Leaderboard