You’re offline. This is a read only version of the page.
190
Dear Experts
i want to add Total Rem Qty(in all locn), unit price * qty and qty in transit into this subquery page or report. i cant able to get the code and no extension is listed over there to add it in dependencies.
how can we take the code and add those fields for getting the desired page or report
Thanks for the reply Zhu
am trying to bring one lookup field with the help of of your blog, but am getting error and not getting the desired output. kinldy request your kind help on this. i just want to select the value from dimensions values under the dimension name " item subcategory"
Hi, you can unzip the app file I uploaded, there are these codes in the scr folder.
Also, calculations are not supported in Query Object.
You can use the following method to add to a new page.
Hope this helps.
Thanks.
ZHU
Thank you for the Reply
i can't able to see the extension in page extension and also i copied the dependency as you given in the blog and put in the app.json file then also its not downloading.
how can i bring Total Rem Qty (in all locn), unit price * qty and qty in transit also in this
Hi, hope the following helps.
How to download “_Exclude_Microsoft Dynamics 365 – Smartlist” extension source code (Such as query 2554 “Items By Location”)
[View:/cfs-file/__key/communityserver-discussions-components-files/758/Microsoft_5F005F00_Exclude_5F00_Microsoft-Dynamics-365-_2D00_-SmartList_5F00_21.0.45833.0.app:320:240
Share
Report
All responses (
Answers (
query 2554 "Items By Location"
{
QueryType = Normal;
OrderBy = ascending (No);
Caption = 'Items By Location';
QueryCategory = 'Item List';
elements
{
dataitem(Item; Item)
{
column(No; "No.")
{
Caption = 'No.';
}
column(Description; Description)
{ }
dataitem(Item_Ledger_Entry; "Item Ledger Entry")
{
DataItemLink = "Item No." = Item."No.";
column(Location_Code; "Location Code")
{
Caption = 'Location Code';
}
column(Remaining_Quantity; "Remaining Quantity")
{
Caption = 'Remaining Quantity';
Method = Sum;
}
}
}
}
trigger OnBeforeOpen()
begin
end;
}
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,493
Most Valuable Professional
#3
nmaenpaa
101,148