SBX - Search With Button

SBX - Forum Post Title

Bin

Microsoft Dynamics NAV Forum

jsshivalik asked a question on 14 Apr 2018 12:07 PM
My Badges

Question Status

Suggested Answer

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

Reply
Suggested Answer

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.

Reply
jsshivalik responded on 16 Apr 2018 9:45 AM
My Badges

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

Reply
Hannes Holst responded on 16 Apr 2018 10:04 AM
My Badges

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).
Reply
jsshivalik responded on 16 Apr 2018 12:07 PM
My Badges

Hi

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

Thanks

Reply
Suresh Kulla responded on 16 Apr 2018 12:43 PM
Suggested Answer

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.

Reply
jsshivalik responded on 16 Apr 2018 11:58 PM
My Badges

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

Reply
Suggested Answer

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.

Reply
Suresh Kulla responded on 16 Apr 2018 12:43 PM
Suggested Answer

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.

Reply

SBX - Two Col Forum

SBX - Migrated JS