Sales Price Database Table

1

Dear All

 

 

I want to make a query for current  sales price of all items, Pls guide me what is the name of the table , I checked in Item Master customized, its shows ref_rate_details but its not working in query report

 

 

Thanks

Mahr

–

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 [email protected].

To post to this group, send email to [email protected].

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

 

 

2
Item Price


On 04-Feb-2013, at 2:08 PM, STK IT Manager <[email protected]> wrote:

Dear All
 
 
I want to make a query for current  sales price of all items, Pls guide me what is the name of the table , I checked in Item Master customized, its shows ref_rate_details but its not working in query report
 
 
Thanks
Mahr

-- 
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 [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
 
 

–

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 [email protected].

To post to this group, send email to [email protected].

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

 

 

3

No table with item price name

 

From: [email protected] [mailto:[email protected]] On Behalf Of Rushabh Mehta
Sent: Monday, February 04, 2013 1:10 PM
To: [email protected]
Subject: Re: [wnframework] Sales Price Database Table

 

Item Price

 

 

On 04-Feb-2013, at 2:08 PM, STK IT Manager <[email protected]> wrote:



Dear All

 

 

I want to make a query for current  sales price of all items, Pls guide me what is the name of the table , I checked in Item Master customized, its shows ref_rate_details but its not working in query report

 

 

Thanks

Mahr

 

-- 
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 [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
 
 

 

--
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 [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
 
 

–

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 [email protected].

To post to this group, send email to [email protected].

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

 

 

4
"tabItem Price"

All tables in ERPNext start with a "tab" Prefix.

I am sure you can browse using MySQL Administrator or phpMyAdmin and figure out.


On Mon, Feb 4, 2013 at 2:41 PM, STK IT Manager <[email protected]> wrote:

No table with item price name

From: [email protected] [mailto:[email protected]] On Behalf Of Rushabh Mehta
Sent: Monday, February 04, 2013 1:10 PM
To: [email protected]
Subject: Re: [wnframework] Sales Price Database Table

Item Price

On 04-Feb-2013, at 2:08 PM, STK IT Manager <[email protected]> wrote:



Dear All

I want to make a query for current sales price of all items, Pls guide me what is the name of the table , I checked in Item Master customized, its shows ref_rate_details but its not working in query report

Thanks

Mahr

--
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 [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

--
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 [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

–

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 post to this group, send email to er…@googlegroups.com.

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







--



Twitter: @rushabh_mehta

–

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 [email protected].

To post to this group, send email to [email protected].

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