Could anyone advise whether we can update the payment status in D365 Finance in bulk, for example by running an X++ script or using an existing function?
Our current issue is as follows:
D365 Finance → TMS: payment data sent
Kyriba → Bank: payment instructions
Bank → TMS: ACK file (transaction-level confirmations)
Kyriba → D365: payment status updates via API
Problem: The bank cannot provide transaction-level ACKs, so the TMS status does not update. As a result, D365 never receives the status change, and the payment status remains as “Sent” or “None”.
We are looking for a method to update the payment status to “Approved”; otherwise, we cannot generate the GL entries.
Out-of-the-box, there are two alternative ways to update the payment status:
1. You can update the payment status manually. If you develop (or buy) a solution, it must automatically replicate the payment status update that the user is supposed to perform.
2. The status is update from the advance bank reconciliation. Here a quick panoramic:
- You need to use a payment method's type as "eletronic payment"
- You create you payment journal, set the status as "sent" and post the journal:
Into the bank master data you need to mark the fag "Use bank statements as confirmation"
When you will reconcile the transaction, the payment status will be update as "Received".
Thank you,
Giorgio
Was this reply helpful?YesNo
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.
Share
Report
All responses (
Answers (
3,417
