Skip to content
N&S ERP Solutions
  • Home
  • About Us
  • Contact Us
  • Support Us

Author: Selcuk

Print Commercial Invoice from Item Fulfillment

January 8, 2023January 8, 2023SelcukAdvanced PDF/HTML Template, Suitelet

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 […]

SuiteAnalytics Connect – Token-based Authentication via Python

January 1, 2022SelcukSuiteAnalytics Connect

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 […]

NetSuite – Amazon Web Services Integration

December 8, 2021December 14, 2021SelcukLibrary

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 […]

SuiteQL / ODBC Query To Retrieve Trial Balance Report

October 1, 2021SelcukODBC, SuiteQL

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 […]

UIPath – NetSuite Restlet / SuiteTalk REST Web Services Connector

September 12, 2021SelcukREST Web Services, Restlet

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 […]

EU VAT Validation via SuiteScript

March 19, 2021March 19, 2021SelcukSuitelet, SuiteScript

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 […]

Keeping Track of Period Cutoff Timelines

March 1, 2021March 19, 2021SelcukCustom Record, Scheduled Script, Workflow

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. […]

A Different Approach to NetSuite CSV Import

February 21, 2021March 19, 2021SelcukCSV Import, Custom Record, Map/Reduce Script, Scheduled Script, Suitelet

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 […]

Voiding Customer Payment Using Reversing Journal Entry

February 16, 2021February 16, 2021SelcukClient Script, Customer Payments, Suitelet

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 […]

Generate (Periodic) Trial Balance Report Data With Saved Search

February 9, 2021February 9, 2021SelcukSaved Search

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 […]

Posts navigation

Older posts

Recent Posts

  • Print Commercial Invoice from Item Fulfillment
  • SuiteAnalytics Connect – Token-based Authentication via Python
  • NetSuite – Amazon Web Services Integration
  • SuiteQL / ODBC Query To Retrieve Trial Balance Report
  • UIPath – NetSuite Restlet / SuiteTalk REST Web Services Connector

Categories

  • Customization
    • Advanced PDF/HTML Template
    • Custom Record
    • Workflow
  • Data Management
    • CSV Import
  • Order To Cash
    • Customer Payments
  • Reporting
    • ODBC
    • Saved Search
    • SuiteAnalytics Connect
    • SuiteQL
  • SuiteScript
    • Client Script
    • Library
    • Map/Reduce Script
    • Restlet
    • Scheduled Script
    • Suitelet
    • User Event Script
  • SuiteTalk
    • REST Web Services

Tags

Advanced PDF AWS Backend Suitelet beforeLoad Customer Payment Excel Formula Inline HTML JDBC Journal Entry JSZip Map/Reduce Script N/cache N/currency N/email N/format N/https N/record N/runtime N/search N/task N/ui/dialog N/ui/message N/xml ODBC papaparse Python Record View Report rest restlet Reversing Journal Entry rpa Saved Search Scheduled Script SheetJS SQL Suitelet SuiteQL SuiteScript TBA Trial Balance uipath User Event Script Void Transaction
© 2023 N&S ERP Solutions