In Advanced PDF customization, we have certain amount fields in item table where currency symbol is not needed. But while fetching from the field the currency symbol will be along with it. To remove these currency symbol we have to use the following code: ${record.amount?string[‘#,###,##0.00’]} <td align=”right” colspan=”3″ style=”height: 8px;border-left:.5px; border-left-color: #A1A0A0;”>${discount?string[‘#,###,##0.00’]}</td>
Month: December 2021
Copy Messages, Tasks, and Calls from one Entity to another
Use record.copy functionality to create new Messages , tasks and calls from existing sub-records attached to the source Entity. Attach the newly created messages tasks or calls to the new or the destined entity record. Delete the source messages, tasks and call sub records.
Printing Currency Symbol in Advanced PDF Template
In Advanced PDF customization, we have certain amount fields where we have to print the currency symbol along with it. But while fetching from the field the currency symbol will be missing. So we should give the currency symbols used by them as dynamically.We have to use the following code <#assign currencySymbol = {“USD”:”$”, “EUR”:”€”,… Continue reading Printing Currency Symbol in Advanced PDF Template
0 Available Quantity Even If There Is Stock In The Location
The system shows the item as back-ordered when we create the sales orders even if there is some quantity available in the location. The Warning message will also be shown as ‘You have only 0 available at this location’ and you can’t fulfill the sales orders. Solution Setup> Company> Location Check the box make inventory… Continue reading 0 Available Quantity Even If There Is Stock In The Location
Remove Location field in external Payment forms
Remove Location field in external Payment forms
Restrict Shipping Items by City or Zip
Restrict Shipping Items by City or Zip
Proposal For Assembly Item Creation
Jira code XEPL-19 Proposal summary Xseed education Pte Ltd currently has the books as the inventory items. They buy books as finished goods and sell them as kit/ assembly items. Now the process will be changed. The paper will be purchased from the vendor and this will be outsourced to another vendor for printing. The… Continue reading Proposal For Assembly Item Creation
Expense Report Attachments Migration Tool
This can be used to migrate existing expense attachments to the File Cabinet dedicated employee expense folders. The migration tool uses internal logic to search all expense reports for files that should be moved to the predefined user folders. You can automatically schedule the migration, or you can use the migration tool to schedule the… Continue reading Expense Report Attachments Migration Tool
Search by Title in WordPress
The below-given script structure can be used for the implementation of Search by Title in WordPress. Reloading the section to avoid page reload.
SQl Server Integration Services (SSIS)
SSIS simply helps to Migrate data’s from Netsuite to outside Databases which are mainly loaded in SQL server.Mostly Export is done through Visual studio Community towards SQL Server which is located in Microsoft Azure platform. Part_1: Netsuite Connection Setup through SuiteAnalytics Connect(ODBC Driver) Part_2: Creating a project in Integration Services Project Template(Visual Studio community) Part_3:… Continue reading SQl Server Integration Services (SSIS)