web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

AR -Payment Journal -Automation of Minor Write-Offs

(0) ShareShare
ReportReport
Posted on by 5

In transaction Customer Payment Journal> Customer Payment -Is there a way to set up D3FO to automatically write-off payment residuals balances (within a specific amount range; example: over/under $50) for individual invoices after payment journal has settled? $50 is the amount that has been established as the threshold for automatic write-off w/o approval. If an invoice is short paid by $25, I would like it set up to automatically write off to the specified Write off GL account upon payment journal approval/settlement. Trying to reduce the time and inefficiency with clearing something that should be automatically cleared. 

Thank you in advance for any information you can provide. 

I have the same question (0)
  • Suggested answer
    Satish Panwar Profile Picture
    14,671 Moderator on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    Hi Feline77,

    Please take a look at blog below that explain how you can simplify the write-off process.

    www.loganconsulting.com/.../

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    Hello Feline77,

    The process describe here (dynamicsax-fico.com/ might help. It describes the process in AX2012, which is however similar to D365FO.

    Best regards,

    Ludwig

  • llagalla Profile Picture
    78 User Group Leader on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    Is there a way to automate this in F&O without code? 

  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,036 Most Valuable Professional on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    Hi,

    You may use the link below on how settlement is done for over/under payment. Search for results of settlement.

    https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/settlement-overview

  • Suggested answer
    saurabh bharti Profile Picture
    15,039 Moderator on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    You can try using

    exploredynamics365.home.blog/.../

    or may be setting up cash discount limit in parameters using over/under payments

  • Unknown User Profile Picture
    10 on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    Hi Feline77, Were you able to set this up out of the box? My client has the same requirements, your input will be very helpful!

  • Suggested answer
    BillurSamdancioglu Profile Picture
    19,036 Most Valuable Professional on at
    RE: AR -Payment Journal -Automation of Minor Write-Offs

    You can manage this process with to use the link below.

    docs.microsoft.com/.../settlement-overview

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,004

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 865 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans