-
Question about Scriptable Cart
Hi everyone, I have a question about Scriptable Cart and would appreciate some advice. I've recently come across the Scriptable Cart feature, but I don't fully understand the difference between Scriptable Cart and SuiteScript 1.0 Client Scripts. Are they designed for different use cases? Can Client Scripts replace…
-
How can I enable Store Pickup in a SuiteCommerce website?
When I try to enable Store Pickup feature, I get this message: “You cannot enable Store Pickup feature because SuiteTax feature is enabled.” However, I need SuiteTax for proper tax calculation, so disabling it is not an option. Is there any way to support both SuiteTax (for tax calculation) and Store Pickup at the same…
-
Error: Sales Order Transform to Item Fulfilment
anyone else experiencing issues in fulfilment via script or integration?? Noticed in our sandbox account coz of testing! Even transforming in the console doesn’t work
-
Script for Hiding 'Expiration Date' on Inventory Detail Pop-up
In our business, we need lot control, but our products don't ever expire. To avoid confusion with our users, I'd like to hide the 'Expiration Date' column that is on the inventory detail pop-up. This would apply on the Inventory Adjustment form, the Item Receipt form, the Item Fulfillment form, and any other form where…
-
Assistance on OAUTH2.0 Client Credentials Authorization Flow
After Following the instructions at https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_157769826287.html, I have been having issues connecting to NetSuite with my php code. So far as I can tell, everything has been done correctly, however I am still receiving an "invalid request" error.…
-
Suitescript 1.0 nlobjSearchFilter issue on field containing object
My suitescript 1.0 script is using a search filter to return a transaction recordset. I'm trying to search on the 'createdfrom' field for the value 'Sales Order #ORD165365', but the filter has no effect (I think) because this field is actually an object. If I view the output from my RESTlet, I see the following structure:…
-
PDF file received form an online form won't set in a document field on custom record
We receive files from customers via an online external form and use a suitelet to process the information and save it to a custom record. The files are first saved to Netsuite file cabinet then the file id is used to populate the document field on the custom record. when this file is a jpg or png the field is populated and…
-
Add Logo to Send Email Notification Workflow
HI, I want to add our company logo to send email action. For email content, I am using a custom email. How can I do this? Can you provide HTML to put in body of email to pull logo from file cabinet?
-
Custom Suitelet
Hi, I am wondering if this is possible to achieve via custom Suitelet in NetSuite. The idea is it somewhat works like work orders. But it allows us to select multiple output items. We select what inventory items/consumables (materials) were used to create the item. The materials will be deducted from available on-hand…
-
A form field appearing in the search for only one customer and automatically populating date filter?
I’ve noticed that for one specific employee, a form field is appearing in the search and the date filter is being automatically populated when using a particular role. However, this behavior is not occurring for other employees using the same role. Could you please help me understand why this is happening only for that…
-
Adding an option to print package contents and quantities to ship central
The goal: Being able to print a pack list to a label in the Ship Central mobile emulator. In essence, there would be two columns. One column would be the item, the other would be the quantity. You click the button, it shoots it to the label printer next to the pack station. Like this: Medium T-Shirt x 10 Large Hoodie x 2…
-
Tax item mapping on Customer record via webservices with avalara tax engine
Hello NS community, Recently i came across a roadblock which took me forever and finally i did find a solution via a workflow written on NS, but i wanted to check if anyone was successfull in achieving the below. Issue: The Tax item isnt being mapped on an customer record, when it is being pushed via webservices Tried the…
-
Query using orderLine table works in SuiteQL but not in ODBC query
Hello! I'm running into an issue with a ODBC query I'm trying to write for the Netsuite v2 data source that involves the orderLine table. When I run the query in SuiteQL it works just fine and returns the expected results. However when I run the query through ODBC I get the error: "[NetSuite][ODBC 64bit driver][OpenAccess…
-
How to update our Positive Pay file to output in csv and show the correct payee name?
When using the standard BoA/ML positive pay format, the output is txt. I tried to change that to csv in the "output file extension" and also update the output file encoding, but then the positive pay screen returns no checks at all (it works like it should when the output is txt). We also have some Payee's that have a…
-
About the field type DATETIMETZ
I created the page using suitelet script. But it is difficult to enter the time when the field type is datatimetz. Question 1: When the system language is not English (International), you cannot enter the afternoon time, and you cannot enter or modify the hour. Question 2: After the system language is switched to English…
-
How to query Vendor Tax ID information using SuiteQL?
Hi all, Vendor page has Tax ID under Financial tab -> Tax information in the UI. However when I go to Records catalog it is not available under vendor table or any other table I checked. I need to be able to query this information via Suiteql. Where could I find Tax ID information for a vendor? Thank you
-
Invalid request while authenticating oAuth 2.0
I am having issue with OAuth 2.0. I have tried the suggestions in the following thread but no luck. trying to connect to ADF using Auth 2.0 code flow. I have followed every step in the documentation but can't find the issue. Error "Invalid Request" I have custom admin access and have created integration record with OAuth…
-
Work Order reference to specific Sales order Line
I need to match a work order with it's corresponding line in the related Sales Order. My script works fine finding the line using the Item number in a saved search. However, the item number may be more than once in the sales order, so, I need to get to the specific Sales Order line referencing my Work Order. I have tried…
-
Products Not Showing on Quote List Page
On the Product Details page, select a product and click 'Add to Quote,' the products are added. However, the products are not showing up in the Request Quote list page(in website). They do appear in NetSuite. how to fix this issue.
-
Permission Type in saved search report
I am trying to create a saved search report but am not able to find any report type where I can get the column Permission Type (Transactions, Report, List, Setup). I have created a "Role" type report and added Name (Role) , permission and level columns but I need to add a category column as well giving information about…
-
Custom Purchase Transaction optional inventory detail
Hello gurus Is it possible to make optional the inventory detail in a custom purchase transaction? I have tried to hide the inventory detail sublist field in the form but it remains as mandatory when I try to save the record. Please help
-
Exceed file size from 10 MB?
Is there a possibility to exceed the file size limit saved in the file cabinet to increase from 10MB. Currently, I am using suitelet to save file in the file cabinet but since the size exceeds 10 mb it gives sss content size exceeded error.
-
Issue on product stock fetching using SOAP API.
Hi, Firstly, I'm retrieving products, but the locationLists are missing. This locationLists should include quantityOnHand based on different locations, but it's currently locationLists showing as null. $itemRequest = new GetRequest() $itemRequest->baseRef = new RecordRef() $itemRequest->baseRef->internalId = 945…
-
How to get Saved search values in code
I created a saved search that contains customer ID, due balance, and several other fields. How can I retrieve the values from this saved search in code and display them on a website? We are using SuiteCommerce Advanced 21.1.5.1
-
How can I display the check# field on a bill sourced from a bill payment in a custom field?
Hello, There is a field "Check#" with the field ID "tranid" on the Bill Payment record. However, I want to display this field on the Bill record in a custom field. Could someone help with this issue? Thank you.
-
Saved Search Formula To Sum Numbers In Text Field
I have a text field let's just call it {textfield} that will contain data like this:- e.g. ["400.00","500.00","300.00"] [300] ["100.00","200.00"] etc.. I am trying to create a formula field to sum the numbers in this text field but no luck. I tried this to remove all the [, " and comma and hope by adding a + it will auto…
-
Is there a way to set the default value to "all" in the Line Items field in a record?
Hi, Is there a method to completely remove this and have the page automatically display all lines, or simply default to showing all lines for all records like quotes, sales orders ,purchase orders etc? Thank You.
-
Is it possible to set distinct locations for credit and debit entries in the GL impact of the
Hello, For example in Item Receipt the location(main) and location(line) are different. The Debit should be going to location(line) and credit should be going to location(main). Is it possible to implement this requirement? Thank you
-
Getting error in Item receipt: Multi-location Inventory Error (MLI_LOCATION_REQUIRED): ?
Hi, In item receipt I'm getting the following errors. Note: Multi location feature is enabled and it is needed requirement. The line-level location is hidden in forms. When attempted to hide, above error message is given, related to multi-locations. Could please help me how to solve above error when location(line level) is…
-
It is displaying applied credit memos that are not applied the bills in the bill payment record?
Hi, The bill payment record displays applied credit memos(applied to other bills that are not there in this Bill payment) within Bill payment record. Is it normal functionality? If not could you please help me why it is happening. Than you