Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Upload Journal and Set...
Finance forum
Suggested answer

Upload Journal and Settlement Invoice

Posted on by 5

Hai..

Every day I do a manual journal for settlement invoices. I do the journal manual by uploading, while the invoice settlemet I do one by one. Can the settlement of invoices be uploaded?

I need the answer to reduce the manual work.

Thanks,

Taufik

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,641 on at
    RE: Upload Journal and Settlement Invoice

    Hello Taufik,

    Please take a look at blog below that details how breakdown of invoices can be uploaded in D365FO and settled automatically.

    community.dynamics.com/.../customer-payment-journal-and-settlement-of-invoices

    Thanks,

    Satish Panwar

    Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Upload Journal and Settlement Invoice

    Hello Taufik,

    To me it sounds as if you are looking for a tool that automatically imports, identifies and settles customer payments.

    There are a couple of 3rd party solutions available for that.

    Check out the MS Appsource as an example.

    An alternative is using the manual upload you are currently using and enhancing it by the settlement entity - the Sathih's answer.

    That's ok for 'normal' payment but not for processing mass payment data for which a 3rd party tool might be better.

    A third option is Flow/Logic App where you can create such an upload and settlement feature yourself.

    This might add some comfort to your current solution but might take a while to build.

    Best regards,

    Ludwig

  • Suggested answer
    Satish Panwar Profile Picture
    Satish Panwar 14,641 on at
    RE: Upload Journal and Settlement Invoice

    Hi Taufik,

    If you are using D365, you can leverage entity "Customer payment journal line settled invoice" for upload the settlement invoice. In order to use this, created a line in payment journal, then created a template having 2 invoices with the help of entity "Customer payment journal line settled invoice" and uploaded the file. It settled the invoices during import. you may have to play it with a bit to see how it would work in all scenarios. but something that you can utilize.

    pastedimage1570236973719v1.png

    Thanks,

    Satish Panwar

    Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans