Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Vendor Payment along with invoice settlement through data import export framework

Posted on by 80

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

  • sekhark Profile Picture
    sekhark 80 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    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 Profile Picture
    sekhark 80 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    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 Profile Picture
    sekhark 80 on at
    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

    48234.Untitled.jpg

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    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 Profile Picture
    sekhark 80 on at
    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 Profile Picture
    sekhark 80 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    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 Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    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

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans