Sample Data file for the Vendor Bill Import with Item Line and Expense Line. Screenshots for the mapping fields Result Screenshots
Month: August 2021
Steps to Import a PO
Extraction of the report based on the Subsidiary and the date taken is 5/31/2021. The Report here used is JJ Open Purchase Orders. Each Report are generated and extracted based on the 12 subsidiaries. Import of Purchase Order Extraction of the report based on the Subsidiary and the date taken is 5/31/2021. The Report here… Continue reading Steps to Import a PO
Electronic Funds Transfer (EFT)
Electronic Funds Transfer (EFT) is a process that enables customers to authorize the transfer of funds from their bank accounts to your bank accounts to pay their invoices. Automated Clearing House (ACH) processing is used to process financial transactions through the ACH Network for the Electronic Funds Transfer (EFT) feature. Electronic Funds Transfer transactions in… Continue reading Electronic Funds Transfer (EFT)
End of Support for Data Center-Specific Email Domains
Data center-specific domains are targeted for deprecation in 2020.2 production accounts. Before the 2020.2 release, you must update your integrations, RESTlets, external Suitelets, and external forms in your production account that are still using data center-specific domains. Using account-specific domains removes dependencies on the data center where your account is hosted. Solution Traffic Health Reports… Continue reading End of Support for Data Center-Specific Email Domains
Import Historical Transaction and Trial Balance (Data Migration)
2 methods for Historical trial balance import. Year to date(Historical trial balance) Net activity balance load(Historical Trial Balance) Detailed Historical balance/transaction import: Above are the methods mentioned by Netsuite. We will use the second method but with transaction details in it(not just the total of each account). To go with this method we will use… Continue reading Import Historical Transaction and Trial Balance (Data Migration)
Proposal for adding sales order quantity and amount custom fields
This proposal details includes the new fields added in the sales order item line which copy the values from the existing fields only at the time record creation.
FreeMarker Formatting Method
NetSuite formatting is lost when you customize NetSuite standard fields. If you print hard-coded values which came from a custom data source or were calculated from standard fields, the format will not be consistent with the format of standard record fields. When editing the template source code, the nsformat_() formatting method makes it possible to… Continue reading FreeMarker Formatting Method
Multiple Search Feasibility
Our Requirement is to remove all finance-related fields in the transactions for certain roles. So they should not view these fields in transaction Records, Lists, Dashboard, Searches, Reminders, and Reports, etc. These fields can be made hidden to the roles (except admin) by customizing the forms and setting that form as the preferred one for… Continue reading Multiple Search Feasibility
Online Case form Template using Bootstrap and validation using DOM
Solution <!DOCTYPE html><Head><meta charset=”utf-8″><Title>Revo Online Case Form</Title><meta name=”viewport” content=”width=device-width, initial-scale=1.0″> <link href=”https://netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/css/bootstrap-combined.min.css” rel=”stylesheet”><link rel=”stylesheet” href=”https://fonts.googleapis.com/css?family=Work Sans” type=”text/css”><style>input[type=”text”]{width:67%;font-size:14px;display:block;}.control-label{font-size:13px;display:block;} select { display block;font-size:14px; width:70%;}.btn{font-size:14px;padding:8px;margin-bottom:100px;}textarea{width:67%;height:32px;display:block;font-size:22px;}option { font-size: 14px; font-weight: normal; line-height: 0px;}body{letter-spacing:.07em;font-family:Work Sans;}</style><script type=”text/javascript”>if(performance.getEntriesByType(“navigation”)[0].type == “back_forward”){ location.reload();}function getData(){var title=document.getElementById(‘title’).value;var fname=document.getElementById(‘firstname’).value;var lname=document.getElementById(‘lastname’).value;var email=document.getElementById(’email’).value;var adrs=document.getElementById(‘address1’).value;var state=document.getElementById(‘state’).value;var city=document.getElementById(‘city’).value;var item=document.getElementById(‘custevent_jj_prdt_num_brl_57’).value;var ctgry=document.getElementById(‘category’).value;var msg=document.getElementById(‘incomingmessage’).value;var year=document.getElementById(‘custevent_jj_year_brl_43’).value;var zip=document.getElementById(‘zipcode’).value;var d = new Date(); var n = d.getFullYear();var… Continue reading Online Case form Template using Bootstrap and validation using DOM
Timesheet Import Proposal
Timesheet Import