Payments applied in sales transaction window. User posts the invoices and then applies payment to the invoices. The Unapplied amount is supposed to 0 out after being applied but the Original Amount and Unapplied amount both have the same number still. This is in the Apply Sales Document window.
I ran Remove Paid Documents and also reconcile on the customer but nothing seems to have changed. Any idea of what is wrong or what can be done?
Thanks!!
*This post is locked for comments
RM Tranaction Unapply is in PSTL. It's free now so just download and install. :)
That sounds like a good idea. I cant find the RM Transaction Unapply tool yet but will keep looking. Thanks! Will keep you updated!
Try using the RM Transaction Unapply tool, bring the transactions back to Open, run Reconcile against the Customer then apply the transactions back.
Another approach is to run an update script against the transactions involved, zero out the current transaction amounts, then run Paid Transaction Removal. This should move the payment to history. I recommend doing this on a test company though before you apply it to the live database.
The invoices will go to History if Paid Transaction Removal is processed. You may want to check RM30101 and RM30201 for the invoices.
If you have PSTL, try using the RM Transaction Unapply tool which should bring back the invoices to Open status.
When i select the payment from the RM20201 table I see that it is applied to all of the Invoices (POSTED = 1) but a couple have missing TRXSORCE fields. THe main thing that is freaking out my user is that the APply Sales Document window still has that money sitting there.
Tristan,
The payments themselves don't show up anymore. They look like they are paid already. The Apply Sales Document window still has the payment sitting there but the Invoices that were applied to show up in History because they were posted already. Very weird.
Does the invoices the payments are applied to have the same issue? Is the Apply Sales Documents window modified? Is the issue happening to all users or just the one use who applies the payment?
I can recommend asking the user to go back to the Apply Sales Documents window and un-applying / re-apply the payments to the invoices and check what happens.
I also recommend checking the RM20201 table to verify if the apply record exists.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,302 Most Valuable Professional
nmaenpaa 101,156