Hi,
This is the report for Item wise price list (Again the column width for the description is not possible to adjust):
select
tabItem
.item_code
as “Item Code:Link/Item:120”,
tabItem
.description
as “Description:200”,
tabItem Price
.price_list_name
as “Price List”,
tabItem Price
.ref_currency
as “Currency”,
tabItem Price
.ref_rate
as “Price”
from
tabItem
, tabItem Price
where
tabItem Price
.parent
= tabItem
.item_code
order by tabItem
.item_code asc
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to er...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/KCYGbvZ6EEoJ.
For more options, visit https://groups.google.com/groups/opt_out.
Hi,
I am trying to make a report for Price List since many fields are needed to be fetched from the item table. The problem I am facing is that when I am trying to join the 2 lists one from item and another from item price table then I am unable to show the multiple prices for an item from multiple price lists.
Suppose Item A has prices in 3 price lists then I would like the report to show
Item Code
|
Price List
|
Price
|
Currency
|
A
|
PL1
|
1
|
INR
|
A
|
PL2
|
2
|
INR
|
A
|
PL3
|
3
|
INR
|
The problem with my code is that Item A is showing only once for only one price list.
It would be great if someone could help me out with this problem.
On Monday, December 17, 2012 7:55:28 PM UTC+5:30, Aditya Duggal wrote:
Hi,
This is the report for Item wise price list (Again the column width for the description is not possible to adjust):
select
`tabItem`.`item_code` as "Item Code:Link/Item:120",
`tabItem`.`description` as "Description:200",
`tabItem Price`.`price_list_name` as "Price List",
`tabItem Price`.`ref_currency` as "Currency",
`tabItem Price`.`ref_rate` as "Price"
from
`tabItem`, `tabItem Price`
where
`tabItem Price`.`parent` = `tabItem`.`item_code`
order by `tabItem`.item_code asc
–
Note:
If you are posting an issue,
- We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
- Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
- For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/faf74cee-6320-4f80-8662-7b6cfbb09a8e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.