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.
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.
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
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 ..
Where Bins are created . What changes i need to do so that it should show
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.
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.
Business Applications communities