How to filter item batch number on the basic of site,warehouse and location

(0) Share

Report

Posted on by Vishu Beniwal

143

Hello everyone,

Can anyone please tell me the query using which i can get the all available item batch number of a particular Item filtered by warehouse,site and location.

Thanks in advance

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishu,

Do you want to get all physically available batch numbers for item for warehouse and location?

Was this reply helpful? Yes No
Verified answer

Mwendwa 55 on at

Like (0)

Report
Copy link

Link copied!

HI Visu,

You are looking for the On-hand list. Ensure you select the dimensions you would like to have, in this case the Serial number and save the selected dimensions. Use the Filter on the left side of the screen to select the items and serial number you want. To ensure a serial number is present use the Is not option and put quotation marks. press aplly and this should give you the results

Brgds,

Eddie | Consultant | 365 enthousiast |
Kindly mark this thread with 'Yes' if it answered your question and lets spread the knowledge.
This post is my personal opinion and does not necessarily reflect the opinion of my company or Microsoft.

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

in various screens like on-hand list, inventory reports, you could enable inventory dimensions batch, site, warehouse and others as needed

hope you tracking dimension tracks physical inventory by batch

Was this reply helpful? Yes No