Credit Note not reflecting in Sales Order view

I have created a Sales Order

Copy to Sales Invoice at the receipt of payment. (Order number tagged)
Copy to Delivery upon delivery of goods (Invoice No and Order number tagged)

Then the customer cancelled the order, and we refunded the money.

Copy to Credit Note (Invoice No tagged)
Copy to Delivery Note with minus amounts - to show return (Invoice No and Order number tagged)

We Created a Credit Note for this (and tagged the relevant Invoice No)

However, when viewing the Sales Order tab, it shows itโ€™s invoiced, but still shows that itโ€™s pending to delivery.

Why is that? What am I doing wrong?

For now just edit the order and cancel it. Its still going to show qty to deliver but i think the recent changes to the Order and inventory management are still not finalized. Once finalized it will be ok then.
If it still bothers you then
Edit the sales order and make qty zero for all items.
OR
Delete the sales order, invoice and credit note. You received money and refunded it. thats it.

have you create Delivery notes?

Credit Notes should occur after the Sales Process (Delivery Notes and Sales Invoice) is complete. Credit Notes are related Sales Invoices.

But Iโ€™m also a little confused about my inventory report, I think the credit note should not add value to Qty on hand, Qty available, Qty to be available, but only to Qty owned

The issue is the delivery wasnt made in the first place. Customer placed order, paid the amount and then cancelled it without taking the delivery.

Because credit notes are not tied to sales order and the new tracking system is mostly based on orders. So creating credit note is just like creating a sales invoice without order(Which affects qty owned and qty on hand the moment it is created).

1 Like

got it, thanks :slight_smile:

When receiving goods after its got returned, is it a correct practice to make a minus Delivery Note?

As in the -qty?

You donโ€™t need to make any delivery note after receiving returned goods. Credit note is sufficient.
Create a test business and try different combinations of invoice credit notes, sales orders etc. it will clear all your questions.

I just tried simulating your problem, I think you donโ€™t need to create Delivery Notes for Credit Notes transactions.

1 Like

Thanks. It worked without a delivery note.

But hereโ€™s the issue:

From a documentation process, shouldnโ€™t there be another delivery note saying its been returned?

When we dispatch from our stores, its based off a delivery note. (Which doesnt have invoice amounts)

So, when the goods return, shouldnt we issue a a similar return note?

Actually in your first post i missed that you have created delivery note. I was under the impression that order was cancelled before despatch of goods.
So if you made a delivery note after invoice then there shouldnโ€™t be any issue in the first place. The sales order should not show qty to deliver because you have made the delivery already.
And negative delivery is not required. Credit note is enough.

The actual document should be Goods receipt note but thats not possible here. So all you have a credit note for now.

Thatโ€™s my issue.

My stores only see the delivery note which doesnt have any invoice values.

I dont want them seeing the invoice or credit note values.

When they dispatch or receive goods, all they should see is the delivery note or goods receipt.

So in this case, when the goods are being returned, what should be handed over to them, with the returned goods? A credit note?

No, read the previous post by @shahabb again, especially the last paragraph:

Delivery notes with a Negative value should be accepted.

I see that the problem that occurs is that when we cancel a Sales Order, the Qty to deliver value does not return to the Qty available.

Delivery notes with negative amount is going to work with obsolete qty to deliver ,qty on hand but not with the new one. Because the obsolete system was based on invoices/creditnotes, while new one is based on orders. so untill credit notes are tied to orders its the only way.

Thats what i have stated earlier. There are many other issues with it but hope they are resolved soon.

One of the solution is to your problem is to issue a delivery note with a negative value but dont tag any invoice or order in that specific delivery note. that will solve your issue. And also you can edit the title of that delivery note (Maybe to goods receipt or whatever u like)

Ok, so this minus delivery note isnโ€™t working. (It works for the obsolete Qty to deliver).

Because the Sales Orders are connected to the Credit Note, and not the Delivery Note.

So, I need to skip the minus Delivery Note, and suffice only with the credit note.
Itโ€™s strange, because a Credit Note should be an accountants document, and the minus/ return delivery note should be the store keepers document.

But iโ€™ll have to suffice with giving the Store Keeper the Credit Note document as proof of return if iโ€™m to make this new update work.

I hope iโ€™ve understood the system. Please let me know if I havenโ€™t.
Appreciate all the replies.

Gave u a solution thats gonna work in your scenario. You get to keep delivery note without affecting qty on hand or anything.

That step does work.
But it doesnโ€™t make any sense, and leaves room for error.

Could you explain the logic in why, at the time of dispatch a Delivery Note is required, but not at the time of return?

What part of it doesnt make sense? you just didnt tag your order no. Still you can tag your invoice. thats will eliminate the room for error.

To me its doesnt make sense to receive something from someone and give them a delivery note. Thats why i suggested to change its title. Further its up to u if you want to use it.

What doesnโ€™t make sense is that why should I un-tag an order number, when the Order>Invoice>Delivery Note>Credit Note
Are all tagged to each other.

Thus, during a return minus Delivery Note, I should technically tag the correct Order/Invoices in order for there to be a correct paper trail.

Order>Invoice>Delivery note. Thats it. Your order is complete. Now Goods are returned. So Invoice copy to Credit note> Credit note copy to Delivery note(qty negative sign). That credit note has nothing to do with your initial order no. So why you want to put order no on negative delivery note?
I hope i have gave you solutions and made it pretty clear what the current workflow of the application is.