Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Upload Journal and Settlement Invoice

(0) ShareShare
ReportReport
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,647 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,647 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.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans