Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

AP vendor payment journal - combine to one line per vendor

(0) ShareShare
ReportReport
Posted on by 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

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: AP vendor payment journal - combine to one line per vendor

    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

  • Laurend217 Profile Picture
    Laurend217 24 on at
    RE: AP vendor payment journal - combine to one line per vendor

    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

  • Laurend217 Profile Picture
    Laurend217 24 on at
    RE: AP vendor payment journal - combine to one line per vendor

    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
    RE: AP vendor payment journal - combine to one line per vendor

    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

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,564 Super User 2025 Season 1 on at
    RE: AP vendor payment journal - combine to one line per vendor

    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. 

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: AP vendor payment journal - combine to one line per vendor

    Hi,

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

  • Laurend217 Profile Picture
    Laurend217 24 on at
    RE: AP vendor payment journal - combine to one line per vendor

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,160 Super User 2025 Season 1 on at
    RE: AP vendor payment journal - combine to one line per vendor

    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?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans