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
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
From: er...@googlegroups.com [mailto:er...@googlegroups.com] On Behalf Of Aditya Duggal Sent: Tuesday, February 05, 2013 9:20 PM To: er...@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
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:
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
Lookup Error - MySQL Database Error: Unknown column 'tabItem.quality' in 'field list'
Best Regards,
Mahr
From: er...@googlegroups.com [mailto:er...@googlegroups.com] On Behalf Of Aditya Duggal Sent: Saturday, February 09, 2013 8:14 AM To: er...@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:
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:
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
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’
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:
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
How to resolve the problem . if I will add the column quality the how I ll populate the data
From: er...@googlegroups.com [mailto:er...@googlegroups.com] On Behalf Of Aditya Duggal Sent: Wednesday, February 20, 2013 10:10 AM To: er...@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'
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:
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
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’
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:
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
Hi, is it possible to make the ledger balance appear in the sales invoice to the client?
On Wed, Feb 20, 2013 at 11:40 AM, Aditya Duggal <ad…@gmail.com> wrote:
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'
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:
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
-- 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 post to this group, send email to erpnext-dev...@googlegroups.com.