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; }
Have you added the category after you started posting transactions on the items. You are reporting the Item category and Subcategory from the item ledger entries and they will only show up in your report if they were present when you posted the transaction.
You can try to get the fields from the item data item instead of the item ledger entries.
it is already there. you can see in the above screenshot. in some of the items its coming there but some of the items its not coming.
Hi, you can add the colum subcategory, parent category to the dataitem --> ITEM have you tried that
Could anyone pls help me on this
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156