Stock Report at any Specific Date

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

To post to this group, send email to er...@googlegroups.com.

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

 

 

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

To post to this group, send email to er...@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: 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

-------------          ----------------     ----------               ----------               ---------                 -------------          ----------------

 

 

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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

 

 

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

To post to this group, send email to er...@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.

 

 

Dear Aditya Duggal

 

I got error

 

 

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:

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: 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

-------------          ----------------     ----------               ----------               ---------                 -------------          ----------------

 

 

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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

 

 

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-developer-fo…@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: er…@googlegroups.com [mailto:erpnext-developer-fo…@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

-------------          ----------------     ----------               ----------               ---------                 -------------          ----------------

 

 

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+un…@googlegroups.com.
To post to this group, send email to er…@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+un…@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+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/WxYSGpU_elYJ.

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

 

 

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'

 

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:

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: 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

-------------          ----------------     ----------               ----------               ---------                 -------------          ----------------

 

 

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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.
To post to this group, send email to er...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/WxYSGpU_elYJ.
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+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

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

 

 

Dear Mahr,

You can  catch me up on skype adityaduggal, just add me and I will try to walk through the report, hopefully we could develop the report.

On Wednesday, February 20, 2013 11:54:13 AM UTC+5:30, Stk Intl Trading IT Manager Mahr Haider wrote:

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-developer-fo…@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: er…@googlegroups.com [mailto:erpnext-developer-fo…@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:

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: er…@googlegroups.com [mailto:erpnext-developer-fo…@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

-------------          ----------------     ----------               ----------               ---------                 -------------          ----------------

 

 

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+un…@googlegroups.com.
To post to this group, send email to er…@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+un…@googlegroups.com.
To post to this group, send email to er…@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+un…@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.
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+un...@googlegroups.com.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/-iXGGsEWdrQJ.

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

 

 

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'

Best Regards,

Mahr

From: erpnext-dev...@googlegroups.com [mailto:erpnext-developer-fo...@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: er...@googlegroups.com [mailto:erpnext-developer-fo...@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

------------- ---------------- ---------- ---------- --------- ------------- ----------------

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+un...@googlegroups.com.
To post to this group, send email to er...@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+un...@googlegroups.com.
To post to this group, send email to erpnext-dev...@googlegroups.com.



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


To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/WxYSGpU_elYJ.

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





--
Industrial Print & Magic
specialized printing
photobooks | gifts | magic
# 011 43016456



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 er...@googlegroups.com.

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