Is there anyway to findout when a particular PO was submitted?

ERPNext Buying
1

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
2

Hi Mayur,


You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.



On Thu, Aug 1, 2013 at 7:58 PM, MP <ma…@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel

–

Note:



If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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







--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
3

Hi Mayur,



You can check the last modified date of the form so that u can get a rough idea of the submitted date.

We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel

–

Note:



If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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







--

Regards,
Akhilesh Darjee

–

Note:



If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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







--
Regards,
Akhilesh Darjee
www.erpnext.com

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
4

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM tabFeed f, tabPurchase Order p
WHERE f.subject LIKE ‘%Submitted%’
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:

Hi Mayur,


You can check the last modified date of the form so that u can get a rough idea of the submitted date.

We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
5
Mayur - Feed is a good idea but feeds get cleared out every once in a while - you may want to look it up too (or increase the limit!)


T: @rushabh_mehta

On 02-Aug-2013, at 3:54 PM, MP <ma...@gmail.com> wrote:

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM `tabFeed` f, `tabPurchase Order` p
WHERE f.subject LIKE '%Submitted%'
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
6

Thanks Rushabh,

How often does it gets cleaned up? Is there a setting for it? If so, where can I find it? Thanks in advance.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 11:57:37 AM UTC+1, rushabh wrote:

Mayur - Feed is a good idea but feeds get cleared out every once in a while - you may want to look it up too (or increase the limit!)



T: @rushabh_mehta

On 02-Aug-2013, at 3:54 PM, MP <ma...@gmail.com> wrote:

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM `tabFeed` f, `tabPurchase Order` p
WHERE f.subject LIKE '%Submitted%'
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
7

Hi Rushabh,

Based on the code, it seems that for Purchase order, it will only delete and existing entry when that objects get submitted. So the entry for Save will get deleted and a new one for submit will be added into tabFeed. Apart from that i don’t see any where which could cause this entry to be deleted from table tabFeed. So i think i am safe based on my findings. But ofcourse, it will be good if you can confirm the same. Thanks.

Kind regards,
mayur Patel

On Friday, August 2, 2013 11:57:37 AM UTC+1, rushabh wrote:

Mayur - Feed is a good idea but feeds get cleared out every once in a while - you may want to look it up too (or increase the limit!)



T: @rushabh_mehta

On 02-Aug-2013, at 3:54 PM, MP <ma...@gmail.com> wrote:

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM `tabFeed` f, `tabPurchase Order` p
WHERE f.subject LIKE '%Submitted%'
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
8
Yeah seems okay to me too.

T: @rushabh_mehta

On 02-Aug-2013, at 5:54 PM, MP <ma...@gmail.com> wrote:

Hi Rushabh,

Based on the code, it seems that for Purchase order, it will only delete and existing entry when that objects get submitted. So the entry for Save will get deleted and a new one for submit will be added into tabFeed. Apart from that i don't see any where which could cause this entry to be deleted from table tabFeed. So i think i am safe based on my findings. But ofcourse, it will be good if you can confirm the same. Thanks.

Kind regards,
mayur Patel

On Friday, August 2, 2013 11:57:37 AM UTC+1, rushabh wrote:
Mayur - Feed is a good idea but feeds get cleared out every once in a while - you may want to look it up too (or increase the limit!)


T: @rushabh_mehta

On 02-Aug-2013, at 3:54 PM, MP <ma...@gmail.com> wrote:

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM `tabFeed` f, `tabPurchase Order` p
WHERE f.subject LIKE '%Submitted%'
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     
9

Thanks Rushabh.

On Friday, August 2, 2013 1:54:07 PM UTC+1, rushabh wrote:

Yeah seems okay to me too.


On 02-Aug-2013, at 5:54 PM, MP <ma...@gmail.com> wrote:

Hi Rushabh,

Based on the code, it seems that for Purchase order, it will only delete and existing entry when that objects get submitted. So the entry for Save will get deleted and a new one for submit will be added into tabFeed. Apart from that i don't see any where which could cause this entry to be deleted from table tabFeed. So i think i am safe based on my findings. But ofcourse, it will be good if you can confirm the same. Thanks.

Kind regards,
mayur Patel

On Friday, August 2, 2013 11:57:37 AM UTC+1, rushabh wrote:
Mayur - Feed is a good idea but feeds get cleared out every once in a while - you may want to look it up too (or increase the limit!)


T: @rushabh_mehta

On 02-Aug-2013, at 3:54 PM, MP <ma...@gmail.com> wrote:

Thanks Akhilesh for your response.

We did try to use last modified date but as you said it gives rough idea and not the exact date. This last modified date gets updated when user enters purchase Receipt or Purchase invoice against that PO. So It is not reliable to find out when a PO was submitted based on this field. For example, a PO could have been submitted couple of week ago. So when you received goods and enter purchase receipts against this PO, the last modified data will be as of it that day and not when the PO was submitted.

We have found a table called tabFeed and we are trying to use that to determine when a PO was submitted. I need either Rushabh or Anand to verify if it is a correct approach for our problem. See below query.

SELECT p.name, f.modified_by, f.modified, f.owner, f.doc_name, f.subject
FROM `tabFeed` f, `tabPurchase Order` p
WHERE f.subject LIKE '%Submitted%'
AND f.doc_name = p.name
AND p.docstatus =1

Thanks.

Kind regards,
Mayur Patel

On Friday, August 2, 2013 6:26:52 AM UTC+1, Akhilesh Darjee wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to include submitted date in form.

On Fri, Aug 2, 2013 at 10:55 AM, Akhilesh Darjee <ak...@gmail.com> wrote:
Hi Mayur,

You can check the last modified date of the form so that u can get a rough idea of the submitted date.
We have plans to iinclude submitted date in form.


On Thu, Aug 1, 2013 at 7:58 PM, MP <ma...@gmail.com> wrote:

Hi There,

How do I find out when a particular doctype (Purchase Order) was submitted? Do system keep track of this date?

Kind regards,
Mayur Patel


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--

Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

 

 




--
Regards,
Akhilesh Darjee

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     


–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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

     

     

–

Note:

 

If you are posting an issue,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.

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