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

Write off process in Sales

(0) ShareShare
ReportReport
Posted on by 145

Hello,

I am having an issue with the credit side of the write off process.  For some reason, the credit amount is blank, while when we perform a debit the value will be populated.It appears to be throwing off our AR sub-ledger as well.  Any help or thoughts would bepastedimage1581111326575v1.png appreciated.

pastedimage1581111405773v2.png

Categories:
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    855 Super User 2025 Season 2 on at
    RE: Write off process in Sales

    I'm not following exactly what is off (as I would have expected screenshots of the Distribution window.  Could it be that the Posting Account is not setup at Customer and/or Company level?

  • yayayayaay Profile Picture
    145 on at
    RE: Write off process in Sales

    Hi Lisa,

    The distribution accounts are setup, they are just concerned that the AR S/L is out ( because on the transaction inquiry, the amount is zero.)

    pastedimage1581346577735v1.png

  • Suggested answer
    Hokuminaria Profile Picture
    2,950 on at
    RE: Write off process in Sales

    Hello Arch,

    I was able to go through the Write-Off Process in my GP for 2015, 2016 and 2018. During my testing, the end results are the same. The Credit Memo is created for 0.00 as you see. However, the Apply Amount is correct. This is consistent with all version of GP that i tested above.

    During the Write-Off process, we do push the amount of the Write Off to the General Ledger. This apply record allows your modules to be in balance. Please see my testing below.

    1. I started with a fresh company with no data to easily be able to verify my values on the report.

    2. Posted an Invoice in Receivables.

    pastedimage1581354172878v2.png

    3. Post the GL Entry for my Invoice.

    pastedimage1581354251197v3.png

    4. Were currently in Balance.

    5.Processed the Write Off Routine to Write-off the 1000.00 Invoice.

    6. We see the Write off on the RM which brings our balance to 0.00.

    pastedimage1581354417166v7.png

    7. After posting the GL batch from the Write Off.

    pastedimage1581354424999v8.png

    8.Reviewed the GL Report and these are still in balance.

    With my testing, the Write-Off routine is working correctly and would not cause your RM HATB and GL TB to not match.

    I would check to make sure your Write-off GL Batches are getting posted. If these are all getting posted, be sure you are including any discount account on your reporting that might be getting over looked.

    You can also use the Reconcile to GL Routine to help you locate differences between RM and GL. You can find more information on this tool using the link below.

    866570        Information about differences when you reconcile General Ledger to Payables Management or to Receivables Management in Microsoft Dynamics GP.

    http://support.microsoft.com/kb/866570/EN-US

    If you still believe the RM Write-off Routine is causing the issue, please provide further details into a Write-off that is having an issue or create a support case to allow us to further dig into the issue.

    Microsoft Support Engineer | Brandon Jarrett

  • yayayayaay Profile Picture
    145 on at
    RE: Write off process in Sales

    Brandon - thank you very much for looking into this!  Very detailed - I will give this a go as well.

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