Payments with duplicate entries

Hi guys,

We have had this problem before and I just don’t know how to fix it myself. I have tried updating the ledger and it worked for some of them, but these two won’t go away on my AP Validation report Anyway, let me know.
Bad Amount! AP Payment 8935 Cash + Discount Amount - Debit Memo Amount: 8868.75 G/L Amount: 35475.00000000

Bad Amount! AP Payment 9414 Cash + Discount Amount - Debit Memo Amount: 2439.97 G/L Amount: 4879.94000000

Also, regarding the AP Validation report. It keeps giving me these bad dates and all of them that I have seen have to do with canceled items. I have tried to fix those too and some fix and some don’t, but it is the GL ledger entry that was canceled that is causing the report to give us that information. That seems like it wouldn’t be necessary. Here are some examples of those too:
Bad Date! AP Payment 9992 should have 2023-03-31, has 2023-03-23
Bad Date! AP Payment 10001 should have 2023-03-31, has 2023-03-27
Bad Date! AP Payment 10006 should have 2023-03-31, has 2023-03-27

Thanks!
Kelly

It seems that those bad dates are also causing problems with the delta and there is no way to fix them. I have tried multiple things. Let me know when you can.

Thanks,
Kelly

@kellym

Thanks for reaching out! I am going to look into this and get back to you ASAP.

Thanks,

Cetec ERP Support

@kellym

I have a partial solution for some of the payments. I am going to send the other ones over to accounting to take a look. Here is the current solutions.

Change the date to 3/31/23 here for Payment 9992 and it will fix it: Cetec ERP

Change the date here to 3/31/23 for Payment 10006 and that will fix the issue: Cetec ERP

For the other 3 payments I’m not sure yet as those are a bit more complicated. I’ll get back to you as soon as I have a solution for those as well.

Thanks,

Cetec ERP Support