Erp.bimsonline.in not accessing properly

Hi,


Issues on erp.bimsonline.in

the domain erp.bimsonline.in is inconsistent in availability


Could the erpnext support, please assist us on the same

Raj



On Tue, Apr 9, 2013 at 4:52 PM, Addy <ad…@gmail.com> wrote:

Hi Slava,

This report is possible, the only thing needed is someone with good knowledge of mysql query. Here is the hint, since I am not an expert and hence cannot give the correct code:


  • Join the 3 tables: tabBIN, tabITEM and tabITEM PRICE
  • Now you are looking for this kind of a report if I am not wrong.

Item Code

Item Name

Price List

WH1

WH2

WH3

A

Name of Item A

PL1

10

20

30

A

Name of Item A

PL2

10

20

30

B

Name of Item B

PL1

1

4

2

C

Name of Item C

PL1

5

6

7

Now you would notice that if you have multiple price lists for an item then the items would be shown in multiple lines. I would try and work out the code for this report, since this report would indeed be very helpful for sales people.


Let me give it a try and I would come back if I am successful.



On Tuesday, April 9, 2013 10:43:23 AM UTC+5:30, Slava wrote:

Is there any report (or possibility to create such a report) that will show actual quantity and price on one screen? with a possibility to search by code and item name both? It would be a great tool for sales persons.


Slava



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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







You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

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

 

 

Dear Mukund,

We are able to access the specified domain. Issue must be due to interrupted internet connection at your end.


Thanks and Regards,

Umair Sayyed
www.erpnext.com



On Tue, Apr 9, 2013 at 5:07 PM, Raj <ra…@gmail.com> wrote:

Hi,


the domain erp.bimsonline.in is inconsistent in availability


Could the erpnext support, please assist us on the same

Raj



On Tue, Apr 9, 2013 at 4:52 PM, Addy <ad…@gmail.com> wrote:

Hi Slava,

This report is possible, the only thing needed is someone with good knowledge of mysql query. Here is the hint, since I am not an expert and hence cannot give the correct code:


  • Join the 3 tables: tabBIN, tabITEM and tabITEM PRICE
  • Now you are looking for this kind of a report if I am not wrong.

Item Code

Item Name

Price List

WH1

WH2

WH3

A

Name of Item A

PL1

10

20

30

A

Name of Item A

PL2

10

20

30

B

Name of Item B

PL1

1

4

2

C

Name of Item C

PL1

5

6

7

Now you would notice that if you have multiple price lists for an item then the items would be shown in multiple lines. I would try and work out the code for this report, since this report would indeed be very helpful for sales people.


Let me give it a try and I would come back if I am successful.



On Tuesday, April 9, 2013 10:43:23 AM UTC+5:30, Slava wrote:

Is there any report (or possibility to create such a report) that will show actual quantity and price on one screen? with a possibility to search by code and item name both? It would be a great tool for sales persons.


Slava



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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








You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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










Hi


It is very intermittent - anyway will check on the same

On Tue, Apr 9, 2013 at 5:21 PM, Umair Sayyed <um…@iwebnotes.com> wrote:

Dear Mukund,

We are able to access the specified domain. Issue must be due to interrupted internet connection at your end.



Thanks and Regards,

Umair Sayyed
www.erpnext.com




On Tue, Apr 9, 2013 at 5:07 PM, Raj <ra…@gmail.com> wrote:

Hi,


the domain erp.bimsonline.in is inconsistent in availability


Could the erpnext support, please assist us on the same

Raj



On Tue, Apr 9, 2013 at 4:52 PM, Addy <ad…@gmail.com> wrote:

Hi Slava,

This report is possible, the only thing needed is someone with good knowledge of mysql query. Here is the hint, since I am not an expert and hence cannot give the correct code:


  • Join the 3 tables: tabBIN, tabITEM and tabITEM PRICE
  • Now you are looking for this kind of a report if I am not wrong.

Item Code

Item Name

Price List

WH1

WH2

WH3

A

Name of Item A

PL1

10

20

30

A

Name of Item A

PL2

10

20

30

B

Name of Item B

PL1

1

4

2

C

Name of Item C

PL1

5

6

7

Now you would notice that if you have multiple price lists for an item then the items would be shown in multiple lines. I would try and work out the code for this report, since this report would indeed be very helpful for sales people.


Let me give it a try and I would come back if I am successful.



On Tuesday, April 9, 2013 10:43:23 AM UTC+5:30, Slava wrote:

Is there any report (or possibility to create such a report) that will show actual quantity and price on one screen? with a possibility to search by code and item name both? It would be a great tool for sales persons.


Slava



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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








You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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











You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

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