-
New to NetSuite | N/record: Column.isMandatory Property
In our previous article, New to NetSuite | Understanding SuiteScript 2.x Modules, we explored the SuiteScript Modules and N/record module, New to NetSuite | N/record Module Overview, which is used to interact with records. Now, we will take a closer look at one of the members of N/record: Column.isMandatory Property. The…
-
Question about sorting fields on the SC website
I have a question regarding item list sorting in SuiteCommerce and would like to confirm my understanding. Previously, I thought that under Website Setup → Search Index → Sort Fields, this configuration defined the actual sorting logic for item lists. For example, if three fields (A, B, C) are configured, I assumed it…
-
Paired Intercompany Transactions field in Saved Searches
Quick question about the Pair Intercompany Transaction field (intercotransaction), when pulling this in to a saved search it displays the internal ID of the paired transaction not the document ID. Is there a modifier or other field I can pull in to see the document ID?…
-
Procurement Vs Demand Creation
Hello- My Boss is looking to be able to measure a metric for Purchased date vs Demand Creation. Basically, he wants to know the variance between when demand was entered for a part vs when Procurement purchased the item. I have been racking my brain on how I could pull this information off in NS. No such luck. The supply…
-
Saved search to show the source data of cross charge journals
Hi everyone. I'd like to run a saved search that shows the source data of cross charge journals. Our cross charge journals are created from cross-entity Item Fulfilment and Item Receipt. I created a transaction search, but it just shows the details of the journals.
-
Error: Invalid Expression When Using a Formula in Creating a Transaction Saved Search
When creating a Transaction Saved Search using the Formula: SUBSTR({account},1,1), the system throws an error: ERROR: Invalid Expression. But when it's modified to SUBSTR({account},2,1), it properly shows the 2nd value from the account number. This error happens when the Formula Context used is Formula (Numeric) instead of…
-
Retain Sales Order Item Pricing with SOAP/SuiteTalk
I have an integration with NetSuite using SuiteTalk/SOAP that commits lines on Sales Orders. I am running into an issue where prices for items are not retaining after the item has gone through a price increase. When saving the SO back to NetSuite using SOAP services, it's pulling the current price and updating the line and…
-
How to Practice NetSuite Without a Sandbox or Paid Account?
Hi everyone, I'm currently trying to learn NetSuite and get hands-on experience with the platform, but I don't have access to a NetSuite account or a sandbox environment. I'm wondering if there are any free options, demo accounts, training environments, or community-supported sandboxes available for learners like me? Any…
-
How to stop SOAP Web Services Process
Hi there! I'm working in our sandbox, trying out some asyncSearch. I naively submitted a job to query all transactions with no filters, and the resulting job seems hung. the "time remaining" keeps going up to increasingly astronomical numbers. I thought I'd wait a max of 15 minutes for a timeout, but no such luck. It's…
-
How to transform Sales Order To Invoice with inventory details
Is it possible to transform a Sales Order to Invoice and set the lot values (invemtory details) for the items?