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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / AP vendor payment jour...
Finance | Project Operations, Human Resources, ...
Suggested Answer

AP vendor payment journal - combine to one line per vendor

(0) ShareShare
ReportReport
Posted on by Laurend217 24

Hi, 

We are trying to create vendor payment journals using the payment proposal function, but cannot get the transactions to combine/summarize per vendor, only per invoice. 

I have set the period field on the method of payment to 'Total', and using the summarised date to allcate the same payment date to all invoice, but still the payment proposal creates the payment journal with individual line/voucher per invoice (creating individual remittances and bank transactions).

pastedimage1675922511762v1.png

pastedimage1675922571071v2.png

Is there any other config that could be impacting this? The voucher settings on the journal name or something like that?

Thanks
Lauren

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,109 Super User 2025 Season 2 on at

    Hi Lauren,

    This has been a long time ago for me. Does all the vendor transactions have this method of payment linked? What exact (electronic) file format is linked to this method?

  • Laurend217 Profile Picture
    Laurend217 24 on at

    Hi Andre,

    Thanks for your reply!

    Yes, I can see all of the invoice transactions have this method of payment assigned as well.

    The extract file format is set here, there were minor development changes made so it will import to the bank 

    pastedimage1675994535158v1.png

    Is this the info you are referring to?

    Thanks
    Lauren

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 19,854 Most Valuable Professional on at

    Hi,

    Is it possible for you to share the screen shot of the proposal form and journal line created.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

    Hi Laurend217,

    Ref. to Microsoft, you can use automatic payment proposal process with following methods:

    Invoice = Create one payment for each payment proposal line; this is the default value for this field.

    Date = Combine all payment proposal lines that have the same payment date.

    Week = Combine all payment proposal lines that have a payment date in the same week.

    Total = combine all payment proposal lines for the same customer.

    Like Andre mentioned, before generating payment proposal, please check vendor transaction and make sure that they have the specified method of payment.

    Nb. Transactions that are involved in  this process must have approved tag. 

  • Laurend217 Profile Picture
    Laurend217 24 on at

    Hi Billur,

    We are working through this now, and I suspect the issue is the Total field was only selected in the entity we are making the payment in (centralised payments). I will get back to you with a screenshot of the proposal and journal lines if we are still having issues here.

    Thanks for your help!

    Lauren

  • Laurend217 Profile Picture
    Laurend217 24 on at

    Hi Alireza,

    We are working through this now, and I suspect the issue is the Total field was only selected in the entity we are making the payment in (centralised payments). I will get back to you with if this doesn't work, and yes I checked all the transactions are being marked as approved from what I can see.

    Thanks for your help!

    Lauren

  • Laurend217 Profile Picture
    Laurend217 24 on at

    Hi All,

    We have identified that the method of payment setup was not consistent across all entities (eg. only set to 'Total' in the company making the payment, all other entities set to invoice).

    There was also some invoice transactions missing the payment method stamp as well, these would then split out into a separate line on the journal.

    Working better now!

    Now we are looking into how the invoices are prioritised and selected with the due dates...

    Thanks

    Lauren

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 19,854 Most Valuable Professional on at

    Hi,

    If posted ones do not have method of payment you can update on payment proposal if required. 

    In AP parameters you can select the settlement priority under settlement tab

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans