How to fetch Other Charges Based on Customers?

Is it possible to fetch other charges in Sales Orders, Invoices ,
Quotation based on a value in Customer.

Basically I have created a custom field in Customer which I want to
link to the Other Charges table and I would like this table to be
fetched when a customer is selected.

You can create separate Other Charges Master for different customers and fetch it accordingly in documents.

Eg.:
1. Customer - ABC Ltd.

2. Create Other Charges master named "ABC Ltd Charges".


3. Fetch respective master in documents.



On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal <ad…@rigpl.com> wrote:

Is it possible to fetch other charges in Sales Orders, Invoices ,
Quotation based on a value in Customer.

Basically I have created a custom field in Customer which I want to
link to the Other Charges table and I would like this table to be
fetched when a customer is selected.




--
--
Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com

Hi Saumil,

I think I should explain my situation in a better way. I have created
5 Other charges as A,B,C,D,E.
Now I have a custom field in Customer as ‘state_tax_type’. Now this
custom field is linked to the Other Charges as a LINK.
Now I have written a script in the CLIENT SIDE SCRIPT AS below:

  1. cur_frm.add_fetch(‘customer’,‘state_tax_type’,‘charge’);

Now this code would populate the Other Charge field OK but my main
concern is to fill the RV Tax Detail Table. Is it possible to fill the
RV tax Detail table on selecting a customer in a Sales Order.

On Nov 25, 10:29 am, Saumil Dalal sa...@iwebnotes.com wrote:

You can create separate Other Charges Master for different customers and
fetch it accordingly in documents.

Eg.:

  1. Customer - ABC Ltd.

  2. Create Other Charges master named “ABC Ltd Charges”.

  3. Fetch respective master in documents.

On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal ad...@rigpl.com wrote:

Is it possible to fetch other charges in Sales Orders, Invoices ,
Quotation based on a value in Customer.

Basically I have created a custom field in Customer which I want to
link to the Other Charges table and I would like this table to be
fetched when a customer is selected.

Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com
http://www.erpnext.com/

The problem I am facing is that the SO other charge field is getting
populated but if I click the “Get Other Charges” button then the
filled up data in the box gets vanished and the RV_tax_table is not
filled as well.

What I am looking for is that the tax is fetched with some code in the
client script, if possible can you let me know how to populate the
table.

On Nov 25, 11:21 am, Aditya Duggal ad...@rigpl.com wrote:

Hi Saumil,

I think I should explain my situation in a better way. I have created
5 Other charges as A,B,C,D,E.
Now I have a custom field in Customer as ‘state_tax_type’. Now this
custom field is linked to the Other Charges as a LINK.
Now I have written a script in the CLIENT SIDE SCRIPT AS below:

  1. cur_frm.add_fetch(‘customer’,‘state_tax_type’,‘charge’);

Now this code would populate the Other Charge field OK but my main
concern is to fill the RV Tax Detail Table. Is it possible to fill the
RV tax Detail table on selecting a customer in a Sales Order.

On Nov 25, 10:29 am, Saumil Dalal sa...@iwebnotes.com wrote:

You can create separate Other Charges Master for different customers and
fetch it accordingly in documents.

Eg.:

  1. Customer - ABC Ltd.
  1. Create Other Charges master named “ABC Ltd Charges”.
  1. Fetch respective master in documents.

On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal ad...@rigpl.com wrote:

Is it possible to fetch other charges in Sales Orders, Invoices ,
Quotation based on a value in Customer.

Basically I have created a custom field in Customer which I want to
link to the Other Charges table and I would like this table to be
fetched when a customer is selected.

Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com
http://www.erpnext.com/

Still waiting for a reply on this post.

On Nov 25, 3:36 pm, Aditya Duggal ad...@rigpl.com wrote:

The problem I am facing is that the SO other charge field is getting
populated but if I click the “Get Other Charges” button then the
filled up data in the box gets vanished and the RV_tax_table is not
filled as well.

What I am looking for is that the tax is fetched with some code in the
client script, if possible can you let me know how to populate the
table.

On Nov 25, 11:21 am, Aditya Duggal ad...@rigpl.com wrote:

Hi Saumil,

I think I should explain my situation in a better way. I have created
5 Other charges as A,B,C,D,E.
Now I have a custom field in Customer as ‘state_tax_type’. Now this
custom field is linked to the Other Charges as a LINK.
Now I have written a script in the CLIENT SIDE SCRIPT AS below:

  1. cur_frm.add_fetch(‘customer’,‘state_tax_type’,‘charge’);

Now this code would populate the Other Charge field OK but my main
concern is to fill the RV Tax Detail Table. Is it possible to fill the
RV tax Detail table on selecting a customer in a Sales Order.

On Nov 25, 10:29 am, Saumil Dalal sa...@iwebnotes.com wrote:

You can create separate Other Charges Master for different customers and
fetch it accordingly in documents.

Eg.:

  1. Customer - ABC Ltd.
  1. Create Other Charges master named “ABC Ltd Charges”.
  1. Fetch respective master in documents.

On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal ad...@rigpl.com wrote:

Is it possible to fetch other charges in Sales Orders, Invoices ,
Quotation based on a value in Customer.

Basically I have created a custom field in Customer which I want to
link to the Other Charges table and I would like this table to be
fetched when a customer is selected.

Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com
http://www.erpnext.com/

Dear Aditya,

There is some issue in Framework regarding this scenario.

Will be done by tomorrow evening.

We will also explain you process to fetch Customer wise Other Charge



Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com




On Mon, Nov 29, 2010 at 4:06 PM, Aditya Duggal <ad…@rigpl.com> wrote:

Still waiting for a reply on this post.


On Nov 25, 3:36 pm, Aditya Duggal <ad...@rigpl.com> wrote:
> The problem I am facing is that the SO other charge field is getting
> populated but if I click the "Get Other Charges" button then the
> filled up data in the box gets vanished and the RV_tax_table is not
> filled as well.
>
> What I am looking for is that the tax is fetched with some code in the
> client script, if possible can you let me know how to populate the
> table.
>
> On Nov 25, 11:21 am, Aditya Duggal <ad...@rigpl.com> wrote:
>
>
>
>
>
>
>
> > Hi Saumil,
>
> > I think I should explain my situation in a better way. I have created
> > 5 Other charges as A,B,C,D,E.
> > Now I have a custom field in Customer as 'state_tax_type'. Now this
> > custom field is linked to the Other Charges as a LINK.
> > Now I have written a script in the CLIENT SIDE SCRIPT AS below:
>
> > 1. cur_frm.add_fetch('customer','state_tax_type','charge');
>
> > Now this code would populate the Other Charge field OK but my main
> > concern is to fill the RV Tax Detail Table. Is it possible to fill the
> > RV tax Detail table on selecting a customer in a Sales Order.
>
> > On Nov 25, 10:29 am, Saumil Dalal <sa...@iwebnotes.com> wrote:
>
> > > You can create separate Other Charges Master for different customers and
> > > fetch it accordingly in documents.
>
> > > Eg.:
> > > 1. Customer - ABC Ltd.
>
> > > 2. Create Other Charges master named "ABC Ltd Charges".
>
> > > 3. Fetch respective master in documents.
>
> > > On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal <ad...@rigpl.com> wrote:
> > > > Is it possible to fetch other charges in Sales Orders, Invoices ,
> > > > Quotation based on a value in Customer.
>
> > > > Basically I have created a custom field in Customer which I want to
> > > > link to the Other Charges table and I would like this table to be
> > > > fetched when a customer is selected.
>
> > > --
> > > --
> > > Thanks and Regards,
> > > Saumil Dalal
> > > Phone: 022 65265364
> > > Web Notes Technologies Pvt. Ltd.
>
> > >www.erpnext.com
> > > <http://www.erpnext.com/>



--

Dear Saumil,

 

I am still not able to fetch other charges, though the field is populated.

 

Best Regards,

 

Aditya Duggal

Rohit Industries Group (P) Ltd.

Mobile: +91-9899407669

Ph: +91-11-25429804, 41021800, 25920492, 41427321

Fax: +91-11-25920493, 25431800

Email: ad...@rigpl.com

ad...@gmail.com

Visit Us: RIGPL

 

 

Spend a thought for nature,

Please don't print this on paper.

 

From: Saumil Dalal [mailto:sa...@iwebnotes.com]
Sent: 29 November 2010 16:16
To: ad...@rigpl.com
Subject: Re: How to fetch Other Charges Based on Customers?

 

Dear Aditya,

There is some issue in Framework regarding this scenario.

Will be done by tomorrow evening.

We will also explain you process to fetch Customer wise Other Charge

--
Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com


On Mon, Nov 29, 2010 at 4:06 PM, Aditya Duggal <ad...@rigpl.com> wrote:

Still waiting for a reply on this post.


On Nov 25, 3:36 pm, Aditya Duggal <ad...@rigpl.com> wrote:
> The problem I am facing is that the SO other charge field is getting
> populated but if I click the "Get Other Charges" button then the
> filled up data in the box gets vanished and the RV_tax_table is not
> filled as well.
>
> What I am looking for is that the tax is fetched with some code in the
> client script, if possible can you let me know how to populate the
> table.
>
> On Nov 25, 11:21 am, Aditya Duggal <ad...@rigpl.com> wrote:
>
>
>
>
>
>
>
> > Hi Saumil,
>
> > I think I should explain my situation in a better way. I have created
> > 5 Other charges as A,B,C,D,E.
> > Now I have a custom field in Customer as 'state_tax_type'. Now this
> > custom field is linked to the Other Charges as a LINK.
> > Now I have written a script in the CLIENT SIDE SCRIPT AS below:
>
> > 1. cur_frm.add_fetch('customer','state_tax_type','charge');
>
> > Now this code would populate the Other Charge field OK but my main
> > concern is to fill the RV Tax Detail Table. Is it possible to fill the
> > RV tax Detail table on selecting a customer in a Sales Order.
>
> > On Nov 25, 10:29 am, Saumil Dalal <sa...@iwebnotes.com> wrote:
>
> > > You can create separate Other Charges Master for different customers and
> > > fetch it accordingly in documents.
>
> > > Eg.:
> > > 1. Customer - ABC Ltd.
>
> > > 2. Create Other Charges master named "ABC Ltd Charges".
>
> > > 3. Fetch respective master in documents.
>
> > > On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal <ad...@rigpl.com> wrote:
> > > > Is it possible to fetch other charges in Sales Orders, Invoices ,
> > > > Quotation based on a value in Customer.
>
> > > > Basically I have created a custom field in Customer which I want to
> > > > link to the Other Charges table and I would like this table to be
> > > > fetched when a customer is selected.
>
> > > --
> > > --
> > > Thanks and Regards,
> > > Saumil Dalal
> > > Phone: 022 65265364
> > > Web Notes Technologies Pvt. Ltd.
>
> > >www.erpnext.com
> > > <http://www.erpnext.com/>




--

REMINDER NO.1

 

Dear Saumil,

 

I am still not able to fetch other charges, though the field is populated.

 

Best Regards,

 

Aditya Duggal

Rohit Industries Group (P) Ltd.

Mobile: +91-9899407669

Ph: +91-11-25429804, 41021800, 25920492, 41427321

Fax: +91-11-25920493, 25431800

Email: ad...@rigpl.com

ad...@gmail.com

Visit Us: RIGPL

 

 

Spend a thought for nature,

Please don't print this on paper.

 

From: Saumil Dalal [mailto:sa...@iwebnotes.com]
Sent: 29 November 2010 16:16
To: ad...@rigpl.com
Subject: Re: How to fetch Other Charges Based on Customers?

 

Dear Aditya,

There is some issue in Framework regarding this scenario.

Will be done by tomorrow evening.

We will also explain you process to fetch Customer wise Other Charge

--
Thanks and Regards,
Saumil Dalal
Phone: 022 65265364
Web Notes Technologies Pvt. Ltd.

www.erpnext.com
Description: http://www.erpnext.com/cgi-bin/getfile.cgi?name=bannerlogo.gif

On Mon, Nov 29, 2010 at 4:06 PM, Aditya Duggal <ad...@rigpl.com> wrote:

Still waiting for a reply on this post.


On Nov 25, 3:36 pm, Aditya Duggal <ad...@rigpl.com> wrote:
> The problem I am facing is that the SO other charge field is getting
> populated but if I click the "Get Other Charges" button then the
> filled up data in the box gets vanished and the RV_tax_table is not
> filled as well.
>
> What I am looking for is that the tax is fetched with some code in the
> client script, if possible can you let me know how to populate the
> table.
>
> On Nov 25, 11:21 am, Aditya Duggal <ad...@rigpl.com> wrote:
>
>
>
>
>
>
>
> > Hi Saumil,
>
> > I think I should explain my situation in a better way. I have created
> > 5 Other charges as A,B,C,D,E.
> > Now I have a custom field in Customer as 'state_tax_type'. Now this
> > custom field is linked to the Other Charges as a LINK.
> > Now I have written a script in the CLIENT SIDE SCRIPT AS below:
>
> > 1. cur_frm.add_fetch('customer','state_tax_type','charge');
>
> > Now this code would populate the Other Charge field OK but my main
> > concern is to fill the RV Tax Detail Table. Is it possible to fill the
> > RV tax Detail table on selecting a customer in a Sales Order.
>
> > On Nov 25, 10:29 am, Saumil Dalal <sa...@iwebnotes.com> wrote:
>
> > > You can create separate Other Charges Master for different customers and
> > > fetch it accordingly in documents.
>
> > > Eg.:
> > > 1. Customer - ABC Ltd.
>
> > > 2. Create Other Charges master named "ABC Ltd Charges".
>
> > > 3. Fetch respective master in documents.
>
> > > On Thu, Nov 25, 2010 at 8:00 AM, Aditya Duggal <ad...@rigpl.com> wrote:
> > > > Is it possible to fetch other charges in Sales Orders, Invoices ,
> > > > Quotation based on a value in Customer.
>
> > > > Basically I have created a custom field in Customer which I want to
> > > > link to the Other Charges table and I would like this table to be
> > > > fetched when a customer is selected.
>
> > > --
> > > --
> > > Thanks and Regards,
> > > Saumil Dalal
> > > Phone: 022 65265364
> > > Web Notes Technologies Pvt. Ltd.
>
> > >www.erpnext.com
> > > <http://www.erpnext.com/>




--