You’re offline. This is a read only version of the page.
6,775
How do you remove a sales payment from an SOP invoice? The payment was previously entered and invoice saved, meaning the deposit/payment posted to GL, is that correct? Upon trying to remove said payment, the options to do so are greyed. What can be done to resolve?
*This post is locked for comments
That is really strange. GP does not do any kind of 'refresh' on its own. The only thing I can think of is that possibly check links was run again. Often, depending on the issue, check links needs to be run more than once to properly address all the issues.
In any case, glad you were able to solve this!
Thanks Victoria. Strangest thing.. I was able to remove and re-insert the payment from the Sales Payment entry screen this morning. Then, I was able to post without any errors. Does GP refresh occasionally by itself? Noticed that the records for the invoice were only available in RM00401 after posting as well. Strange!
If you have run Check Links as the KB article suggests and the problem is still there, then this may need to be fixed directly in the tables. In that case, I don't think that's something that can be resolved with forum posts without looking at your data. You may want to talk to you GP Partner or the Microsoft Dynamics GP Support to help you fix this.
Just checked SQL following the KB article but record is not in the RM00401! Perplexing, I guess I will have to dig deeper...
Sorry for not being clearer. The overarching problem was that the invoice would not post. Error message, 'The payment number is not reserved in Receivables Management'. Following KB Article support.microsoft.com/.../862199, I ran Check Links. Error remained. I wanted to try removing the cash payment and inserting it again and then attemping to re-post the invoice. This is where I ran into the issue of being unable to remove sales payment. I wanted to attempt deleting the invoice on the user end first before touching SQL. Thanks
What exactly is the problem we are trying to solve? Was the payment entered incorrectly? Did it not actually happen? Just trying to understand what the end goal is.
Hi Victoria,
I attempted to delete and void but GP will not let me: "You cannot delete a document that has posted deposits." Do you have any ideas on what would be the next step?
If you have a test company, you may want to test all of this. But yes, in theory, if you delete the invoice, the payment should be available to either apply to another transaction or to void. I would not recommend doing anything directly in the GL with this, as that will then not match your subledgers.
In theory, if I were to delete the invoice document, then would that free up the payment? I would have to remove the JE from GL attached to the payment, too, i imagine. Then, perhaps I could re-enter a new invoice and see if that posts correctly.
I would have to test this all to be 100% certain, but if there is already a record in the GL for this, I believe that means the payment was entered prior to the invoice being created (when the transaction was still an order). In this case, you will not be able to remove it from the invoice.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (