Short Dated or Expiring Inventory

(0) Share

Report

Posted on by LindyLou

Most of my inventory is lot specific tracked with expiration dates. Is there an Inventory report that will show me all of my on hand inventory that will expire within the next 3 months?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

goto item card, then entries / "tem tracking entries".

show the filter pane, filter the exp. date to today + 3 months in the future.

eventually export the result to excel.

Was this reply helpful? Yes No
LindyLou 40 on at

Like (0)

Report

I see how this works on the single item card. I am hoping to get such a report for all on hand inventory, all in the same report or on the same page.

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

Use Item Tracing in Business Central

Was this reply helpful? Yes No
LindyLou 40 on at

Like (0)

Report

I do not see an expiry date option in item tracing. I am looking to evaluate my entire inventory - not just a single item - by expiry date. I would like to apply a filter for something like Qty On Hand >0 and Expiry Date < 2020-06-30.

Thank you.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

goto https://<your bc server base uri>/?company=<your-company>&page=6501&dc=0

that opens page "item tracking entries" directly incl. fields "item no.", "exp. date" and "lot no.".

filter that page with your needed filter settings like ...

Was this reply helpful? Yes No
LindyLou 40 on at

Like (0)

Report

Got it. Thank you very much.

Was this reply helpful? Yes No