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 AX (Archived)

Question about "Settle Open Transactions Vendor Form"

(0) ShareShare
ReportReport
Posted on by 120

Hi everyone, thanks in advanced for any replies.

I have some questions about this form, normally I would test them in our test environment but we had an issue with it and I can't use it for a few days. So I am hoping to get a quick answer here so I can fix this issue I am having.

There is an invoice for $200 USD, we are Canadian and it was paid under the wrong exchange rate so it still shows as open, "Amount still owing" shows a small amount, few dollars. Someone then unmarked it as settled using the "Closed Transaction Editing Form". And now the full amount is showing as an open invoice. However, when I verify the accounts, the Accounts Payable account for this transaction balances, the expense and bank accounts used are balancing as if it was paid properly.

How can I adjust this out of an open invoice without having to change the accounts because the main accounts balance correctly, but this invoice is showing as open.

I wanted to create a credit invoice and settle it against this invoice, but when I create the credit invoice it will create a Debit in the accounts payable main account won't it?

Also, when I use the Settle Open Transaction form and settle 2 invoices against each other, will this post to Accounts Payable once I update the form? Every fix that I can think of to remove this invoice can't work because when this amount was marked as unsettled and pulled back into an open invoice it never posted any changes to our main accounts.

I hope that makes sense, Thank you.

Jordan

*This post is locked for comments

I have the same question (0)
  • JordanH Profile Picture
    120 on at

    If I settle 2 transactions against each other using this form, will this post any adjustments to the "Main Accounts", or does this form simply close transactions?

    Again I can't test this in test environment because our test server is down for service for a couple days.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Jordan,

    What I got is that the wrong rate was used for the settlement, right?

    Can't this simply be fixed by using the open transaction form and the following cross rate feature?

    [View:https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/specify-the-cross-rate]

    Best regards

    Ludwig

  • JordanH Profile Picture
    120 on at

    Normally yes, but someone went into Closed Transaction Editing form and marked this as unsettled. And now the full amount is showing as an open invoice.

    Jordan

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Jordan,

    Ok. But can't you fix this by settling the transaction again in the open transaction editing form and specifying the rate you need?

    Best regards

    Ludwig

  • JordanH Profile Picture
    120 on at

    When I try this way there is no way to change the exchange rate. I have checked everywhere in the form and cannot apply the proper exchange rate.

    Jordan

  • JordanH Profile Picture
    120 on at

    If I settle this through a Payment Journal it will change the main accounts and they will no longer balance.

    If I am able to settle this through the Settle Open Transaction form will it update the Accounts Payable main account?

    How can I update the exchange rate using the Settle Open Transaction form? Everything related to exchange rates is unable to be edited.

    Jordan

  • JordanH Profile Picture
    120 on at

    This helped, was able to fix thank you.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans