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

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
sekhark 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Ludwig,

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

This is regarding data migration purpose.

Thanks,

Sekhar

Was this reply helpful? Yes No
sekhark 86 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sekhar,

Can you tell in detail how you tried to mark the settlements?

Was this reply helpful? Yes No
sekhark 86 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi André Arnaud de Calavon,

There is one field "MarkedInvoice", I have given the existing invoice number in "Markedinvoice" filed. Attached the screenshot FYR

Was this reply helpful? Yes No
André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
sekhark 86 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,230 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sekhar,

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

Was this reply helpful? Yes No
sekhark 86 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No