web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Items report for given lot no. (sales, stock)

(0) ShareShare
ReportReport
Posted on by 32,729

Hi,

is there a standard report which shows where to find all items with a given lot no., sold ones and on stock?
the report should show the customers, whom the items were sold and the locations/bins where the rest is to be found.

background: items with lot no. X are of bad quality, out of due date, etc. they must be sent back for control/disposal. the customers have to be informed.

if there is none, what would be the best way to develope that kind of report? item ledger entries, warehouse entries, ...

regards

  • Suggested answer
    Alfredo_Iorio Profile Picture
    1,268 on at

    Hi, there is no standard report to run a "traceability report" in BC.

    I have developed one for every project with pharma and food companies.

    The report is based on item ledger entries but if you want to include details like customer name, ship-to and the location/ bin where you keep existing stock, you need more tables like customer, ship-to address code and warehouse entry. You can probably get away with the warehouse entry table and use the bin content if you pass the lot number as a filter in the report.

  • Suggested answer
    Dallefeld Profile Picture
    235 User Group Leader on at

    Have you looked at the Tracing screens in BC?

  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at

    I totally agree with Kim here. You should use the item tracing page that is in standard BC.

    I think that will give you the information you need.

    learn.microsoft.com/.../inventory-how-to-trace-item-tracked-items

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 719 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 410 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 369 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans