Helpdesk Request Form
Lab Closure Procedure
Resource Drive Conventions
Support Article Guidelines
Email & Calendar
Add Calendars to iPhone
Create a Shared Calendar
Create an Email Group
Email Filters & Rules
Google 2-Step Verification
Google Calendar Overview
Staff Minus One Emails
Using Outlook with Gmail
Print & Fax
Adobe Acrobat DC
Adobe Creative Cloud
Combine PDFs in Adobe Acrobat
Excel Trust Settings
Install Falcon Anti-Virus
Mosyle Mac Enrollment
Windows 10 - Restore from backup
2020 December - email name spoofing
2020 October - COVID resources
2021 December - WiFi
2021 January - Zoom recording + private chat
2021 March - NetSuite Google authentication
2021 March - VPN Upgrade
2023 - Zoom Updates
HPCC and Storage Proposal Information
Migrating data from Storage to Google Drive
Zeiss Digital Classroom
HR & Payroll
Paid Time Off
Payroll Overview & FAQ
Timesheet Approval (supervisors)
Bigelow R/V Billing Form
E&I Wing Construction Update
R/V Bowditch Reservation Center
R/V Clarice Reservation Center
Bill Sales Order
Budget & Reports
Policies & Procedures
Advancement Entry of Donations and Pledges
Corporate Traveler / Melon
Gas and Cryo-Supply Ordering Process and Form Link
Purchasing Flowchart - for staff reference
Vendors Exempt from Purchase Orders
Purchase & Expense
Creating a Bill to be Paid
Expense Report (example)
Purchase Order (example)
Purchase Order (supplemental)
Recurring Purchase Order (SRS)
Business Office Orientation
Revenue Flow Chart
Connect to Charlie
Edit with VS Code
Step 1: Update the following fields in the Excel CSV Import.
External ID: Enter a unique External ID. Each import should have a unique external ID mentioned on it and unique from the previous imports.
Date: Enter date of transaction in the following format: Month/ Date/ Year. (06/03/2021).
Inventory Adjustment Adjustments: Line
Enter the line of the item on the transaction record. Each item should be entered on a new line. For example:
If we have two items, then we will have two lines with each item entered on a new line. Please see example below:
Similarly, as we add more items, we will have to add new lines.
Inventory Adjustment Adjustments: Adjust Qty. By (Req): Enter the quantity that you want to adjust the quantity of the item by. This should be in the form of additions or subtractions to the present quantity that you will be making. If we are increasing the quantity, then we will be input a positive number to show how much we are increasing it by.
If we are decreasing the quantity, then we will have to write a negative number so the value reduces.
Inventory Adjustment Adjustments: Item: Enter the internal ID of the item that we are doing the adjustment for.
Internal ID of an item can be accessed by doing an export of all items and matching the internal ID of the item with the item name.
This can be accessed by navigating to the saved search named ‘BLOS - Inventory Adjustment Item Internal ID’. This is a public search and should be accessed via global search.
You may export the excel file and then find the Name of the item in the excel file so you can find it’s associated internal id.
Inventory Adjustment Adjustments : Est. Unit Cost: This will be set to $ 0 and should remain so.
Inventory Adjustment Adjustments – Inventory Detail : Quantity: Enter the quantity of the adjustment that needs to happen.
Example: If the adjustment that needs to happen is 3 units, then the quantity will be 3.
Inventory Adjustment Adjustments - Inventory Detail : Receipt Inventory Number: Enter the serial number of the items that you are importing. Since each item will have one serial number irrespective of the quantity being added, we can simply record one value per line, and it will create those many new items with the same serial number.
Step 2: Login to NetSuite to perform the upload of the inventory items.
- Navigate to Setup > Import/Export > Saved CSV Imports
- Navigate to the ‘TEST CRYO UPLOAD - Single File‘ and click on it.
- Select the file you want to upload and click next.
- On the Import Options page, select ‘ADD’ under Data Handling and then hit ‘Next’.
- On the Field Mapping page, check that the mappings for all fields and columns are as follows. Once added, click ‘Next’.
The following fields have been hardcoded in the saved import and will not require any change from you.
49000 Cost of Goods Sold <--> Inventory Adjustment Account (Req).
Old Thaws <--> Inventory Adjustment Adjustments: Location (Req)
BLOS – OLD THAWS BIN <--> Inventory Adjustment Adjustments – Inventory Detail: Bin
- On the Save mapping & Start Import, press ‘Save & Run’ from the dropdown.
- On the next page, click the ‘Import Job Status’ page to view the status of the Import Job.
- View the job import status to see how many records were imported.
Some Common Errors that you may encounter are:
- This record already exists
Cause: This error appears if the external ID was already used in a previous transaction.
Solution: Ensure that the external ID mentioned on the import file is unique and there have not been previous imports with that external ID.
- Date field not in your preferred date format for field "Date" – You have entered an Invalid Field Value x/x/xxxx for the following field: trandate
Cause: Invalid Date Format
Result: Update date format in the excel csv file.