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.
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.
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?
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.
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:
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:
Well Let me start by saying I buckled up 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
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.