Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Can't Select AP document marked as selected

Posted on by Microsoft Employee

Hi,

We have an issue with selecting certain AP reference numbers.  The AP clerk enters the AP Voucher the same as all the other VO (they all have been in a batch with other VO), but when we go to select the reference number in the Payment Selection screen- it says "Item not found". 

When I go into the Document Maintenance screen to see if it has been selected, it is marked as selected.  The problem is that we are not able to select certain reference numbers and the VO is staying on the aging and we are not able to cut a check to the vendor out of SL.  We are not able to select this reference number for anything (I cannot post a manual check to it or apply an adjustment to it).

I have verified the following:

1. In Payment Selection there are not any open batches.

2. In AP Check Update (Post) there is nothing there waiting to be posted.

3. In a Check Register for the vendor the VO has not been assigned a check number (it doesn't show on the check register).

4. In the Unreleased AP Batch report everything is posted (nothing appears on this report).

5. Ran the Document Register for that period to check and ensure that it appeared the same as the other VO (looks the same).

Any suggestions/help would be appreciated!

 

*This post is locked for comments

  • wahoo Profile Picture
    wahoo 275 on at
    RE: Can't Select AP document marked as selected

    Thanks very much Carolyn.   These instructions were great and solved my issue today.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Can't Select AP document marked as selected

    Thanks Carolyn and Stacy for your support... Appreciated!

  • Verified answer
    Stacy Roach Leslie Profile Picture
    Stacy Roach Leslie 305 on at
    Re: Can't Select AP document marked as selected

    Carolyn's instructions are perfect.  The only way to unselect the vouchers is to set them back to a "0" status.  I hope that this helps.

  • Verified answer
    Re: Can't Select AP document marked as selected

    Hello Eric,

    Releasing a voucher batch will normally not mark the Selected field.  I'm not sure why the documents would be selected for payment if no one had selected them for payment.  The only way to clear the Selected field is with a SQL statement.  A good backup of the database would be advised.

    You could run the following select statement to determine how many vouchers are marked as selected.

    select refnbr,vendid,DocBal, * from Apdoc where Selected = '1'

    If you are satisfied with the results of the select and you would like to set the Selected field back to 0 (zero) so that they can be selected for payment, you could run the following statement:

    update apdoc set Selected = '0' where Selected = '1'

    Or, if you only want certain reference numbers affected, you could specify which vouchers you want to update.

    update Apdoc set Selected = '0' where refnbr = 'xxxxxx' and Selected = '1'

    Let me know if you have additional questions.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans