1,540
For some reason the Search is not working in the GP Forum.
We had a glitch during processing where a Payment was applied to an Invoice, and now the Unapplied Amount shows almost double of the original payment.
I know there is a way to fix this with turning off posting to history, entering a dummy invoice and applying, then removing the dummy and running paid trx removal. I am looking for something with the exact steps but cannot get results.
Thanks.
Hi Barb,
That's a great find! Multicurrency always throws a wrench in my suggestions.
Other places you might want to check are the Transaction Inquiry/Zoom windows for the documents involved, and their Apply windows.
Otherwise, it sounds like you got this one taken care of! Let us know if there's anything else we can assist with.
I was able to find two tables that have the amount I'm seeing on screen.
In our Test environment I ran these two statements and reconciled Customer Outstanding and Current, and I see no remnants of the issue:
This one changes the Unapplied amount to 0.00 that is displayed in the Apply Sales Documents window:
UPDATE MC020102 SET ORCTRXAM=0 WHERE DOCNUMBR='PYMNT00XXXX'
In that same window, in the Document No. Lookup, this one changes the Amount Remaining column to 0.00
UPDATE RM20101 SET CURTRXAM=0 WHERE DOCNUMBR = 'PYMNT00XXXX'
Back-end updates in a Live environment are always scary. Is there any other places in GP that I should look to verify all is good?
Customer Summary looks good.
Hi. Thanks for the suggestion to use PSTL. I tried this but because it is a multi-currency transaction it will not unapply.
I likely will contact our VAR for help after a bit more testing.
Hi Barb,
You could also try using the RM Transaction Unapply feature in Professional Services Tools Library (PSTL). That will fully unapply the cash receipt, then you can run reconcile on outstanding document amounts and customer info to make sure the current transaction and applied amounts are accurate, and finally reapply the cash receipt.
Just be careful with the options selected when unapplying, typically you will want to choose One Payment. That will just unapply the selected document from any documents it is currently applied to, it will ignore any documents those applied documents are also applied by (like credit memos and other payments). Unapply All can be used to unapply ALL documents beginning with the document selected (which can spiderweb out to unapply unintended documents).
If you are still having issues, you could always open a support case and we'd be happy to take a look at the data in detail.
I hope that helps! Please let me know if there are any further questions.
I did that first and it showed 19000 before and 10000 after in the results. I also ran checklinks on open Receivables.
Ex. Cash Receipt was for $10000. Unapplied still shows $19000.
When in the Apply Sales window, I look up the Payment, and in the selection window it has 10000 in both columns but when I select the Payment, it shows there is still an amount UnApplied. User applied the 10000 but it still shows 9000 unapplied.
Weird stuff: In the RM20201 table, for the first Sales doc that was marked, it showed -9000 applied (not exact amt). So i unmarked the apply in GP, clicked OK, went back in and marked it. Now that weird amount is gone from Rm20201 but the window still shows 9000 unapplied.
Under Sales > Utilities, select Reconcile. Choose Outstanding Document Amounts, select the customer in the From and To fields, then click Process. This should take care of the document balances. Once done, run a reconcile on Current Customer Information to fix back the summary balances.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (