2,845
Hi All,
I have one invoice which showing as applied by some unknown cash receipt. Since, the cash receipt is not valid, I am planning to unapply that cash receipt and make that invoice to be open. Can anyone suggest me how to do this from backend? Because, I am not able to access that cash receipt from UI, So I am thinking I have to correct this isseu from backend. Or, any other way to resolve this issue?
*This post is locked for comments
Hi Mani,
First you have to update the current transaction amount then delete the apply details from Apply tables.
Finally run the customer outstanding amount reconciliation and verity the customer summary/balance.
Hope this helps!!!
Hi Soma,
Thanks for calling me and explained the functionality. As per your instruction, I did the following. Now am able to apply cash receipt for that invoice. Please correct me, If I am made anything wrong.
select * from RM20201 where APFRDCNM = 'XXXX'
SELECT * FROM RM30201 where APFRDCNM = 'XXXX'
SELECT * FROM RM20101 WHERE DOCNUMBR IN (select APTODCNM from RM20201 where APFRDCNM = 'XXXX' )
DELETE RM20201 where APFRDCNM = 'XXXX'
UPDATE RM20101 SET CURTRXAM = ORTRXAMT WHERE DOCNUMBR IN (select APTODCNM from RM20201 where APFRDCNM = 'XXXX' )
Hi Soma,
When I am trying to unapply using PSTL, it is popping-up a warning "Apply Document XXX has been remove from History"
Thanks Vaidhy,
I used the same SP and found the applied cash receipt details. Also, I confirmed that cash receipt is not posted properly, because it staying in the table without required fields in GP. Also, the GL is not created for that cash receipt. So, I confirmed that cash receipt is not valid. Now, I have make that invoice as not applied to allow apply with other cash receipt. As per your suggestion, I will remove the applied document number from RM20201 table and and CURTRXAM to zero. are this two steps enough for making that invoice as open?
As Matt & Tristan suggested, you must first remove the apply information record from RM20201 table linking this cash receipt and the invoice in question. Once you remove that, update CURTRXAM of this invoice in RM20101 to same as DOCUMENT (if this was the only cash receipt applied against that invoice). Finally, run the customer balance reconcile process to make sure that the customer balance summary is properly updated.
This should release the invoice for apply process again. However, I would go another step further to understand where this rogue cash receipt is/was coming from.
Use the stored procedure "spSearchOnAllDB" (a custom SQL procedure created by David to search a particular value across the entire database) to locate the cash receipt voucher number or document number. Take appropriate action(s) based on what you find.
Thank for the reply,
I did the reconciliation and checklinks already. It is not cleared. If anyone know the proper steps to unapply from backend, please reply.
Back up the company database, restore into a test environment and try running check links. You could also try the reconcile feature in sales module (there's one for RM and one for SOP).
If neither of these options work and you want to do this via SQL I'd recommend doing so in test before doing it in production. You might get more insight into what happens on the back end when something is applied or unapplied by creating a dexsql.log file and watching what happens in this file when you apply/unapply something in GP (instructions here: support.microsoft.com/.../85099). You could probably get the same result by running good ol' sql trace.
Hi Mani,
When you say "unknown cash receipt", you do not see any documents when you pull up the invoice and click the Apply button?
I suggest running reconcile first against the customer in question which should correct the Current Transaction Amount of the document.
If it still persists, then go to SQL and check the RM20101 and verify that the CURTRXAM = DOCAMNT. If they aren't, then just update it.
Also, check the RM20201 and verify if the invoice is there, use the APTODCNM to check the invoice. The APFRDCNM should give you which cash receipt is applied to it.
Check the RM20201 (RM Open Apply) table on the APTODCNM for that specific invoice number. If there is a record there, that will tell you what cash receipt it is.
Another place to check would be the RM20101 and possibly update the CURTRXAM and updating that to be what it was before the bogus receipt was applied to it.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
