Ever since the last update freight charges keep disappearing off our orders/invoices. It’s really starting to mess things up.
This customer had overpayment credit from invoice (8323.1) so I applied some of it to a different invoice (8991.1) and then discovered that the overpayment amount was wrong because the freight had been deleted off of order/invoice (8323.1-1). This is about the 7th invoice we’ve discovered deleted freight on. Anyway, after I added the freight back on to (8323.1-1) I tried to re-open the payment and apply it correctly to the first invoice (8323.1-1) so I could figure out how much they actually owed us on the second one (8323.1-1). It did not work and now the payment is all kinds of messed up and I can’t apply anything correctly. I need someone to help me figure this out.
Here’s an explanation on why the freight disappeared on that invoice. If you go to the usage logs and look for /order/MN8323.1/update_invoicing you can see that the freight was changed to $0.
You re-opened AR Pmt 4632, zeroed out the applied value but left the UC and the Invoice checked, here: Cetec ERP
You will need to re-open AR Pmt 4632 and un-check the include boxes on both, and close AR Pmt again. You will need to check to see the AR Pmt is still connected to that Invoice, or if you are now able to Apply the UC to the other Invoices for that customer.
Ok now I’m even more confused. Where did the original payment (4233) for $49,472.38 go? That one I never did anything with and it’s no longer applied or showing up in their statement.
We discovered yesterday afternoon the Unapplied cash not unlinking from the Invoice/Order was a bug and has been fixed. So that is why it is no longer applied. Now you can just apply the unapplied cash where you need to apply it to.
But it’s not even showing up under unapplied cash. Only the one that I was trying to change is. There are two payments. One from 5/9 for $$49,472.38 Payment # 4233. This one was applied already and I never messed with it. And one for $47,907.37 from 9/6 which is the one that was having the problems. Now the first one is not applied and is not showing up.
Kali,
I found AR Pmt #4233 for $49,472.38 on the AR pmt List, filtered ‘All’ for Status. It is now Unapplied Cash #2247, on Deposit #4175 on 5/9/22.
It likely is cleared on Acct Reconcile 197.
The AR Pmt needs to be re-opened, updated and pmt complete because something happened to ‘un-check’ the ‘include’ box. Likely when you try to do that you will get a warning that AR Pmt #4233 is reconciled on Acct Reconcile 197. Navigate to the Acct Reconcile 197 (5/31/22) and mark status ‘Open’, uncheck Deposit #4175, and click Update button, but leave open. Then go back to AR Pmt#4233, re-open, check include box for the Unapplied Cash #2247, and click Payment complete. Navigate back to the Acct Reconcile 197, click box on Deposit #4175 to reconcile and Update the Acct Reconcile 197 again, marking status as ‘closed’.
When you have attempted these steps, please reply here again as to whether this corrects this issue, or if you still need further assistance.
