Hi,
I am new to working with the backend of Epicor. I’d appreciate any help with the following requirement.
Background:
We have around 4 picking / packing employees. Orders are allocated to each of them through order fulfillment workbench > Actions > Allocate by part.
Once the parts are picked, the pickers process the transaction in their shipping guns (Equivalent of the “My material Queue” module).
This pushes the orders/lines from the material queue into the picked orders list. The picked orders list is a common list that displays orders / lines picked by ALL 4 pickers.
Requirement:
The requirement is to display any identity of the picker / pack station (SelectedbyEmployee ID, pack station etc.) in the picked orders grid so each picker can identify without confusion, the parts/orders picked by them for further processing.
So far, I found that the SelectedByEmployeeID field in the MtlQueue table holds this value. However, I cannot link the MtlQueue table to the PickedOrders table directly because each record exists only in one of them at any point in time.
One solution I thought about, but have been struggling to implement is to use a table as a middleman to hold the value from the ERP.MtlQueue table and to pass it to ERP.PickedOrders table later.
I’m trying to find a table (user defined) that can be made to hold the value of the SelectedByEmployeeID permanently when the MatQueue.Getrows method runs when a picker opens “My material queue”.
Later, when the “Picked Orders” is opened through Customer Shipment entry > Actions, I want to retrieve this value into any unused field in the picked orders table through the PickedOrders.Getrows method.
It is highly possible that I am looking at this the wrong way entirely and that there is a really simple solution that I am not thinking about. Any help would be appreciated!
Thanks in advance!