Item Wise Price List Report

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.


I am enclosing the code of the price list I am using.

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,

  1. 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.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. 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.