How to Multiply divide or use Arithmetic field's values in Advanced PDF ?

Hi,

Advanced PDFs are very useful feature of Netsuite, using Advanced PDF you can write most logic but it is time consuming, especially if you stuck in any field related error. 

 

 

Netsuite provide good amount of error message if you are using Advanced PDF UI but it is not too useful if you try to use Render Module and generate PDF.

 

In Most cases, simple addition , multiplication , subtraction and division causes issue. 

Please do keep in mind that Netsuite allow to multiply or subs or add or divide only if field is decimal or integer fields. 

If both field are numeric:

To Multiply:

Use: ${item.quantity * item.rate} . No need to use ${item.quantity} *  ${item.rate}

To Divide:

 Use: ${item.quantity / item.rate} . No need to use ${item.quantity} /  ${item.rate} 

*** Do not forget to check if rate is not 0.

To Add:

Use: ${item.quantity + item.rate} . No need to use ${item.quantity} +  ${item.rate}.

To Subtract:

Use: ${item.quantity - item.rate} . No need to use ${item.quantity} -  ${item.rate}

 **Please Note: you can perform all arithmetic operators in similar way.

These fields are just for example, you can use standard or custom fields also.

Hope this will help you , let us know if you have any query.
Do not forget to share with your collegues.

Thanks

Netsuite Guru

 

 

 

Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page