You’re offline. This is a read only version of the page.
Announcements
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!
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.
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....
D Papa,
I found the below to very helpful:
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)
D Papa,
I found the below to very helpful:
DCTX
#1
André Arnaud de Cal...
294,241
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
