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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Write-off In Customer Payment Journal?

(0) ShareShare
ReportReport
Posted on by 290

When I run the Customer Payment Journal report for a posted payment journal, I see there is a column available on the report for write-off amount. I cannot find a way to actually do a write off while posting the payment. I've been stuck using a dummy Fee item as a workaround, but it results in two lines being posted to the bank account, a debit for the full amount of the customer invoices and a credit for the amount written off. This works, but seems like an excessive amount of work to penny write-offs. Clearly there is a way to write-off amounts, otherwise the column wouldn't exist on the report. What am I missing?

This is a U.S. install of AX and I don't have the ability to modify the countries on the form as one workaround suggested.

Also, I am looking for a solution which will work for small underpayments as well as small overpayments.

Thank you for your time!

Steve

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Steve,

    To write off customer balances you can either use the write off function in the collection list page. An alternative is using a payment Journal and filtering small balances that you post against an expense account as a "payment". Examples how this can be realized can be found here: dynamicsax-fico.com/.../how-to-avoid-small-penny-differences-on-customer-accounts and here: dynamicsax-fico.com/.../cleansing-small-value-customer-balances-addendum

    Hope this helps,

    Ludwig

  • PaladinSteve Profile Picture
    290 on at

    Hello Ludwig,

    Apologies for the delay responding. I read through the linked websites you provided, and they didn't seem to be exactly what I was hoping for, which was a way to access the write off amount from directly within the payment journal.

    Here is an example of what I am trying to accomplish. A customer owes $5000 on an open invoice. They send payment by international wire and somewhere along the line a bank has deducted wire fees of $30. I need to fully settle the $5000 balance with a deposit into my bank account of only $4970, and the remaining $30 needs to be expensed against a "Bank Fees" expense account.

    My current process has me settling the invoice with a payment of $5000 and recording a $30 fee on the payment fee tab for the line in the Payment Journal. This gives me the net result I need, but results in showing a $5000 deposit into my bank account and a $30 fee coming out of the bank account, rather than simply a deposit of $4970 (which would then match the bank statement at month end).

    If I'm understanding your first sentence correctly then, my process would seem to need to be to go first into Writeoffs under Collections and write off the amount of $30, completely outside of the payment journal. Once that is posted, I'm left with an customer invoice balance of $4970, which I then settle with the payment. Is that correct?

  • Kristi Slininger Profile Picture
    66 on at

    Hi Steve,

    I would recommend looking into the Deduction management/workbench functionality.  You can define different deduction types, which can then be 'applied' to the invoices when you are recording the customer payment.  Here's a link to some information:

    https://technet.microsoft.com/en-us/library/dn497836.aspx

    Kristi

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans