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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Active VO not availabl...
Microsoft Dynamics SL (Archived)

Active VO not available in "Payment Selection (03.500.00)" screen

(0) ShareShare
ReportReport
Posted on by Community Member

I have an active VO ready for payment.  It is active and not selected.  In "Payment Selection" screen there are no open batches.  When I hit f3 under Detail --> Reference Number the VO I am looking for does not appear in the list.  Any suggestions?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    Both checks, and also the void check are period post 10-2015.  Thank you for this information!

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    John is correct (and beat me to the response).  I suspect the original check was posted to an earlier  period and then the void and re-issue was posted to 10-2015 but you still have AP set to 09-2015 (or set the aging period back to 09-2015) when running the report.  So, the voucher would have not shown on the 09-2015 aging until you voided the check and re-issued it both to 10-2015.

  • Verified answer
    John_Joyce Profile Picture
    John_Joyce 1,042 on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    Depends on the "Period" that you're running the Period Sensitive Aged AP report for. If the voucher was entered prior to 201510, and you run the report for a period prior to 201510, then the voucher will appear as an open payable, as it wasn't paid (closed) until 201510.

  • Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    Thank you so much for all your responses.  Further look into this VO, I see that there is a check, and a void check, then another check. The PerClosed ad AdjgPerPost is 201510. But I guess my question would be why would this VO be in the "Period Sensitive Aged AP - Detail" if there is a check applied to it already?

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    If docbal is now 0 then something was applied to it 9at least under normally circumstances.  You should also look at the perclosed field of that voucher to see if that is a future period.

    To see if SL thinks something has been applied to this voucher, you could run the following SQL command:

    select * from adadjust where adjdrefnbr = nnnnnn

    nnnnnn being the voucher number in question

    If this comes back with some results, look at the adjgrefnbr and adjbatnbr fields to find the batch and the reference number that was applied to this voucher.  Also look at the adjgperpost field to see what the posting period of the application was.

    If this query comes back with no results then we explore further.

  • Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    In Release AP Batches screen there are no records on the grid.

    curydocbal=0, docbal=0, applyamt=0, Status = A.

    In the Trial Balance (All Document Format) this VO does show up. Doc Amt is the amount of the VO. Doc Balance =0.

    I do have access to SQL.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    Odd that the opendoc is false (0) unless the voucher has been paid.  Are you sure that there are no suspended AP batches (use the release batches screen to see if anything shows in the grid)?  What is the curydocbal and docbal values for that voucher?  Also, what is the status of that voucher?  Was the applyamt = 0?  We may have to run a query against apadjust to get a few more clues.  Do you have access to SQL Server Management Studio?  You could also look at the vendor trial balance / all documents format to see if it shows this voucher and what paid it.

  • Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    Hi Rick, this is great!  Thanks.  OpenDoc=0 for the record that I am looking for.  That explains why it does not show on F3.  How do I determine why the flag is 0?

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Active VO not available in "Payment Selection (03.500.00)" screen

    The PV behind that field has the following criteria:

    APDoc.DocType  in ('AC','AD','PP','VO')

    and APDoc.Status = 'A'

    and APDoc.CpnyID like @parm1

    and APDoc.RefNbr  like  @parm2

    and APDoc.OpenDoc  =  1

    and APDoc.Rlsed    =  1

    and APDoc.Selected = 0

    and APDoc.VendId   =  Vendor.VendId

    and Vendor.Status <> 'H'

    You have already checked to see if the voucher is part of another payment selection batch but you did not mention if any of those batches have an S status.

    You should check to see if the vendor is on hold status or that AP voucher is on hold status (use document maintenance).

    If neither of these is the case, use Quick query to look at the opendoc, rlsed and selected fields.  You should also look at the curydocbal field, the applyamt and the applyrefnbr fields for some clues.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans