How to get the value of the field of a singleType Doctype on Salary Component Formula?

ERPNext
,
1

I’ve created a new singleType Doctype on a custom app along with few fields. I want to get the value of these field on Salary Component Formula for comparison. Is there any way to do that?

N.B: I’m using ERPNext V13

2

you can use below frappe api to fetch values from single doctypes:
frappe.db.get_single_value(doctype, fieldname)

1 Like
3

Does this method work inside formula? I’m bit confused.

4

yes you can use it in formula by storing in one variable

5

would you mind to write a simple example?

6

price = frappe.db.get_single_value(‘Stock Settings’, ‘update_existing_price_list_rate’)
if price == 1:
#your logic

7

Noted with thanks @Rehan_Ansari. I will try and update you back.

8

Not working bro. it says "Syntax error in formula or condition: invalid syntax (, line 1)

". @Rehan_Ansari

9

can you share the screenshot?

10

Here’s error message:

image
image1188×266 15.4 KB

and my formula as follows:

hrdf_contribution = frappe.db.get_single_value("Contribution Settings", "enable_hrdf_contribution")


if hrdf_contribution=="1%":
    hrdf_contribution = 1
else:
    hrdf_contribution = 0.5
    
hrdf_contribution

not sure what’s wrong here as I’m new into this! please help @Rehan_Ansari !

11

what is the value stored in this field ‘enable_hrdf_contribution’.
because you are comparing in if hrdf_contribution==“1%”:.
if value stored in is 1% then is correct
or try with

if hrdf_contribution==“1”:

if you use enable_hrdf_contribution docfield as check type then try with this

hrdf_contribution = frappe.db.get_single_value("Contribution Settings", "enable_hrdf_contribution")

if hrdf_contribution==1:
    hrdf_contribution = 1
else:
    hrdf_contribution = 0.5
12

Yes it is 1% and the doctype is single type doctype and the field type is “Select”.

image
image2640×1362 322 KB

@Rehan_Ansari

13

@Rehan_Ansari Do you have any other recommendations? Any other possible way to get done? Thanks in advance!