How to display delivery note number and date on sales invoice

276 views
Skip to first unread message

Dhaval Patel

unread,
Sep 20, 2014, 2:18:24 AM9/20/14
to erpnext-dev...@googlegroups.com
Hi,

When we create a sales invoice from existing delivery note all the data gets imported. But I would like to import delivery note number and date in that invoice automatically. How I achieve this?

Thanks,
Dhaval A Patel

Umair Sayyed

unread,
Sep 20, 2014, 9:02:41 AM9/20/14
to erpnext-dev...@googlegroups.com
Dhaval,

As one Sales Invoice could have items from multiple Delivery Notes, Delivery Note id is updated in the Sales Invoice Item table.

In Customize Form, uncheck ""Print Hide" for Delivery Note field of Sales Invoice Item table. With this, Delivery Note No. will show in the Standard Sales Invoice print format, for each item.


--
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/6bb15647-0bf8-4343-9504-9b06403a172c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Thanks and Regards,
Umair Sayyed
www.erpnext.com

Dhaval Patel

unread,
Sep 22, 2014, 7:13:36 AM9/22/14
to erpnext-dev...@googlegroups.com
Umair,

Thank you again for helping me. Now Delivery number shows up in invoice, how should I get Delivery Note Date to show up in invoice.


On Saturday, September 20, 2014 6:32:41 PM UTC+5:30, Umair Sayyed wrote:
Dhaval,

As one Sales Invoice could have items from multiple Delivery Notes, Delivery Note id is updated in the Sales Invoice Item table.

In Customize Form, uncheck ""Print Hide" for Delivery Note field of Sales Invoice Item table. With this, Delivery Note No. will show in the Standard Sales Invoice print format, for each item.

On Sat, Sep 20, 2014 at 11:48 AM, Dhaval Patel <pateldh...@gmail.com> wrote:
Hi,

When we create a sales invoice from existing delivery note all the data gets imported. But I would like to import delivery note number and date in that invoice automatically. How I achieve this?

Thanks,
Dhaval A Patel

--
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
 
End of Note
---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.

Nabin Hait

unread,
Sep 24, 2014, 1:13:05 AM9/24/14
to erpnext-dev...@googlegroups.com
Create a custom field “Delivery Note Date” in Sales Invoice item table. and then write a small custom script to fetch the date on change of delivery note.

`cur_frm.add_fetch("delivery_note", "posting_date", "delivery_note_date")`

I think it should work.

--
1. Please be kind and don't send large attachments
2. For issues, features requests use https://github.com/frappe/erpnext/issues

---
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/a21706f1-dcda-4a64-9766-e9dc87349b70%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages