Fulfillment workbench

We have been using fulfillment workbench to release job mtl to the floor. I have a BAQ that looks for all materials related to a specific operation for all jobs to an order. Once the user runs that they then have to one by one got through the list of materials that the search returns and select only the ones they want. I know if I schedule the ops on a specific day that I could potentially narrow it that way but that is not an option right now. What I am trying to do is figure out what the Order allocation adapter key is and be able to fill the data set that way. I created an external program to test this and try to figure it out but it keeps retuning 0 rows.

Can anyone tell me the key for the order allocation adapter for jobmtl? Any suggestions on how to quickly allocate all parts for a certain operation on job fulfillment.

Thanks
Matt

The Fulfillment Workbench has very good filter/search functionality in it. I could not really figure it out from your post, but is the Epicor functionality not meeting a certain need?

We are trying to release all the parts for a specific assembly on every job that belongs to an order. the assembly number is not known as this can be different per job. The Epicor default functionality is not meeting our needs in anyway.

We have implemented several BAQ searches for this very reason. Using a BAQ you may be able to get exactly what you need in your searches.

Ok. Can I have a BAQ search with user input? I never created a BAQ search before.

If you need criteria, then quick search is the way you’ll want to go. It’s still based on a BAQ, but you can set up criteria that controls the filter on the BAQ.

And we come to the problem I’m experiencing. I don’t know what the key is to pull rows into the job fulfillment grid view in order to select them for Allocation. Do you happen to know the table that and key for the job fulfillment?

I believe it’s PartDtl.SysRowID

I will try that. Thank You.

Well, you learn something new everyday. I was certain it had to do with the partdtlseq. I added sysrowID to the first BAQ I tried added it to the like column and voila!! I never would have thought of the sysrowID being the key for that. Thank you so much.

One last question. The BAQ search is erroring because the parameter is empty but it won’t allow me to enter a parameter. What am I missing?

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 going to want to do is alter your BAQ.

  1. Remove the parameter
  2. Remove the PartDtl.SysRowID field
  3. Add in the OrderRel.SysRowID field

Next, open your fulfillment workbench and go to Tools->Personalization
You want to unhide the SysRowID column:
image

Bring up any order in the fulfillment workbench, find this column and right-click in it and select Quick Search Entry

Next you want to enter the information for what you want to call the quick search (don’t forget to click Shared:

Then add the criteria that you want to filter for:
image

Save and close your quick search and lastly navigate to Actions->User Preferences and type your quick search name into the Sales Order Quick Search Default:
image

Click Ok, close out Fulfillment Workbench and then re-open it. When you click on the search button on the Order Fulfillment it will use your Quick Search:
image

2 Likes

Thank you I will try it now. Thank you. I’ll be sure to keep you posted.

Well Let me start by saying I buckled up :smile: I did as you suggested and IT WORKED. This was a project that had been driving me nuts for a month or more and in 30 minutes or so was completely resolved. So I owe you for the help. to recap for anyone in the future the partdtl sysrowid is the key to the job fulfillment but in order to use a quick search with parameters I had to create the quick search using the BAQ with the orderrel table included so that we can create a quick search off the orderrel sysrowid then under user preference make it the default for the order search. this works great they search using the order search and then it will pull onto the job fulfillment tab. Now a 25 line order takes seconds to allocate the parts to specific operations designated by the BAQ. I don’t know how to thank you doug but I owe you

Thanks Again
Matt

That’s what this group is for. I can’t tell you the amount of time I’ve saved here just searching for answers. It has really helped me get out of some jams.

Glad it worked for you!