Re: [erpnext-dev] How to display delivery note number and date on sales invoice

#1
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 <pa...@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+un…@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

–

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+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAJ33fAsSDnxubozxS-ZDQDMLem8hX-v4v59g4yqgZMfX9_haSw%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.
#2
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 <pa...@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+un…@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

–

  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-forum+un…@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.

    For more options, visit https://groups.google.com/d/optout.
#3
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.

On Sep 22, 2014, at 4:43 PM, Dhaval Patel <pa...@gmail.com> wrote:

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 <pa...@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+un…@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

–

  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-forum+un…@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.

    For more options, visit https://groups.google.com/d/optout.

–

  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-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/0D8537AC-A313-4290-89FF-2D61FF16F8B5%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
#4

I have a similar requirement and got the delivery note number to show but the date does not show
I tried the custom script, that also does not work. I tried to remove No Copy in Doctype using Administrator User and the developer app as its completely locked down that way does not work too.

I know its an old topic, But its a similar problem, Didnt make sense to create a new topic

Thank you in advance

1 Like
#5

Does this have a solution yet? I’m trying the same thing, same script, with no success. How to get referenced properties as a custom field?

(eg. getting date of receipts on an invoice child table…)

Thanks!

#6

Having the same problem fetching delivery date from delivery note to sales invoice. It works somehow for delivery note number but not the date.