Vendor Payment along with invoice settlement through data import export framework

(0) Share

Report

Posted on by sekhark

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

All responses (10)

Answers (1)

sekhark 80 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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".
Verified answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

Hi Sekhar,

Is the transaction marked with the 'Approved' field? If it is not approved, it is also not available for settlement.
sekhark 80 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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".
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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).
sekhark 80 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

Hi André Arnaud de Calavon,

There is one field "MarkedInvoice", I have given the existing invoice number in "Markedinvoice" filed. Attached the screenshot FYR
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

Hi Sekhar,

Can you tell in detail how you tried to mark the settlements?
sekhark 80 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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.
sekhark 80 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

Hi Ludwig,

Yes. I have imported lines into a vendor payment journal and posted this journal.

This is regarding data migration purpose.

Thanks,

Sekhar
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor Payment along with invoice settlement through data import export framework

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