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
Copy link

Link copied!

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
Copy link

Link copied!

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 970 on at

Like (0)

Report
Copy link

Link copied!

Use Item Tracing in Business Central

Was this reply helpful? Yes No
LindyLou 40 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

Got it. Thank you very much.

Was this reply helpful? Yes No