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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Payment Journal problem

(0) ShareShare
ReportReport
Posted on by 290

Help! We have a problem that occurs occasionally where have created a payment journal, printed checks and posted the payment journal only to discover that no check was printed for one or more vendors. AX is showing a vendor payment posted to their account. It isn't allowing me to reverse the payment transaction from the Vendor Transactions screen because it was offset by a BANK transaction.

  1. Is there a setting that can be changed to set "Method of Payment" to default for all newly created vendors, or failing that, make that field copy from another legal entity without changing code? I'm having to set the vendor up and copy to 2 other legal entities, and I obviously  missed setting a default payment method on this one copy.
  2. For this particular instance, what's the recommended way to reverse the payment? There's no check to reverse in Cash & Bank Management. I've don't multiple GL entries in the past to force a balance back open on the vendor, but that doesn't seem like the best way to preserve
  3. Is there a way to prevent the payment journal from posting if payments aren't settled with a check? (That's currently our only method of payment).

Edited: The vendor invoice was not settled. The payment is showing on the vendor's account, producing a net payable of $0.00, but the invoice remains unpaid.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Pranav Kumar Profile Picture
    on at

    Hi Steve,

    1. I am not sure if there is a default setup to mark method of payment. Since all the entities have their own method of payment, it needs to be attached in different entities. Meanwhile, did you considered sharing vendor master across entities along with method of payment?

    2. You can reverse the transaction through check. Go to cash and bank module and open checks. Select the check number and you have option of revering payment there.

    3. On the method of payment check, you can setup status like check. This is recommended for check as system won't post payment journal if the status is not sent, which means it ensures check is generated.

    My question: If the invoice remains unpaid and if there is a payment transaction also, you can manually settle those.

    Is this happening quiet frequently in your environment? This issue seems weird.

    Pranav

  • PaladinSteve Profile Picture
    290 on at

    Hi Pranav,

    I'm not sure if sharing vendors is an option as we need to be able to set default warehouse and site on the purchase order defaults, as well as site and department on financial dimensions, at the legal entity level. The way the system is configured currently, the vendor is created in one entity and copied to the other two. They are linked somehow, as changing addresses on any one version updates all, but I do not know if that counts as being shared.

    On the second item, no check was generated, but a payment was posted to the vendor's account. Therefore, there's nothing in Cash & Bank to reverse, or if there is, it isn't in the list of checks where I'm used to looking. If there's someplace I can go in Cash & Bank other than checks to reverse a non-check transaction, please let me know. It wasn't an option in the transaction list under the bank account.

    On item three, that sounds like you're saying I can set up a control somewhere. Can you provide more detail?

    I'm not trying to settle the unpaid invoice against the payment, because no payment was really made. I am looking for a way to reverse that payment. I may end up having to do it through the general journal, but I'm hoping there's a place somewhere where I can make the system reverse it because going through the general journal doesn't create any tie back to the transaction containing the error.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello PaladinSteve,

    For No. 1: I believe this can be achieved if you make use of vendor templates from which you chose from when setting up new vendors. If the template vendor includes a specific method of payment it will default for all new vendors setup.

    For no. 2: Please see the answer of Pranav.

    For no. 3: The payment status field in the method of payments form - as mentioned by Pranav - is a good choice. Depending on your payment process you can additionally make use of the payment control parameters to ensure that all necessary payment information have been provided.

    Regarding your question about the invoice settlement: If you forgot to mark/settle the invoice while making the payment you can do that later on from the vendor - open transaction editing form. Simply identify the invoice and the payment made, mark them and update the selection you made.

    Best regards,

    Ludwig

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans