Hi, is there someone out there who has a solution for me to complete the Customer Credit note? When a customer purchases items on account and returns them, you have to make a credit note to place the stock back in the warehouse and take the money out to the customer account. You can only Refund or make Credit available. The problem is that the customer didn’t pay anything because it was on account. I cannot refund or Make funds available, then I own the customer’s money.
We cannot complete the invoice and credit note, the status shows NOT PAID.
Is there someone with a solution to this, or a way to complete the transaction?
wouldn’t make funds available put it back on the account?
Hi, Thank you for getting back, if I understand you correctly, putting funds to be available on the customer account. The problem with that is that the funds available for the customer are getting more, every time there is a credit note. Someone is going to make n mistake, and allocate the funds to the next invoices, We don’t really own the customer’s money. We need to change the status without refunding or allocating funds to the account customer.
I still don’t understand why it is an issue?
- You have an unpaid invoice for a product
- Customer sends back that product
- you create a credit note on that unpaid invoice
- the amount should be equal, so they should cancel out when looking at the customers account.
Alternatively, can you mark the invoice abandonned?
or perhaps even not create an invoice in the first place, just an order which you can delete.
JonB
Thank you, I have tried all the steps you mentioned. The amount is equal, but the status shows UNPAID. With a UNPAID status, reporting becomes a problem. When trying to run a list from the Billing list and to filter the UNPAID customer accounts, the Invoice and credit note are part of that search. Making it difficult to have an accurate list. We have over 1000 customers with accounts, and we need to have accurate information to work with.
Abandoned is also not an option. By doing so, the stock is not placed back into the warehouse. Also if you abandoned the invoice, the invoice amount still shows up in your revenue sales for the day, You have to make the cost 0. More steps.
We use 6 x terminals for selling products in 6 different shops (Warehouses). So you cannot make orders for every sale, Account customers also walk in to get services, and the products and services are then placed on their account with the Takepos. We delay the payments, that will place the invoice on account for that customer. So order is not possible to create.
I think the solution will be to have a 3rd option, and that is to change the status of the invoice and credit note to close. There should be, ENTER REFUND, MARK CREDIT AVAILABLE, and CLOSE CR NOTE (to close and change the Status from NOT PAID to CLOSE or COMPLETE.
okay, but what if not using “close” but “returned” which would return the product, because what if the product is shipped, but the customer never got it? aka lost in shipment?
In both cases the customer should not pay for the product, but in one case the stock should be increased and in the other the stock should stay the same.
If the product is lost and never gets to the customer, I will think that you have abandoned the invoice, because you cannot put the product back in stock. If the customer didn’t pay for it yet, then we are back to the problem. If the customer already pays for the product, then you will need to refund the customer. To refund you will need to do a credit note, and then the product will go back to the warehouse. But there are no products to put back in the warehouse. Now your stock levels are not corrected. In this case, you will need to adjust the stock level after the credit note.
It looks to me that the software cannot handle all the different scenarios. Stock return to suppliers is also a problem. I don’t know how to resolve this. To try a workaround with too many steps to follow. My customers (on Dolibarr) don’t want these long processes to do something on the system and will start looking for a new solution. Thanks for your input so far.
Hi, for a workaround I have changed the account credit note processes, to change the credit note status and invoice from NOT PAID to complete the process.
The shops will create a credit note and mark it as Mark AS Credit Available. That will change the status of the credit note to “Mark as credit available” and the invoice to PIAD. From the support team, we need to check the on-account credit notes and change the Credit available amount to 0 in the database. We need to get a fix for this problem.
then please fix it and submit a merge request at GitHub - Dolibarr/dolibarr: Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers.
Hi,
I am not sure, if there needs anything to be fixed (or maybe I missed something from your description) - in general, the process is as follows:
- invoice created for customer
- goods returned → credit note created for invoice
- convert credit note into a discount
- apply discount to the open invoice from 1. (within the invoice card)
Now both, the invoice and the credit note, should be in status paid.
1 Like
Hi, thank you for your feedback. The problem is when a customer purchases the goods on account. If we make the funds available, we own the customer’s money. The customer didn’t pay any money. IF only do the credit note, the status of the invoice and the credit note status UNPAID. We need to complete the status. We cannot abort the invoice, then the stock return is not returned to the warehouse. We have to do a credit note to place the stock back into the warehouse. We need a 3rd option, and that is to change the credit mote and invoice to complete, if there is no money exchange.
Ηι @MobileIT
Try this process
-
In the invoice card press the “create credit note” button
-
then check this box
-
complete and validate credit note and press the “mark as credit available” button
-
Then return to original invoice card and you will see the option Discounts or credits available open, choose the credit notes amount and press apply.
The invoice will be marked as paid by the amount of credit note with status paid
Now if you return back to the credit note, it will have the status of “Credit note refund or marked as credit available”
This way they cancel each other out and your account will be fine.
1 Like
Thanks, will try that
@MobileIT please let us know if it works
Hi, This is the result we looking for. It makes sense to pay back the invoice with the credit available. Thank you, this will change the NOT PAID status of the Invoice and Credit Note, and still Debit and Credit the account customer.
Thank you
1 Like
Hi @MobileIT
Please mark the answer that solved your issue as solution so others can find it in the future
