Keyboard Shortcuts in NetSuite

Keyboard Shortcuts 1. When inputting a date, type “t” in the box to autofill with today’s date. 2. Type “y” to autofill with the previous day’s date. 3. Press “Shift + t” to autofill with the following day’s date. 4. Type “m”to autofill with the final day of the current month. 5. To reach the global search bar, press “Alt… Continue reading Keyboard Shortcuts in NetSuite

Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search

Scenario When users use CONCAT to join multiple fields, the expression as below is used: Concat({fieldidAAA}, concat(concat(‘ ‘, {fieldidBBB}), concat(‘ ‘, {fieldidCCC}))) However, when the said expression is used to join a character, it gives an Invalid Expression. Sample formula that shows this problem: Concat({fieldidAAA}, concat(concat(‘ ‘, ‘&’}), concat(‘ ‘, {fieldidBBB}))) Solution Sample formula that shows… Continue reading Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search

Resolved unexpected error when opening a Report Saved Search

Scenario The customer created a Report Saved Search and is encountering an Unexpected Error when opening the search.     Solution Given that the nature of the Search created is a Report Saved Search, the error was encountered because of Show Totals = True on the Results tab. Since this is a Report Saved Search,… Continue reading Resolved unexpected error when opening a Report Saved Search

What is SAML Single Sign-on?

SAML (Security Assertion Markup Language) is an XML-based standard that supports communication of user data among various applications, called service providers (SPs).An identity provider (IdP) makes security assertions consumed by SPs. A single IdP can perform user authentication for many SPs. A particular SP and an IdP can establish a circle of trust by providing… Continue reading What is SAML Single Sign-on?

Unable See Custom Role for Sandbox Under View All Roles Dropdown

Scenario: User refreshed Sandbox but the Custom Role does not appear under the View All Roles list. Solution Troubleshooting steps: Reset user’s the password to make sure that the passwords match with production and sandbox Remove the permissions set up SAML Single Sign-on and SAML Single Sign-on from the Setup subtab of the custom role Added a standard role and another custom… Continue reading Unable See Custom Role for Sandbox Under View All Roles Dropdown

Resolve Error: “Error during loading transaction for advanced printing caused by: Attempting to access memorized transaction as non-memorized transaction.”

Trying to print a memorized transaction that have to be processed will give a message: “attempting to access memorized transaction as a non memorized transaction”. Notice that the Transaction number is yet to be generated. Transaction generated from the memorized transaction should be the one printed. Navigate to Lists > Relationships > Customers Click Sales Click Transaction Document Number Column: Click Memorized Click Print Result : “Error… Continue reading Resolve Error: “Error during loading transaction for advanced printing caused by: Attempting to access memorized transaction as non-memorized transaction.”

How to add date craeted field in picking ticket page

The customization for the “Print Picking Tickets” screen, including the “Date Created” field, will only apply to the account where it was done . If you need to see this customization in the  your account, please follow the below steps: Navigate to the Print Picking Ticket screen in the production account. Click on Customize . In the… Continue reading How to add date craeted field in picking ticket page

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

Create a Saved Search Showing Items Whose Prices Changed Recently

Customers wants to create a saved search to help determine any price changes made within a recent period. Solution 1. Navigate to Lists > Search > Saved Searches > New. 2. Click Item 3. Click Criteria  4. Click Standard 5. Filter:  Select System Notes Field System Notes Filter: Select Field Field: Select Pricing Notes: You can use System Notes : Rate as well. Select System Notes… Continue reading Create a Saved Search Showing Items Whose Prices Changed Recently