michoelchaikin / python_suiteql.py

Created June 22, 2021 00:16

Run NetSuite SuiteQL queries using REST API in python

	import requests
	import json
	import pandas as pd
	import os
	from oauthlib import oauth1
	from requests_oauthlib import OAuth1Session

	def parse_suiteql_response(response):
	response_json = json.loads(response.text)

michoelchaikin / findAnalyticsTable.js

Last active August 4, 2025 19:23

NetSuite Script to help identifying which Analytics tables a record is stored in

	/**
	* A script to help identifying which Analytics tables a record is stored in.
	*
	* It works by retrieving the count for every table in the account and saving that to browser local storage
	* The next time the script is run, it will compare the current count for each table, and identify any tables
	* that have changed.
	*
	* USAGE:
	*
	* This script is intended to be copied and pasted into browser dev console. I recommend using the Chrome Snippets Feature

michoelchaikin / netsuiteSS2Anywhere.js

Created July 24, 2020 02:44

	/**
	* Usually if you want to access the SuiteScript 2 API via the browser console you need to open specific pages
	* that load the required libraries (such as a record in edit mode). This script will load the libraries on any
	* NetSuite page
	*/

	(async () => {

	/* Add a script element to the DOM and wait until it's loading by checking that
	a known variable it creates exists */

michoelchaikin / invoiceWithGroups.xml

Created February 9, 2020 09:44

NetSuite Advanced PDF/HTML Invoice Template with the products grouped by class

	<?xml version="1.0"?><!DOCTYPE pdf PUBLIC "-//big.faceless.org//report" "report-1.1.dtd">
	<pdf>
	<head>
	<link name="NotoSans" type="font" subtype="truetype" src="${nsfont.NotoSans_Regular}" src-bold="${nsfont.NotoSans_Bold}" src-italic="${nsfont.NotoSans_Italic}" src-bolditalic="${nsfont.NotoSans_BoldItalic}" bytes="2" />
	<#if .locale == "zh_CN">
	<link name="NotoSansCJKsc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKsc_Regular}" src-bold="${nsfont.NotoSansCJKsc_Bold}" bytes="2" />
	<#elseif .locale == "zh_TW">
	<link name="NotoSansCJKtc" type="font" subtype="opentype" src="${nsfont.NotoSansCJKtc_Regular}" src-bold="${nsfont.NotoSansCJKtc_Bold}" bytes="2" />
	<#elseif .locale == "ja_JP">
	<link name="NotoSansCJKjp" type="font" subtype="opentype" src="${nsfont.NotoSansCJKjp_Regular}" src-bold="${nsfont.NotoSansCJKjp_Bold}" bytes="2" />

michoelchaikin / mos_product_search.html

Created March 8, 2018 22:11

Product Search Suitelet

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="utf-8">

	<link rel="stylesheet" type="text/css"
	href="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.css"/>
	<script type="text/javascript"
	src="https://cdn.datatables.net/r/zf-5.5.2/jq-2.1.4,dt-1.10.9/datatables.min.js"></script>

michoelchaikin / postmanNetSuiteTBA.js

Last active December 23, 2023 19:06

Postman pre-request script to generate TBA variables for NetSuite Web Services

	/*

	Usage:

	1. Define a NetSuite environment in Postman (https://www.getpostman.com/docs/postman/environments_and_globals/manage_environments)
	with the following keys set: account, consumerKey, consumerSecret, tokenId, tokenSecret

	2. Add this script to your "Pre Request Script" in Postman (https://www.getpostman.com/docs/postman/scripts/pre_request_scripts)

	3. Add the Token Passport in your request with variable placeholders

michoelchaikin / mos_lookup_history_cs.js

Last active December 7, 2018 20:56

Lookup History Netsuite Customization

	/**
	* Client side code for Lookup History customization
	*
	* Script Type: Client Script
	* Deployed to: <not deployed>
	*
	*/

	'use strict';

michoelchaikin / gulpfile.js

Last active July 26, 2017 21:19

Gulpfile for Netsuite development

	const gulp = require('gulp');
	const typescript = require('gulp-typescript');
	const del = require('del');
	const keepass = require('keepass-http-client');
	const spawn = require('child-process-promise').spawn;
	const open = require('open');

	const PROJECT_NAME = 'XXXX';
	const PROJECT_URL = 'https://system.sandbox.netsuite.com/app/site/hosting/scriptlet.nl?script=XXX&deploy=XXXX';
	const SDF_CLASSPATH = 'C:\\Users\\michoel\\Desktop\\sdf\\\*';

michoelchaikin / mail_to_printer_setup.md

Last active May 28, 2019 02:02

MAIL TO PRINTER GATEWAY

sudo adduser autoprint
sudo apt-get install fetchmail postfix

/etc/default/fetchmail

START_DAEMON=yes

michoelchaikin / printlabels.js

Created August 18, 2016 23:58

Netsuite Advanced PDF/HTML templates for any record type

	/**
	* Add 'Print Item Labels' button to Item Page
	*
	* Script ID: customscript_mos_itemlabels_ue
	* Script Type: User Event
	* Deployed to: Inventory Item
	*
	*/

	function beforeload(type, form) {