Report which shows expiration of item tracking nos.

(0) Share

Report

Posted on by Yin Mon Pyone

Dear Experts,

Is there any report in business central showing the expiration date with item tracking nos.?

Is there any report showing inventory aging which calculate based on expiration date of item tracking nos.?

Regards,

Sweety

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Nitin Verma 21,788 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can go with the Report ID 707, Inventory - Availability Plan, but you need to customized that report.

Was this reply helpful? Yes No
Yin Mon Pyone 12 on at

Like (0)

Report
Copy link

Link copied!

Hi Nitin,

Ok. Thanks. Let me try.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (1)

Report
Copy link

Link copied!

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

www.erpconsultors.com

Press Yes if info is useful.

Was this reply helpful? Yes No
Yin Mon Pyone 12 on at

Like (0)

Report
Copy link

Link copied!

Thanks Amit,

I will try.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (1)

Report
Copy link

Link copied!
Here is the code for the basic report you need.

You can expand it with more info as you wish.

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) { } } } }

Was this reply helpful? Yes No
Verified answer

Yin Mon Pyone 12 on at

Like (1)

Report
Copy link

Link copied!

Thank You. Noted.

Was this reply helpful? Yes No