Customise BAQ Report Options

Epicor ERP 10
, ,
1

Hi all,

I have created a BAQ Report and am having difficulty customizing the options. A user currently has to enter partnum and lotnum manually. However, I would like to replace initially the partnum text option with a combo populated with all parts in erp.partbin table and then hopefully as a second stage populate a second combo for lotnum with all those returned from query where partnum is equal to that entered in the first combo (I hope this is clear :slight_smile: )

Any suggestions would be really appreciated…

Thank you

Michael

2

I figured out the first bit by using a BAQ Combo to show all parts in PartBin. Now I’m on the second bit which I’m struggling with which is filtering a second combo based on the first BAQ Combo where part selected in first combo is used to only show the lot numbers for that given part.

3

Check out the follow post. There are quite a few topics on this on the forum