You’re offline. This is a read only version of the page.
I'm trying to unapply a prepayment, that is applied to a document and when I enter the applied refnbr on the screen 0307000, I'm getting the message that the item is not found.
Both documents are on the same currency.
We are using Dynamics SL 70 SP3.
*This post is locked for comments
A prepayment can rightfully be applied to multiple vouchers but a voucher can have only one prepayment applied. The value is in apdoc.prepay_refnbr.
I'll check on the apadjust tables if this prepayment is in more than one batch, or if the invoice has two or more prepayments applied to it, and let you know the results.
Then I would guess that there is a data issue where multiple prepayments were applied to one voucher which is not a valid operation. That can happen when you apply a prepayment in the Prepayment Application screen but don't release it. Leave it on hold or balanced. Then add another batch and apply another prepayment to the voucher. Release both batches.
We would have to see the apdocs and apadjust records for the vendor in order to troubleshoot how to correct the data. You might need to update apdoc balances and correct apadjust tables. It is tedious.
Hello Elaine
Both curydocbal and docbal are zero, and perclosed is 201309.
Another note.
You can not apply a prepayment until you have paid it. Does the prepayment have a zero balance in Document Maintenance? It should not have a balance and there should be a perclosed value.
Hello Elaine
I did check what you asked me to check, and there is a batch on status "R", but this batch is a non printed check for another vendor, this vendor in not the same one as the one that I'm trying to unapply the prepayment.
I also tried to apply the prepayment as you suggested but the refnbr does not show up inthe F3 function.
Thank you Rick, but the problem is with an AP prepayment not with an AR prepayment.
See if you can apply it rather than unapply as it may have already been unapplied.
See if you have any H, B, S batches by printing the AP batch register report for a begin period of 01-1990 and end period of 12-4040. Select where batch.status IN B, H, S, I, K, R
There have been issues/bugs that allow you to apply multiple prepayments to one voucher. Since there is only one field available for a prepay_refnbr on the apdoc, if the system has allowed multiple prepayment to be applied to a voucher, you can not get access to unapply any but the one that is currently stored on the APdoc for the voucher. These issues have to be fixed by correcting the tables in Query/Management Sudio.
My first thought is that the payment has already been unapplied. Possibly it is part of an application inquiry/reversal batch that did not fully release so the payment is caught in limbo. Look at the release AR batch screen to see if a batch is showing in the grid.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (