We’d like to filter fulfilment workbench searches to pre-packaged parts that can ship by slapping on a shipping label, and off it goes. What’s the best way to do that? I was thinking of adding a UD Field to the Part’s attribute tab (Part.Slapper_c), but how wouId we filter for just those parts in FW…

I’ve tried creating a quick search or named search, but can’t get them to appear in FWB. Any idea on what columns need to be included that I’m missing? Or is FWB special, and this won’t work? select [OrderDtl].[OrderNum] as [OrderDtl_OrderNum], [OrderDtl].[OrderLine] as [OrderDtl_OrderLine], [Or…

[image] askulte: Any idea on what columns need to be included that I’m missing? OrderRel.SysRowID [image] Fulfillment workbench ERP 10 The BAQ Search is not the way to go with parameters/filters. Buckle in … this is going to be a fun explanation. What you’re goin…

SO… fulfillment workbench is “Special”… it doesn’t follow the rules because of the complexity of the data needed. the data table used is the PartDtl table the data RETURNED is the PartDtl.SysRowID So… here is how you do it: BAQ: Create a BAQ that shows the data you want to show, but also inclu…

Thanks @timshuwy and @Doug.C ! I was able to get my rough idea to to work. It seems that QuickSearch replaces the base search in FWB, and there’s no option to have both side by side. Would our users need to add the user pref Quicksearch every time, and remove it every time to get the base search? I…

I recently did this with Scheduled Epicor Functions but it required a lot of tracing and reverse engineering all the BO Methods. It was a lot of work so I would be very interested to hear if there ends up being an easier way to achieve this.

Is PartDtl.SysRowId still the hook if I am trying to return jobs in the ‘Job Fulfillment’ tab? I am trying to make a quick search that returns based on the Finished Good Part Number and not having success.

I have one currently working in fulfillment workbench. Have you added the column into the BAQ Search tab? [image]

I didn’t have that but I did just add it. I can do my search on the FG Part #, get my expected results, but when I select any # of records and hit OK it doesn’t pull the selected records into the FWB grid.

How long do you give it? Fulfillment workbench is a slow screen.

I don’t think I’m being impatient. Even if I select a couple records, I see the ‘Retrieving data’ briefly in the lower left, it spins a second, and then goes back to ‘Ready’

Add A Filter to Fulfillment Workbench

Epicor ERP 10

Doug.C (Doug Crabtree) May 24, 2021, 5:33pm 3

OrderRel.SysRowID

Topic		Replies	Views
Quick Search for Fulfillment Workbench Epicor ERP 10	6	2586	April 19, 2022
Fulfillment workbench Epicor ERP 10 e10	14	5780	August 7, 2020
Custom Kinetic Search Kinetic ERP customization	31	12460	May 7, 2024
Creating a Part Search for BAQ Epicor ERP 10 baq	54	8084	January 18, 2023
Adding a BAQ to Fulfillment WorkBench "Job Fulfillment" Search (BAQ TAB) Epicor ERP 10	18	4053	May 14, 2021

Add A Filter to Fulfillment Workbench

Related topics