web
You’re offline. This is a read only version of the page.
close
Skip to main content
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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,035 Moderator on at
    RE: Items report for given lot no. (sales, stock)

    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

  • Suggested answer
    Dallefeld Profile Picture
    193 User Group Leader on at
    RE: Items report for given lot no. (sales, stock)

    Have you looked at the Tracing screens in BC?

  • Suggested answer
    Alfredo_Iorio Profile Picture
    1,262 on at
    RE: Items report for given lot no. (sales, stock)

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,683 Super User 2025 Season 2

#2
Sumit Singh Profile Picture

Sumit Singh 2,603

#3
Jeffrey Bulanadi Profile Picture

Jeffrey Bulanadi 2,214

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans