We have Epicor ECM that we do all the validations in ECM before ECM creates the invoice in the batch in Epicor, it creates a new batch every day with the date, the business is asking if there is a way to get epicor to automatically post that batch at the end of the day to simplify some steps.
Just my opinion, but I would not do that. The general practice of Edit List review for a balanced GL journal entry would be skipped and potentially create more work to correct it.
If your GL distribution in AP is simple, or any other factors that would warrant skipping the review before posting, then go right ahead.
As for a solution, I’m not sure of the best way to do it, but you could create a custom API datalink that initiated the posting process, OR you could create a BPM or DD that monitored a value on the AP Group (updated by your ECM workflow) which would trigger the posting process. Or if you have some other API Automation tool…
I believe our GL distribution for AP is happening in ECM. They map the AP invoices in ECM to the GL. @swilliasc111 can confirm, he built most of it for us .
I agree with Mike and Scott on this. Printing and reviewing the Edit List is an important part of validating that the automation worked. I understanding wanting to achieve near 100% automation, but this is one process I wouldn’t touch.
For information only you could do this with process sets, provided the generated AP invoice group had the same name every time.
If you were adamant on having the group id based on a date then you would need to run a scheduled function to update the ice.ProcessTaskParam.GroupID prior to the process set schedule from being run.
We do auto posting for shipment invoices nightly. Shout out to @aosemwengie1 for the help with that. Similar process, but no need to mess with the ProcessTaskParam.GroupID as it is static.
We created a process set for AR Shipment invoices, added the GetShipments (using Generate Shipment Invoices menu) assign the Group ID. Create 1 shipment invoice in this fashion, open the group then post it adding the posting to the process set.