Bin

(0) Share

Report

Posted on by jsshivalik

3,099

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)

All responses (6)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hannes Holst 5,767 on at

Like (0)

Report
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).

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

Hi

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

Thanks

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

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

Was this reply helpful? Yes No