Hi, we have imported the vendor payment journals through data import/export frame work and posted with marked invoices for Invoice settlement. But the settlement was not happend still showing the original invoice in open settlement transactions and the payment transaction also not appeared to do manual settlement. Can anybody give me the solution.
*This post is locked for comments
Thank you André Arnaud de Calavon.
Yes. It was observed that "Approved" is not marked in VendTrans Table. So, we have taken technical support to mark it as Approved. then transactions are appeared in "Settle Open Transactions".
Hi Sekhar,
Is the transaction marked with the 'Approved' field? If it is not approved, it is also not available for settlement.
Hi André Arnaud de Calavon,
Yes. It is already enabled. I am not able to do manual settlement also because the payment record is not appeared in "Settle Open Transactions".
Hi Sekhar,
Did you enable the options on the target entity called 'Run business validations' and 'Run business logic in insert and update methods'? Also enabled it on the processing group? If not, it might indeed have skipped the logic to do the actual marking for settlement.
If you have already posted the journal, you have to manually settle the transactions afterwards from the customer form (Settle open transactions).
Hi André Arnaud de Calavon,
There is one field "MarkedInvoice", I have given the existing invoice number in "Markedinvoice" filed. Attached the screenshot FYR
Hi Sekhar,
Can you tell in detail how you tried to mark the settlements?
Hi Calavon,
I have used opening balances entity to import and have linked the marked invoice for settlement purpose.
It is fine even it has no option to settlement before posting. But my query is I have already posted the journal still neither settlement happened nor payment record shown under open settlement transactions of vendor to do manual settlement.
Hi Ludwig,
Yes. I have imported lines into a vendor payment journal and posted this journal.
This is regarding data migration purpose.
Thanks,
Sekhar
Hi Sekhar,
In addition, can you tell the exact steps you performed to import the journal, link the transactions and post the journal? Did you use the General journal entity? So far I had used this entity, it has no option to provide settlement details before posting.
Hello Sekhar,
To clarify the issue: You imported lines into a vendor payment journal and posted this journal.
Is that right or did you do something else?
Why did you import those payment lines? Was this for data migration purposes or do you usually import all payments this way?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156