Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Any way to display item availability quanitity by location, bin, & lot no.?

Posted on by 39
Hello all,
 
For a company that relies on lot no./expiration date for most raw materials coming in and reselling out we rely heavily on lot number/item tracking lines. 
 
It seems all separated and not very clear where to find their respective bins/lot numbers. 

Where can I combine this info? so I can quickly search for a location each morning to display all available quantity of items, their bins#, and lot# altogether on one page?
It can even be one item but I need all that info on one page. 
 
Thanks!
 
 
 


 
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 6,854 Super User on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    This is a good use case for a reporting tool such as Power BI or Jet Reports. A report could be built in either of those 2 that would display what you're looking for.
     
  • Vishal Goswami Profile Picture
    Vishal Goswami 14 on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    Warehouse Entries only show movement of inventory but it will be very complicated to find out available stock per lot per bin, when we have various lots are in coming and thigs get more complicated if other factor like country is involve.  
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 5,517 Super User on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    apart from customization, you could go to warehouse entries page, filter the item by location, it shows lot no. serial no. expiration date.
     
    The issue is you have to summarize it. 
     
  • Suggested answer
    Ziyad Y. Najami Profile Picture
    Ziyad Y. Najami 10 on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    Hello
     
    I hope this Query helps you 
     
    query 59100 "Item Ledger Entry Ziyad"
    {
        APIGroup = 'ZiyadNJ';
        APIPublisher = 'ZiyadNJ';
        APIVersion = 'v1.0';
        EntityName = 'ItemByLot';
        EntitySetName = 'ItemByLot';
        QueryType = API;
    
        elements
        {
            dataitem(ItemLedgerEntry; "Item Ledger Entry")
            {
                DataItemTableFilter = "Lot No." = filter(<> ''), Open = filter(= true);
    
                filter(Item_NoF; "Item No.")
                { }
                filter(Variant_CodeF; "Variant Code")
                { }
                filter(Location_CodeF; "Location Code")
                { }
                column(Item_No_; "Item No.") { }
                column(Location_Code; "Location Code") { }
    
                column(Lot_No; "Lot No.")
                { }
                column(Remaining_Quantity_Sum; "Remaining Quantity")
                {
                    ColumnFilter = Remaining_Quantity_Sum = filter(<> 0);
                    Method = Sum;
                }
            }
    
        }
    
    
    }
    This Query for Lot and the same can be applied for Serial and Bin.
    It is of Type API (because I have been working on an integration) so please take that into consideration and modify it.
     
    Hope this helps.
     
     
  • Suggested answer
    MS ROCK Profile Picture
    MS ROCK 139 on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    Hi, if you are using warehouse then can check out the warehouse entries whether your requirement is full filling or not. and can use analyze mode as per your requirement. Other wise customization will be require to achieve this.
     
  • Vishal Goswami Profile Picture
    Vishal Goswami 14 on at
    Any way to display item availability quanitity by location, bin, & lot no.?
    hi 
     
    I use Dynamics Business central for pharma company that also have lots of Lot and bins info. The information you looking for can be found in item card but out of the box system won't have all the information you are looking for so i had the same issue so with customisation we added some data in lot no by Item card 
     
    and now its looks like this. 
     
    Lot No. Expiry Date Location Code Bin Code Qty. (Base) Type Country Code
    3AA6575 31/05/2026   ABCXYZ 2,496.    
     
     
    So may be your implementation partner can help you with some customisation and that will resolve your issue
     
     
    Thanks
    Vishal

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans