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