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)

Methods of Payment Vendors

(0) ShareShare
ReportReport
Posted on by

Hello Guys,

We have a question, we really need a continuos sequences for electronic payments to our vendors, per each bank account. Actually we introduce, every time we do it, the number of that transaction as a reference, but this isn´t what we really need and want it. Why?, Because is a human that do it, is an opportunity to mistakes.

We´re looking for control. Someone of you has an experience here that can share with us, please let us to know

This is our configuration at the moment, we don´t know if we are missing something to get what we want

Methods-of-Payment-Vendors.png

In payment journal we have to fill the payment reference to continue.

See below what we do

Payment-Journal-0.png

Payment-Journal-1.png

Payment-Journal-2.png

Payment-Journal-3.png

Payment-Journal-4.png

All the info you can give to us is super appreciated

Many thanks,

Emely

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Emely,

    Can you provide some additional info of what you currently get out of AX and what you need? I am not sure about the sequence you need/refer to? Is this the information about the last file number that you see in the method of payments form (which is also available in the payment journal) or something else?

    From the screen-prints above I cannot identify that a vendor is selected in the journal. Is this info missing just for illustration purposes or is this your ordinary payment process? I am asking because the method of payment and the payment reference can be setup as default values at the vendor level so that they do not need to be entered manually.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    on at

    Ludwing, before we had this

    3482.Payment-Journal.png

    But that cause a cruse between cheks sequences and ACHs sequences, for that reason we change the configurations, but now we don´t get a sequences per ecah bank and we have manually to register wich number belong to that transaction

    We have many concerns about electronic payments (ACHs)

    In file we just put whatever thing, "TF" for example, but we don´t get satisfactories results

    We want to :

    1. Have a sequences per bank for ACHs 

    2. Don´t register manually a payment reference

    3. Dynamics control the counter per bank

    For vendors we don´t set up them to an specific method or bank, because that isn´t constant, can be different as need it

    Hope to clearly

    Thanks Ludwing

  • Community Member Profile Picture
    on at

    Wire payment

  • dynamics developer Profile Picture
    2 on at

    Hi,

    If I correctly understand you need a number sequence per bank for you payment reference for each new payment to that bank. I don't think it is available out of the box and you might need to customize a bit for e.g. create a number sequence for each bank and keep it's reference with the bank and customize to generate a new number for your payment reference for each payment.
    Hope this helps.

    Regards,

    Haris

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Emely,

    If you have a method of payment for each of your bank accounts you should be able to get a counter per bank. There is a standard functionality available for electronic payments that does this for you.

    pay3.png

    For a very similar thread I posted some screenprints here [View:https://community.dynamics.com/ax/f/33/p/210230/555190#555190:750:50]

    If this is not sufficient for you or if you requirement differs somehow from this Standard functionality, you should go for what Haris suggested; that is, making a small system adjustment.

    Hope this helps,

    Ludwig

  • Community Member Profile Picture
    on at

    Ludwing,

    I see the images you posted in other question similar to our

    Is really what we want, but, We have some question about it:

    1. Which File format is the correct one, because who implemented create one named "Format 1" (this one is used to checks)?

    2. For getting that info in history tab, we need to search it in the tables you mentioned in the reference posted?

    3. Is necessary to select a specific bank account to get sequences per bank? (as you show in the image uploaded, we can´t just leave in blank?)

    4. Why period has to be total ? We have Invoice there, isn´t correct?

    We are trying to avoid adjustments or customize

    Please see our configuration for method of payment Wire payment (Transferencia)

    TF.png

    Many thanks Ludwing we really appreciated your colaboration 

    Blessings,

    Emely

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Emely,

    1) Format 1 is a default format that ships with AX and can be used for modifications. You need to talk to your bank what information they need included in the file and how it need to be structured. If you click the configuration tab you can find other formats for various countries. Unfortunately, I cannot tell you which one to use as I do not know in which country your company operates.

    2) The history tab in the payment journal shows you the sequential number and the date at which the electronic payment file was created. The fields should be there out of the box.

    3) If you want to have a continuous number sequence for a bank I would setup one single method of payment for each bank. You can leave the field blank and allow users to select the bank in the payment Journal. Yet this includes the risk that the 'wrong' bank account gets chosen

    4) Total means that AX summarizes all payments for a single vendor in the electronic file. If you pay let's say 5 invoices, 1 amount is included in the file. If you select invoice, the individual invoice Information is included in the file. Whether you select total or invoice also depends on 1); that is, what you bank Needs included in the electronic payment file.

    Hope this helps,

    Ludwig

  • Community Member Profile Picture
    on at

    Ludwing,

    1) Why a need to talk with my bank? Actually we are not sending documents from my System to my bank, is this a priority? We are in Dominican Republic.

    For wire payments (in banks plataforms) we use any document, just one of our bank require a txt with the info for ACH payments

    2) Just one of the vouchers in whole journal is showing us the sequences. All the others are missing

    3) Ok, make senses to me, I think we are going to analize this option for implementing

    4) All right, we want to conserve the option invoice than total. For payroll payments, electronic payment works perfectly we don´t know why is so difficult to have it for our vendor´s payment

    All your interventions are so important to us,

    We are so very thanksful,

    Emely,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Emely,

    1) Oohh. I thought that you want to generate the payment file out of AX and sent it to your bank in order to initiate the payments. Doing this is of course not a must but nice if you can use the standard formats available. If you do not need to do this because your process is different, then you do not need to contact your bank. We regularly do this here in Europe to ensure that the file that we get out of AX can be read by the banks system.

    2) If you do not need to generate the electronic file to make your payments then you need to think whether and how you can use the number sequence that is created when a payment is generated. All what I mentioned before was based on the assumption that you generate the payment / payment file in the vendor payment journal, which would create the continuous number. Yet, if  you do not have to generate an electronic payment file for your bank I am thinking whether it might be smarter not using the standard number sequence that is generated by the system when generating a payment file but doing a system modification with a separate number sequence field that might fit your process better.  Probably try testing the standard method of payment a bit more to see if it fits for you or not.

    4) I just saw a reply from a MS employee for a similar issue here community.dynamics.com/.../149376. Maybe this thread gives you some additional ideas.

    Hope this helps,

    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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans