web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

I'm getting the message 9 item not found when trying to unapply a prepayment on screen 0307000

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    Thank you Rick, but the problem is with an AP prepayment not with an AR prepayment.

  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    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.

  • Community Member Profile Picture
    on at

    Hello Elaine

    Both curydocbal and docbal are zero, and perclosed is 201309.

  • Community Member Profile Picture
    on at

    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.  

  • Community Member Profile Picture
    on at

    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.

  • Verified answer
    Community Member Profile Picture
    on at

    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.

  • C Conner Profile Picture
    310 on at

    I am having a similar issue, but with SL2015 where multiple vouchers should be able to support multiple prepayments.  Any suggestions?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans