Advanced PDFs are a very useful feature of Netsuite, using Advanced PDF you can write most logic but it is time-consuming, especially if you are stuck in any field-related error.
Netsuite provides a 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 cause issues.
Please do keep in mind that Netsuite allows to multiply or subs, add or divide only if the field is decimal or integer fields.
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 the 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 a similar way.