Aditya Duggal
unread,Dec 17, 2012, 9:25:28 AM12/17/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to erpnext-dev...@googlegroups.com
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