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 :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Bin
Microsoft Dynamics NAV (Archived)

Bin

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,099

Hi

  In Purch Recpt Line i have Bin Field . On Request Page in report when i select Filter Bin Code no Data is displayed when i click on DropDown. When i select Advanced and Clear Filter then in Bin List Data gets displayed. How to clear filter that on Request Page when i click DropDown it should display Bin List.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    Do you have the table relation set in your Bin Filter field in the report you mention? Or maybe does it opens with applied filters? Check or post a screenshot.

  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi

     Bin Code is a field in Purchase Receipt Line as shown in image. When i select DropDown then it shows Blank & then click on Advanced it does not show anything. When i click Clear Filters then it displays list. Image link is as below

    https://imgur.com/a/s8qzV

    Thanks

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at

    Hi,

    That's the TableRelation of that field.

    Bin.Code WHERE (Location Code=FIELD(Location Code),Item Filter=FIELD(No.),Variant Filter=FIELD(Variant Code))


    You have either ..

    • no Bins created in the Location of the Purchase Receipt.
    • you have Bins for that Location, but you have configured specific Items for a Bin only (and the item of the Purchase Receipt is not configured to be used in a Bin).
    • you have Bins for that Location, but you have configured specific Variants for a Bin only (and the Variant of the Purchase Receipt is not configured to be used in a Bin).
  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi

     Where Bins are created . What changes i need to do so that it should show

    Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    What are you trying to accomplish, even you remove filters and apply the filter you will not get your report to print the data, because the receipt line does not have the data for the bin.

    If you are trying to find the receipt lines for a specific bin then add a global variable called BinCode and specify the table relation for that field to be Bin table and use that variable on the Request page and modify the report onPreDataItem of the table to filter the receipt line based on the Bin Code.

  • jsshivalik Profile Picture
    jsshivalik 3,099 on at

    Hi

     I can create Custom field . But can't we do with existing bin field by writing code or changing the Table Relation for this particular field.

    Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans