While shipping an order, on some cases it is mandatory to add Commercial Invoice to the package. Especially when the shipment will go through customs process. Depending on the business, actual invoice record is not always created before the shipment. To cover the requirement, Advanced […]
With the release of NetSuite2.com datasource for SuiteAnalytics Connect, NetSuite continues to improve the feature. Until recently, connection to SuiteAnalytics Connect was only possible through username and password combination. It is not a good practice in terms of security and also additional layer of authentication […]
Usage of AWS for data exchange and even as an integrator tool is becoming more common. You can use S3 buckets for data, SQS for queue operations, API Gateway for static IP addresses, Lambda for extending capabilities of NetSuite and much more. However, there is […]
One of the weak points in NetSuite was reporting. The options available were not flexible and integration possibilities were limited. During recent releases, NetSuite added new capabilities like Workbooks, SuiteQL and introduced new datasource for SuiteAnalytics Connect (ODBC/JDBC). We will explain how to generate Trial […]
It has been a while since our last post. We had opportunity to work on various projects including integration with UIPath. UIPath is a Robotics Process Automation (RPA) product. However, there is no standard way to integrate UIPath with NetSuite REST endpoints. One benefit of […]
Yesterday, I saw a post on NetSuite Professionals Slack community about a service to validate EU VAT Numbers. It was mentioned that a service called VIES on European Commission website can be used for this purpose. Service can be used via UI or through SOAP […]
This was the one of the first projects I was involved. Looking back, I would do couple of things differently, especially the coding. It is a good example why we should benefit a library like moment.js instead of struggling with dates with native JavaScript functionalities. […]
During 2020, we took part in implementation of a new subsidiary. One of the requirement was to be able to import Customer Refund records. That means, native CSV Import solution from NetSuite wouldn’t be an option as this record type is not supported. Looking for […]
NetSuite gives option to void transactions using reversing journals. This preference is available under Accounting Preferences section. However, when it is enabled, some of the transactions cannot be voided any more. As of the time this article published, this is still and enhancement request in […]
As a part of company structure, we needed to generate Trial Balance report for our parent company and send periodically. However, NetSuite does not allow reports to be generated via SuiteScript. That pushed us to find a different approach to capture the content of a […]