Add QR Code in Advanced PDF Template

codetype = qrcode Sample – <barcode codetype=”qrcode” height=”100px” showtext=”true” value=”Company Name:${subsidiary.name};VAT Number:${record.vatregnum};VAT Amount:${record.taxtotal};Grand Total:${record.total}”/> The data in the “Value” part will display when scanning the QR code. We can also give static values to the QR Code.

Concatenate 3 fields on the results of a Saved Search

To concatenate 3 fields on the results of a saved search, do the following: 1. Create a saved search, List > Search > Saved Searches > New. 2. You may select any search type, for this example select Customer. 3. Navigate to the Results tab and add the field “Formula (Text)” and enter the following as the value of… Continue reading Concatenate 3 fields on the results of a Saved Search

NetSuite – How to create a Sales Report by Month when column option is not available

In order to use the same column option for a New Report the option to use Matrix Report will show the similar information.For this example the report will show Transaction by Item that are posted to a particle account. The same concept can be used for customized reports. 1. Navigate to Reports >  New Report2. Select Transactions3. Metric = Amount4. Check Matrix for… Continue reading NetSuite – How to create a Sales Report by Month when column option is not available

CSV Import of Matrix Item

Prepare the csv file which needs to be imported into netsuite. While preparing the csv file make sure that mandatory fields like Item Code, Global Code, Primary Group, Match bill to Receipt are included in the csv file. We can also add more fields to the file as per the requirements. We need to prepare… Continue reading CSV Import of Matrix Item