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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Customer Payment Journal Lines or Transactions - create debits (for deductions / chargebacks)

(0) ShareShare
ReportReport
Posted on by 140

Hi, does anyone know if there is a way to create debits while settling customer payments in D365?

We have several large accounts that routinely pay multiple invoices in full, and take multiple unrelated deductions / chargebacks, on the same payment.  We need a way to settle the full invoice balances, and create separate debits for the deductions / chargebacks, so the net total equals the payment amount.

Very simple example I've been using: we receive a customer check for $100.00, has an open invoice for $150.00; we need a way to settle $150.00 against that invoice, but post the remaining $50.00 as a separate debit transaction for that customer.

I assume the vouchers in customer payment journal lines are to enter the check totals from each customer in the credit column, so although there is a debit column there, I haven't tried using it, as the debits we want to post would be part of the same check as the credits.  So, I've been looking to do this in the Settle Transactions form.  At some point (I don't remember what I did) I got it to apply $150.00 to an invoice while showing a payment of only $100.00, but I later found that it forced the remaining $50.00 into a cash discount on the invoice.

Any suggestions would be welcome.  Thanks!

I have the same question (0)
  • Suggested answer
    DCTX Profile Picture
    235 on at

    D Papa,

    I found the below to very helpful:

    https://www.loganconsulting.com/blog/record-a-customer-payment-with-wire-fees-in-dynamics-365-for-finance-and-operations/

    DCTX

  • David Penna Profile Picture
    140 on at
    [quote user="DCTX"]

    D Papa,

    I found the below to very helpful:

    https://www.loganconsulting.com/blog/record-a-customer-payment-with-wire-fees-in-dynamics-365-for-finance-and-operations/

    DCTX

    [/quote]

    DCTX Thanks so much!  I was playing around and hit on a similar method to this, but had some concerns.  

    I was initially trying to find a way to enter debits within the Enter Customer Payments form, since we would normally use the Payment Journal Lines form as one line per customer check.  By adding Journal Lines with separate amounts from the same check, we wouldn't be able to use that form to compare check amounts with the report we get from our bank.

    Also, in the Customer Payment Journal itself, the resulting totals seem incorrect.  In the below example, I had entered one Journal Line with a customer's invoice selected for $190.61 and credit amount of $190.61, then added a Journal Line for same customer, no invoice selected, and debit amount of $90.61.  The result in the customer's Transactions was correct (invoice balance $0.00, new Payment transaction for debit $90.61).  However in Customer Payment Journal, it has the sum $281.22 in all total columns... shouldn't it be credit $190.61, debit $90.61, transactions $100.00?  (I should note I didn't do anything with the deposit slip, account type, or ledger account fields as mentioned in the above article, not sure if that would correct the totals)

    pastedimage1617126741188v1.png

  • DCTX Profile Picture
    235 on at

    Another method is in the journal line section of the payment journal and under the tab "Payment fee" to enter this bank charge here.  How it shows up one the bank reconciliation depends on whether or not you use the Deposit feature on the journal line.  Without it, you get both the invoice settlement in full and an offsetting bank fee (2 transactions). If you post the deposit slip, you get a netted amount in the bank recon's....

  • David Penna Profile Picture
    140 on at
    [quote user="DCTX"]

    Another method is in the journal line section of the payment journal and under the tab "Payment fee" to enter this bank charge here.  How it shows up one the bank reconciliation depends on whether or not you use the Deposit feature on the journal line.  Without it, you get both the invoice settlement in full and an offsetting bank fee (2 transactions). If you post the deposit slip, you get a netted amount in the bank recon's....

    [/quote]

    Thanks again DCTX.  I played around with Payment Fee, the good thing with that is it doesn't add a journal line and posts the amount as a debit transaction on the customer's account, unfortunately it is called a "Fee" and has no place to type details etc.  Then I started looking into the Deductions link, but those do create additional journal lines.  Lastly I was looking into creating $0.01 Free Text Invoices just to have another transaction to try to settle the debit amounts.  Anyway. I was since informed that we CAN add journal lines, so we will use the easiest solution of adding a journal line for each chargeback, entering the amounts in the Debit column and using the Description field to notate the deduction details.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 565 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans