How To Fix An Open Vendor Transaction Not Showing Open For Payment

How To Fix An Open Vendor Transaction Not Showing Open For Payment

Issue/Scenario

“On the below figure 1 and 2, the highlighted invoice shows on the Accounts payable aging report (figure 1) but does not show in the Settle open transactions form (figure 2) so I cannot settle or pay it. I can see it on the Vendor Transactions form as open with a balance. It also does not come up in the vendor payment proposal. Where is the transaction and how can I mark it for payment?”

Figure 1 – Accounts payable-> Reports-> Status-> Vendor aging report

Figure 1 – Accounts payable-> Reports-> Status-> Vendor aging report

Figure 2 – Invoice is not showing for settlement. Accounts payable-> Common-> Vendors-> All vendors-> Invoice tab-> Settle open transactions

Figure 2 – Invoice is not showing for settlement. Accounts payable-> Common-> Vendors-> All vendors-> Invoice tab-> Settle open transactions

Solution

The common cause for this is that the transaction, while posted to the Vendor account and General ledger, is not ‘Approved’.
To verify and correct this, do the following:

1. Find and highlight the vendor record in the Vendor table (Accounts payable-> Common-> Vendors-> All vendors).

2. On the Vendor tab, click on the Transactions button. You will see the transaction as open. Highlight the record.

Figure 3 – Transaction is open with a balance in the Vendor transactions form

Figure 3 – Transaction is open with a balance in the Vendor transactions form

3. On the transaction in question, click on the ‘General’ tab and look at the ‘Approved’ field. You will notice it is blank. If this field is blank, the transaction is unapproved and cannot be paid or settled.

Figure 4 – Unchecked Approved Transaction

Figure 4 – Unchecked Approved Transaction

4. You can simply mark the ‘Approved’ field if the transaction was not entered through the Invoice register and is awaiting approval through the Invoice approval journal. The transaction will now show up for settlement/payment.

Figure 5 - Settle open transactions form after marking the ‘Approved’ checkbox. The transaction can now be settled/paid

Figure 5 – Settle open transactions form after marking the ‘Approved’ checkbox. The transaction can now be settled/paid

Causes of the ‘Approved’ field being unmarked

1. As mentioned in figure 4 above, one reason the ‘Approved’ checkbox might be unmarked is if the client is using the Invoice register and related Invoice approval journal to enter invoices. If these journals are being used, then the ‘Approved’ flag should not be manually marked, but should instead be updated through the Invoice approval journal as is standard procedure for the approval journals.

2. The ‘Approved’ field is not widely used. It generally defaults as marked when the invoice is created and posted and is never touched again. However, sometimes a user might manually unmark this if the transaction is in question, being disputed, awaiting a credit, etc. and the user wants to ensure that the transaction does not get paid until the issue is resolved. Since unmarking the ‘Approved’ flag removes the transaction from the Settle open transaction form, it cannot accidentally get paid or settled.

3. Sometimes it simply accidentally gets unmarked.

Blog written for AX version:

Dynamics AX 2012 R3

Solution also applies to version(s):

Similar functionality exists in all past versions (AX 2012 RTM, AX 2009, 4.0, 3.0, etc.).

Did this how to guide help your settle your issue? Is there another way to help solve this problem? We’d like to know. Please send your feedback below!

About Cindy Scott

Cindy Scott has created 12 entries.

10 Comments

  • Mudassar

    Excellent post, solved the issue

  • Oscar

    Thank you, this was the solution for me

    • Molo

      Thank you very much.

      We recommend all our connections to follow us on YouTube or LinkedIn where we will be posting a lot of new material related do Microsoft Dynamics D365 – check it out YouTube or LinkedIn

      Regards
      Team Avantiico

  • Avinash Sathe

    Thanks for the post .. Great post

    • Molo

      Thank you very much.

      We recommend all our connections to follow us on YouTube where we will be posting a lot of new material related do Microsoft Dynamics D365 – check it out https://www.youtube.com/c/avantiico

      Regards
      Team Avantiico

  • Chaichai

    Hi, Can I ask what if the issue is the Vendor Invoice appears on Settle Open Transactions but not showing up in Vendor Transactions? Many thanks.

  • Iach Aima

    Hi, can I ask what if the issue is there is a Vendor Invoice/Voucher appears on Settle Open Transactions but not showing up in Vendor Transactions? Many thanks.

  • Sarita Palo

    Really awesome way of presentation. It solved my case .

    Thank you very much. Appreciate your helping hand.

    Regards,
    Sarita

    • Molo

      You are very welcome Sarita.

      Feel free to let us know if you have any Microsoft Dynamics AX or D365 topics you would like us to solve then we will add it to the content calendar.

      We have a lot of our video content available on https://www.youtube.com/c/avantiico

      Merry Christmas

      Team Avantiico

Post A Comment

YOUR CAPTCHA HERE

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Subscribe to our mailing list

* indicates required
 

×
Learn More

Contact Us

All fields required

First name

Last name

Company

Your Email

Subject

Your Message

×

CRM Test Form

×

Influence

All fields required

First name

Last name

Company

Your Email

Proposed Webinar Date & Time
AMPM

Your Message

×

Contact Us

All fields required
×

Contact Us Here! 

* indicates required

×

We want to hear your feedback

∗ indicates required

×

Let us keep you updated!

 ∗ indicates required

×

Meet Us

All fields required

First name

Last name

Company

Your Email

Available Date & Time
AMPM

Your Message

×

Contact Us Here! 

* indicates required

×

Contact Us Here! 

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Schedule your meeting with us!

* indicates required

×

Book Your Time

×

                        RAMPUP SUBSCRIPTION PLANS

                    Choose a plan below, and one of our

              Support Consultants will contact you shortly.

×

                           PACKAGES START AT $4,999

                  Choose a package below, and one of our 

               Support Consultants will contact you shortly.

×

 Performance Review Details

 

Diagnostic Review of DyanmicsAX Server (AOS) & SQL performance and stability.

 

Written summary of findings and recommendations.

 

Up to 15 hours of issue resolution time to target your most immediate performance issues.

 

Review completed by our 100% onshore support team averaging more than 10+ years of DynamicsAX experience.

 

Get the help you need now, with no long-term commitment.

×

Functional/Department Help Pick 3

 

Help with up to 3 functional or department issues such as: invoicing, costing, closing the books, AR, AP, inventory, warehousing, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to define your issues and find recommended solutions.

 

Up to 20 additional hours of issue resolution time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

 

×

Reporting / BI Help

 

Choose up to 3 standard or custom reports for assistance.

 

Solve typical issues like: Report too slow, does not show what we need, need an additional field/column, etc.

 

Talk with our 100% onshore functional experts with over 250+ years of combined AX experience to troubleshoot report issues and recommend solutions.

 

Up to 20 additional hours of configuration or development time included.

 

Presentation of solutions and next steps from our expert team.

 

Get the help you need now, with no long-term commitment.

×

Please fill in the form to RSVP

 

×