Probably adding a button to check items could work. Currently we have beforesubmit script deployed however that is not very useful. The custom field triggers the price level change and we need this change to happen smoothly without slowing down the processing. Plus the user should be able to see the updated total value of…

Hi @Mikko De La Fuente-Oracle thanks for a prompt response. Actually I would like to populate a custom field as soon as the item is added to sublist using “Add Multiple”. Is there any workaround?

Hi @Jack Daryl Espiel-Oracle Actually I’ve created new advanced pdf template using the following option.

Hi @Jack Daryl Espiel-Oracle The url link contains certain data that we wish to have on the printouts. Thanks

Hello @Erick Dela Rosa-Oracle , Here's the updated script function validateLine(scriptContext) { var currentRecord = scriptContext.currentRecord; var sublistName = scriptContext.sublistId; var sublistFieldName = scriptContext.fieldId; var sublistName = 'item'; var sublistFieldName = 'price'; var price_Level =…

Hello @Erick Dela Rosa-Oracle , Hope you are well. Found a bit of issue with the validateLine script. It does set up the price level based on the custom body field however the price level selected does not automatically update the "rate". Any idea how this could be resolved? Thanks :)

Hello @Erick Dela Rosa-Oracle Thanks for getting back :) All resolved. Thanks for help as always! :)

Hello @Mikko De La Fuente-Oracle I think I have used the same concept in expense sublist script. With this approach I think we need to use changesublist options however I am not sure how the script functions if there are line items under both "expense" and "item" sublist? In this case we will need sum of items under both…

Hello @Mikko De La Fuente-Oracle, I think creating a button still wouldn't make the calculation dynamic.... however it could be useful in some ways as it might calculate the amount without the need to save the transaction, I believe?

Here's the full error message:

Hello @Mikko De La Fuente-Oracle Thanks for a prompt response. What I am trying is that the script uses vendorbill body fields including "total" and "exchangerate" to calculate the amount. 1- I have used beforeLoad and afterLoad functions however those do not populate the fields in dynamically. 2- I have used expense and…

Thanks @Erick Dela Rosa-Oracle . Fully resolved now!!!! Thanks for all the help ?

Hello @Erick Dela Rosa-Oracle , Sorry I have hit another issue now. Since Vendor and Customer records are not included in the lookup, I am getting the error below as soon as a vendor or customer name is selected. Is there a way of including these in the lookup search?

Thanks @Erick Dela Rosa-Oracle. Now everything works perfect!!! Really appreciate your help and patience. ?

Hello @Erick Dela Rosa-Oracle , Thanks for a prompt response. Still having the same error message. I have applied the updated code as below: Error message as below:

This is the error I get when I use 'entity'

Thanks @Erick Dela Rosa-Oracle . Almost got there :) Probably the final question, I have is, how do I set the value of "ID" based on the NAME selected under other deposit? :)

Hello @Erick Dela Rosa-Oracle , Hope you are well. I have reviewed the links and created the file. Please can you have a look. I am having issue with "Value" field of CurrentRecord.setCurrentSublistValue(options). I think its probably linked to how search.lookupfield(options) should be utilised. Any help would be highlight…

Thanks Both for a prompt response. @Jack Daryl Espiel-Oracle I was also considering the same solution @Jack Daryl Espiel-Oracle :)

Hello @Pauline Joy Cac-Oracle , Thank you :) The solution works!

Thanks for help @Jack Daryl Espiel-Oracle . A bit tricky but the solution worked :)

Thank Mikko :)

Hello @Pauline Joy Cac-Oracle :) This issue is resolved for now. thanks for looking into this ?

Hello @Pauline Joy Cac-Oracle Some more questions relating to the same. As soon as the form is submitted/saved the disabled field reverts to its original state i.e. Normal, and it stays in the same state even when the form is reopened and edited. Is there any workaround for this problem? I would like the form to stay in…

Hello @Pauline Joy Cac-Oracle Thanks for a prompt response. custom record entries permission shows all other fields except the 5 listed above. Once the form is saved all the 5 fields become visible.

Thanks @Pauline Joy Cac-Oracle. Excellent solution!! :)

Thanks @JohnCirocco and @Jack Daryl O Espiel-Oracle. Both solutions are very helpful!!

Hi @Erick Dela Rosa-Oracle Thanks for getting back to me. I have created the custom entity field. The field ID is "custentity10" and it populates data from Account list . Name field id is "entity" and it is linked to Entity list. I have also specified the "account" on other name records. I have used the example code…

That’s correct. I would like the account to be defaulted on selection of “ Name Record”

Thanks Pauline this is very helpful! :)