I had posted here earlier: Automating Fulfillment - Process Set
But it was two questions, one of which was solved.
Anybody doing Automated Fulfillment and having it print picks? I am able to do the Sales Order without any issues, but I can’t figure out a mechanism to print Transfer Orders. There’s no data on the TFOrdDtl about the pick like there is in the OrderRel table.
Is it as simple as comparing the PartAlloc table against the MtlQueue table after a certain timestamp?
I had it working pretty well using the timestamps on completed “Automated Fulfillment Process” tasks in SysTask. A bit of a pain because the timestamp in PartAlloc uses local, but in SysTask it’s UTC time.
There was an issue with re-allocations though. I’m sure it was an issue with Automated Fulfillment Rules, but occasionally I would get several orders re-allocating, and it would reprint several tickets.
I’ll shoot my BAQ I used to pull the records over as soon as I get back to my computer.
I came up with a process shortly after posting this. Because of the issue with doing AFP in a process set, I created a function. The function stores the local plant time, fires off the Rules for sales orders and transfer orders at each plant and then collects a list at each plant and fires off the MtlQueue Report.
The MtlQueue Records that have a Sysdate+Systime >= eFx start time are the only ones printed.