You’re offline. This is a read only version of the page.
4
Dear Experts,
Is there any report in business central showing the expiration date with item tracking nos.?
Or
Is there any report showing inventory aging which calculate based on expiration date of item tracking nos.?
Regards,
Sweety
Thank You. Noted.
Here is the code for the basic report you need.
You can expand it with more info as you wish.
Share
Report
All responses (
Answers (
report 50101 "Items with bact and exp.date"
{
ApplicationArea = All;
Caption = 'Items with bact and exp.date';
UsageCategory = Lists;
dataset
{
dataitem(ItemLedgerEntry; "Item Ledger Entry")
{
column(ItemNo; "Item No.")
{
}
column(Description; Description)
{
}
column(LotNo; "Lot No.")
{
}
column(SerialNo; "Serial No.")
{
}
column(ExpirationDate; "Expiration Date")
{
}
column(RemainingQuantity; "Remaining Quantity")
{
}
}
}
requestpage
{
layout
{
area(content)
{
group(GroupName)
{
}
}
}
actions
{
area(processing)
{
}
}
}
}
Thanks Amit,
I will try.
Hi,
I have checked, there is no such report with Item tracking detail. For this open Item Ledger Entry Page and extract the data into excel with LOT NO or Batch NO. and Expiration Date also. Make Pivot of that spread sheet. This is simple way to achieve the requirement without any customization.
Regards
Amit Sharma
Press Yes if info is useful.
Hi Nitin,
Ok. Thanks. Let me try.
Hi,
You can go with the Report ID 707, Inventory - Availability Plan, but you need to customized that report.
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...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156