Author: Praiselyn Fiana D

Create an Item Search Which Displays Location Quantity On Hand on Separate Columns

Scenario To display the On Hand quantity per location, user needs to add the following columns to an item search: Inventory Location and Location On Hand. However, this will be displayed as multiple rows per location. User would like to view the Location On hand per column. Solution To create an Item search which displays Location Quantity On Hand on separate columns, please follow the steps… Continue reading Create an Item Search Which Displays Location Quantity On Hand on Separate Columns

Malaysia e invoice in Netsuite

As of January 1, 2025, Malaysia mandates electronic invoicing (e-invoicing) for businesses, following a phased implementation that began on August 1, 2024. storecove.com To comply with the Inland Revenue Board of Malaysia (IRBM) regulations, NetSuite offers the Malaysia Electronic Invoicing SuiteApp, enabling users to generate and certify e-documents for various transactions, including invoices, credit notes,… Continue reading Malaysia e invoice in Netsuite

OBN Registeration in NetSUite for einvoicing

To enable electronic invoicing (e-invoicing) in NetSuite through the Oracle Business Network (OBN), follow these steps: 1. Install the NetSuite Electronic Business (NSEB) SuiteApp: Access the SuiteApp Marketplace: Navigate to Customization > SuiteBundler > Search & Install Bundles. Search for NSEB SuiteApp: Enter “NetSuite Electronic Business” in the search bar. Install the SuiteApp: Locate the… Continue reading OBN Registeration in NetSUite for einvoicing

Expose the Seconds Timestamp from the Transaction System Notes of Transaction Saved Search

Scenario User wants to create a Transaction Saved Search to expose the seconds timestamp from the transaction’s System Notes. Solution To be able to expose the timestamp in seconds of the Transaction System Notes of Transaction Saved Search, user needs to add the following in the Transaction Saved Search:  On the Results tab  Filter: Select Formula (Text)  Formula: Add to_char({systemnotes.date},’HH:MI:SS’) 2.Click Save & Run  

The user wants Purchase Order to be automatically created upon approval of a Sales Order using Drop Ship/Special Order Item

Scenario The user is creating a Sales Order using a Special Order Item. Upon approval of the Sales Order, no Purchase Order is created.  Solution For a Purchase Order to be automatically created upon approval of Sales Order:  Check Item Record > Purchasing/Inventory tab > Vendors subtab For each Subsidiary where the Item is used, make sure that there is a Preferred Vendor set  Note: 1. A Vendor can be… Continue reading The user wants Purchase Order to be automatically created upon approval of a Sales Order using Drop Ship/Special Order Item

Create And Associate BOM And BOM Revision Records To Assembly Item Record Via CSV Import

Scenario User wants to create and associate BOM and BOM Revision records to Assembly Item record via CSV import. Solution I. CSV Import – Bill of Materials (BOM) 1. Setup > Import/Export > Import CSV Records 2. Set the following: – Import Type = Supply Chain – Record Type = Bill of Materials 3. Select the CSV file. 4. Click Next. 5. Import Options, set to Add. 6. Click Next.… Continue reading Create And Associate BOM And BOM Revision Records To Assembly Item Record Via CSV Import

Saved Search: Transfer Order Indicating Location To and From, Quantity Received and Fulfilled and Employee

Scenario Saved Search: Transfer Order indicating Location To and From, Quantity Received and Fulfilled and Employee Solution Navigate to Lists > Search > Saved Searches > New. Select Transaction. Set the Search Title. Under the Criteria tab > Standard sub tab > Add: — Type is Transfer Order — Main Line is false (no) Note: You may add more Criteria, as needed. Under the Results tab > Sort by: Date = Descending is True > Columns sub tab > click Remove All button >… Continue reading Saved Search: Transfer Order Indicating Location To and From, Quantity Received and Fulfilled and Employee