Best Way to Modify AP Payment Entry --> Select Invoices to filter out Cancelled Invoices

Epicor ERP 10
1

We ran into a scenario when our users began using the cancel invoice functionality in AP Invoice Entry and some temps didn’t go in and apply the debit memo it created to the invoice that was cancelled. For some “Epicor … The way is was designed…” reason they still permit the invoice to be paid even though the cancellation is posted. Now the invoice shows as cancelled and has a cancellation invoice ref, but was also paid and has a payment record. Finance is not happy with this scenario as it shows the invoice cancelled and paid at the same time. Epicor considers this “as designed” functionality and will not consider it a bug. After many attempts I have lost hope with the Epicor help desk.

We are looking to filter out invoices that have been cancelled from the Payment Entry → Actions → Select Invoices processes via the refcancelledby field. When looking at the SelectInvoices call under Erp.BO.PaymentEntrySvc I don’t have the whereClause like in other getlist calls and the field I need to filter in the call and isn’t returned in the post process. What is the best way and try to filter the list so I don’t have AP paying invoices that were cancelled prior to applying the debit memo?

I was thinking maybe a custom code to loop through the tableset and check each record and delete the ones from the returned table if cancelled, but that seems a bit resource intensive. Not sure if anyone had a better option.

Thanks in advance,

Lee

2

Hello @edozier … which version are you using? BTW, for above you can adopt any of these approaches;

  1. Right a BPM at the time of posting the canceled invoices, and select Payment HOLD flag as true. This way, all such invoices will not be part of payments
  2. Right a BPM on AP Payment at the time of posting to check for cancelled invoices and through warning /stop messages.

Kind Regards

3

We are currently on 10.2.700.9.

We tried option one, but Epicor blocks the ability to apply the cancellation invoice debit memo to the invoice if the invoice is on hold so we have to remove the hold to apply it at some point which produces the possibility of human error.

We are leaning towards option 2, we just need determine the best option for it as the fields I need to filter aren’t in the select invoices dataset. I would have to fetch each invoice record to check them.

1 Like
4

You are right, by holding the invoice user not able to make payments against such invoices. However, user have to un-hold them before mapping with debit memo.

Option 2 - should be OK, yes, you need to check each invoice from dataset.