Skip to main content

Notifications

Business Central forum
Answered

Business Central Write Offs

Posted on by 19

How do I Write off an amount in Business Central?  See 2 scenario's below.

1. Customer has a $100.00 invoice and only pays $50.00, how do I write off the addition $50.00 remaining?

2. Write off full amount of the invoice or full Customer balance?

Version: CA Business Central 20.5

  • ConsultantDawn Profile Picture
    ConsultantDawn 19 on at
    RE: Business Central Write Offs

    I would to confirm how this should be entered in the system, please see below and let me know which if any of the options to post are correct.

    1. Post the $50.00 payment and the $50.00 Credit Memo in the Cash Receipts Journal.

    2.Post the $50.00 in the Cash Receipts Journal, then Go to the Sales Journal and post the $50.00 in the Sales Journal.

    3. Post the $50.00 in the Cash Receipts Journal, then Create a Sales Credit memo for $50.00. Not sure if this type of Sales Credit memo will work as it reverses the Sales invoices lines and there for full invoice amount. I do not want to reverse the Invoice, the service was completed, I need to write off part of the invoice and in some cases the full invoice amount.  If I remove the invoice lines from the Sales Credit memo, and add a line for the Bad Debt account, there is no way to then apply it to the original invoice.

  • ConsultantDawn Profile Picture
    ConsultantDawn 19 on at
    RE: Business Central Write Offs

    I just want to confirm how this should be entered in the system, please see below and let me know which if any of the options to post are correct.

    1. Post the $50.00 payment and the $50.00 Credit Memo in the Cash Receipts Journal.

    pastedimage1664144358069v1.png

    2.Post the $50.00 in the Cash Receipts Journal, then Go to the Sales Journal and post the $50.00 in the Sales Journal.

    pastedimage1664144392998v2.png

    pastedimage1664144513394v3.png

    3. Post the $50.00 in the Cash Receipts Journal, then Create a Sales Credit memo for $50.00. Not sure if this type of Sales Credit memo will work as it reverses the Sales invoices lines and there for full invoice amount. I do not want to reverse the Invoice, the service was completed, I need to write off part of the invoice and in some cases the full invoice amount.  If I remove the invoice lines from the Sales Credit memo, and add a line for the Bad Debt account, there is no way to then apply it to the original invoice.

    pastedimage1664144392998v2.png

    pastedimage1664144567081v4.png

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,510 Super User 2024 Season 2 on at
    RE: Business Central Write Offs

    Hi, I think systematically, there are two ways

    1. Cancel the invoice of $100(Credit Memo) create a new one of $50, and then apply the payment.

    pastedimage1664088275375v1.png

    2. Create a credit memo of $50, then use this Credit Memo and the payment to appy the invoice of $100.

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Business Central Write Offs

    At least in my region, creating a credit memo for a customer ledger entry that should be written of is not complaint with the accounting laws / regulations. So please make sure it is a legal way of handling it before you chose that approach.

  • Verified answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Business Central Write Offs

    Hi,

    For this

    Apply 50$ to Sales Invoice

    for remaining sales invoice amount--> Post Sales Credit Memo

    In this way remaining amount of Sales Invoice will goes zero.

    Regards

    Amit Sharma

    www.erpconsultors.com

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Business Central Write Offs

    You post credit your customer ledger account and debit you income statement account for loss on customer ledgers.

    Pretty much in the same way as you post a payment you just balance it against your income statement instead of your bank account.

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

Dynamics 365 Community Update – Sep 16th

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…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans