Linked payment terms field on Quotes and Customers?

ERPNext
,
1

Hi

The builtin payment terms on a customer don’t work us so i am hiding these and creating my own payment terms custom field on the Customer doctype.

I then need to link this field and show the permitted values for these payment terms on a Quote. ie if a customer is set to Net 30 days as the selected default term, i want this to appear by default on a quotation for this customer, but so this can be changed to a different payment term, if necessary, for this particular quote.

I’ve tried using a custom script to bridge between the payment terms field in Quotation and the same field in Customer, but when I try to use a ‘link’ type field on the Quotation doctype I can only link to another doctype and not a custom field which is what I have.

What is the easiest way to achieve what I’m trying to do? I have tried working this through and believe it should be quite easy, but can’t quite get it to work in practice …

2

Are you thinking something like Complex Payment Terms - #8 by Jammyinc

3

cur_frm.add_fetch(“customer”, “CUSTOM_FIELD_CUSTOMER”, “CUSTOM_FIELD_QUOTATION”);

Add above in custom script for DocType: Quotation from Setup >>> Customize >>> Custom Script >>> New

But that link field in Quotation is to be ‘Read Only’.

4

Thanks for this. But does this work for a Select field which is what I need to use in Customer?

5

Yes, it does work on Select Field but it will display something like below; you may try in fact:

[CUSTOM_FIELD_VALUE: CUSTOMER]

6

so it would be
cur_frm.add_fetch(“customer”, “CUSTOM_FIELD_VALUE:CUSTOMER”);

7

If your custom field name is ‘select’ in both the forms then code would be:

cur_frm.add_fetch("customer", "select", "select");

Usage:
cur_frm.add_fetch("Link_Field", "Source_Field", "Target_Field");

Example: Select Field Added in Item as below:

It is displayed in another linked form field as below: (after using above mentioned code in Custom Script)

8

I can state read only on the field name and on the actual customise form screen. Where should the ‘readonly’ be stated?

9

There’s a Checkbox in field details where we customize any DocType and Add a Custom Field:

Screen Shot 2017-07-17 at 21.08.18.png1078×38 2.34 KB

10

I still can’t quite get this to work. I can get the field to appear in the quote, but its not linked to the customer field, it works separately to the field ion the customer for.

I’m wondering if I have a problem with the Custok script not working to link the feilds as it should

11

Ok. Go to: Setup >>> Customization >>> Custom Form

  1. Select Customer >>> Add a Custom Field as you need.
  2. Select Quotation >>> Add a Custom Field with Type: Link and in Options write Customer and also mark this field as Read Only.
  3. Goto Custom Script and write that code under Quotation.
    Hope this would help.
12

thanks for your help.

I think the bit I have wrong is step 2, where I have used Customer.payment_terms in the Options/Field where payment_terms in the fieldname in Customer

13

I get this error ‘Duplicate name Custom Field Quotation-payment_terms’ when trying to add the custom field in 2. Does this mean I should only add the custom script AFTER stage 2?

14

It means, payment_terms already exist in Quotation; you may rename it to paymentterm or something else.

15

I can now get the fields in place without errors, but when I go to my Quote, the payment term field is missing instead of just ‘read only’. If I un tick read only, teh field is show, but only allows me to select a customer.

16

I have seen the payment TErms field show up as a read only field but clickable to the customer page. But this only shows up sometimes. I’m not sure why sometimes it appears and sometimes it doesnt. But I am getting closer :wink:

1 Like
17

Good Luck!