I would like to add new field to project module ( in costing and billing section). The purpose of this field is to the get the balance unbill amount from Sales order ( Sales Order amount minus sales invoice amount).
May I know if someone had done the custom script for this.
- Create a new field via Customize Form. Let’s call it Pending Billable (pending_billable).
- Go to client script. Write the following for Project:
let pending = 0
pending = frm.doc.total_sales_amount - frm.doc.total_billed_amount
- Enable the script.
- Go back to the project and reload. The new field with the value should be populated:
The code works well. But I just realize that the number does not appear in List View and Report View.
Any chance that I had set the field wrongly?
Working for me:
Can you mark the field as “In List View” via Customize Form and check?
I had add on IN LIST View. Its may take a while maybe. Or else trying to reboot server once again. Thanks Kenneth.
The code work quite find for total pending billing. But I came across one little issue with the flow.
Field Pending Billing in the project doctype does update according to changes of sales invoice / billing related to that particular project.
Sceario as below
It does not automatically update in list view and report coloum. I need to press save button in order for the value to appear inlist / report view.
Upon submitting the sales invoice, the pending billing figure does not update automatically to pending amount billing. I need to save manually to update the value in project report/list view.
Any idea/ work around i can implement to settle this issue.