Dear All.
I need a query for stock position of all warehouses in a report with multi columns at any specific date. In ERPNext we have a report but for each warehouse we have to filter.
Item Code Item Name Whs 1 Whs 2 Whs 3 Whs 4 Total Stock
------------- ---------------- ---------- ---------- --------- ------------- ----------------
Best Regards,
Mahr
Dear
Can you send me the link.
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4JMRt5qnLM0J.
For more options, visit https://groups.google.com/groups/opt_out.
Dear
Can you send me the link.
From: erpnext-dev...@googlegroups.com [mailto:erpnext-developer-fo...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Tuesday, February 05, 2013 9:20 PM
To: erpnext-dev...@googlegroups.com
Subject: [wnframework] Re: Stock Report at any Specific Date
HI Mahr,
I have already made one query report exactly for this purpose the only difference is that this report only gives the current status since I am most of the times concerned with the current status.
You can check the forums and my code is also posted on github for the report. You can probably ask someone to add the date field but I am not an expert on that.
Do let me know if that report helps you or not.
On Tuesday, February 5, 2013 5:41:22 PM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:Dear All.
I need a query for stock position of all warehouses in a report with multi columns at any specific date. In ERPNext we have a report but for each warehouse we have to filter.
Item Code Item Name Whs 1 Whs 2 Whs 3 Whs 4 Total Stock
------------- ---------------- ---------- ---------- --------- ------------- ----------------
Best Regards,
Mahr
--
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.
Dear Aditya Duggal
I got error
Lookup Error - MySQL Database Error: Unknown column 'tabItem.quality' in 'field list'
Best Regards,
Mahr
From: erpnext-dev...@googlegroups.com [mailto:erpnext-dev...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Saturday, February 09, 2013 8:14 AM
To: erpnext-dev...@googlegroups.com
Subject: Re: [wnframework] Re: Stock Report at any Specific Date
Dear Mahr,
u
PLease note the link for the query report is below:
https://gist.github.com/adityaduggal/c7b6539f088c454f189a
Now if you can notice in the code, that I have listed each warehouse to show up in the a column as per the code. If you face any trouble understanding then do let me know.
But please note that this report would give the stock status at current time and not for past, this I think I cannot help you with as I am not an expert.
On Saturday, February 9, 2013 12:33:34 AM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:
Dear
Can you send me the link.
From: erpnext-dev...@googlegroups.com [mailto:erpnext-dev...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Tuesday, February 05, 2013 9:20 PM
To: erpnext-dev...@googlegroups.com
Subject: [wnframework] Re: Stock Report at any Specific Date
HI Mahr,
I have already made one query report exactly for this purpose the only difference is that this report only gives the current status since I am most of the times concerned with the current status.
You can check the forums and my code is also posted on github for the report. You can probably ask someone to add the date field but I am not an expert on that.
Do let me know if that report helps you or not.
On Tuesday, February 5, 2013 5:41:22 PM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:
Dear All.
I need a query for stock position of all warehouses in a report with multi columns at any specific date. In ERPNext we have a report but for each warehouse we have to filter.
Item Code Item Name Whs 1 Whs 2 Whs 3 Whs 4 Total Stock
------------- ---------------- ---------- ---------- --------- ------------- ----------------
Best Regards,
Mahr
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4JMRt5qnLM0J.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/wxtzp7_MI8cJ.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4JMRt5qnLM0J.
For more options, visit https://groups.google.com/groups/opt_out.
--
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.
How to resolve the problem . if I will add the column quality the how I ll populate the data
From: erpnext-dev...@googlegroups.com [mailto:erpnext-dev...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Wednesday, February 20, 2013 10:10 AM
To: erpnext-dev...@googlegroups.com
Subject: Re: [wnframework] Re: Stock Report at any Specific Date
Dear Mahr,
Please note that some of the fields are specific to my account since they are added by the custom field settings and hence you are getting this error.
Kindly note tabItem.quality means the following:
tab means TABLE
Item means Table Name for Item Table
. means now you want the system to look into table
quality = name of the field in the Item Table.
Now you are getting this error since your Item Table does not have any field named quality which of course is a custom field in my account and would not be available in your account.
I hope this helps, do let me know if you face any other issue.
On Tuesday, February 19, 2013 7:57:49 PM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:
Dear Aditya Duggal
I got error
Lookup Error - MySQL Database Error: Unknown column 'tabItem.quality' in 'field list'
Best Regards,
Mahr
From: erpnext-dev...@googlegroups.com [mailto:erpnext-dev...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Saturday, February 09, 2013 8:14 AM
To: erpnext-dev...@googlegroups.com
Subject: Re: [wnframework] Re: Stock Report at any Specific Date
Dear Mahr,
u
PLease note the link for the query report is below:
https://gist.github.com/adityaduggal/c7b6539f088c454f189a
Now if you can notice in the code, that I have listed each warehouse to show up in the a column as per the code. If you face any trouble understanding then do let me know.
But please note that this report would give the stock status at current time and not for past, this I think I cannot help you with as I am not an expert.
On Saturday, February 9, 2013 12:33:34 AM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:
Dear
Can you send me the link.
From: erpnext-dev...@googlegroups.com [mailto:erpnext-dev...@googlegroups.com] On Behalf Of Aditya Duggal
Sent: Tuesday, February 05, 2013 9:20 PM
To: erpnext-dev...@googlegroups.com
Subject: [wnframework] Re: Stock Report at any Specific Date
HI Mahr,
I have already made one query report exactly for this purpose the only difference is that this report only gives the current status since I am most of the times concerned with the current status.
You can check the forums and my code is also posted on github for the report. You can probably ask someone to add the date field but I am not an expert on that.
Do let me know if that report helps you or not.
On Tuesday, February 5, 2013 5:41:22 PM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:
Dear All.
I need a query for stock position of all warehouses in a report with multi columns at any specific date. In ERPNext we have a report but for each warehouse we have to filter.
Item Code Item Name Whs 1 Whs 2 Whs 3 Whs 4 Total Stock
------------- ---------------- ---------- ---------- --------- ------------- ----------------
Best Regards,
Mahr
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4JMRt5qnLM0J.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/wxtzp7_MI8cJ.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/WxYSGpU_elYJ.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+unsub...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/4JMRt5qnLM0J.
For more options, visit https://groups.google.com/groups/opt_out.
--
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.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/wxtzp7_MI8cJ.
For more options, visit https://groups.google.com/groups/opt_out.
--
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.
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/msg/erpnext-developer-forum/-/WxYSGpU_elYJ.