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).
Is there any other config that could be impacting this? The voucher settings on the journal name or something like that?
Thanks
Lauren
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
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
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
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
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.
Hi,
Is it possible for you to share the screen shot of the proposal form and journal line created.
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
Is this the info you are referring to?
Thanks
Lauren
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?
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156