Custom script not working in print

Frappe Framework Custom Script
1

I have changed calculations of item amount and total in sales invoice , it works good but when trying to print it shows default total value not value calculated in my custom script
here it works

94718338_3100878053310092_2071240419353559040_n
94718338_3100878053310092_2071240419353559040_n1268×662 47.5 KB

but to print preview or PDF:

Capture
Capture1216×681 74.9 KB

How to solve that?
Thanks in advance

2

Hi,
I think you should make custom print format and make all your calculations in it by using Jinja

3

facing the same issue, am using custom print format though,

used a script inside print format to convert some numbers to arabic, conversion works fine in print preview , but when a pdf is generated or doc is actually printed, it goes back to what it was before conversion

1 Like
4

I have same issue too and ERPNext Support is no help. I wonder if this is a bug versus an issue with our custom calculations?

5

it will be same issue i think because we will render the same fields value

6

so what do you think to solve that?or what’s going wrong?

7

may be ,we need support team help

8

no i do not think so
because you will replace your custom script with calculations in print format and it will work
i tried it before in salary register to make totals and show totals of specific columns
try it :slight_smile:

9

for example doc.total always return default number in any print format

10

would you share some calculations of what you want to do to help you in doing it ?

1 Like
11

print preview is generated in client side, and actual pdf is rendered on server,
wkhtmltopdf renders with data available on the server, client scripts in print formats are not run

1 Like
12 
frappe.ui.form.on('Sales Invoice',{onload:function(frm){

var custom_total=0; 
$.each(frm.doc.items || [], function(i, d) {
    d.amount= d.rate * d.qty * ((d.نسبة_انجاز_الأعمال)/100)
    console.log(d.amount)
   custom_total+=d.amount;
    frm.refresh();

});
frm.set_value('total', custom_total)
console.log(frm.doc.total)
frm.doc.grand_total=custom_total;

frm.doc.rounded_total=custom_total;

frm.doc.outstanding_amount=custom_total;

frm.doc.in_words=custom_total;
  

frm.refresh_fields();

}});

Thanks in Advance

13

Thanks for clearance I was think there is an error with my code

14

that is for things in tag in actual print format,

your issue, is mostly you are not saving the data to doc but rather just assigning it to be visible on client side, if you save it to a field and call it in print format, it will be resolved (i think)

15

my issue is this

this is in print preview inside erpnext
image


this is when pdf/full page/ or when the actual “Print” button in preview is clicked
image

1 Like
16

so,How to that,how to save it? I need to save it to total field i.e with new calculation results

17

may be you need to add arabic language to your system

18

you can do you for loop with jinja like this

				{%- for row in doc.earnings-%}
				{%- if row.add_to_print == 0 -%}

							<tr style="border-bottom: 1px solid #d1d8dd">
								<td style="direction: rtl; width: 75%; text-align: right;text-align: Right; font-size: 8.0pt; font-family: Cairo; color: #404040;">
									{{ row.salary_component }}				
								</td>
								<td style="direction: rtl; width: 25%; text-align: right;text-align: Right; font-size: 8.0pt; font-family: Cairo; color: #404040;">
									{{row.get_formatted("amount", doc) }}			
								</td>

							</tr>

				{%- endif -%}
				{%- endfor -%}

and you can do what ever you want in your loop

20

Solved this issue by moving the conversion from js script in print format to a server side python function and calling it in print format. Works fine now.

1 Like
21

How do you think this can be done on ERPNext Cloud? I am having an issue just like this.