Issue 135445 was filed for truncated serial/lot numbers when using the report builder. An alternate solution is to use the Inventory Numbers saved search: Lists > Search > Saved Search > New > Inventory Numbers.

Hi John, how about grouping your results in the Summary Type field? For each result field, add the "Group" Summary Type and preview the search. Here's an overview of grouping results and how drilling into those grouped fields works.

SuiteAnalytics Workbook enables you to join multiple record types to a single workbook. This includes record types that are more than one join away from the root record type of a workbook, enabling you to compile workbook source data from a more diverse set of records. To join a record to a workbook, simply click the Join…

Please see reply to your thread -

I think this functionality was introduced in SuiteTax. Zip+4 accurate tax determination is now available with SuiteTax Engine (beta version) - if you are interested in testing, please contact your account manager or submit a Support Case to request access to SuiteTax.

A couple of suggestions from SuiteAnswer 45639: 1. The User Event Script should be set to "Released" Status. Reason: Whenever running a Scheduled Script, the user that will be logged as the one who triggered the script is "-System-".If the User Event script is not set to Released (meaning it is set to Testing), then, only…

I saw a similar case that required switching to the basic layout in order to remove the memo field since Advanced Templates automatically inserts the code. I'm not sure if the basic layout meets your requirements, but this is what worked for others: 1. Create a Custom Check Layout, and remove the Standard Memo Field >…

How about setting the memo element size to 0? 1. Navigate to Setup > Customization > Transaction Form PDF Layouts. 2. Click Customize or Edit on the preferred Check Layout 3. Click the Memo field 4. Locate the Element Size 5. Put 0 on Width 6. Put 0 on Height 7. Click Save.

Hi @"Chris.Wognum", unfortunately I don't think you can use the doc number. According to SuiteAnswer 9980: A payment can be associated with an invoice through the internal ID or external ID only. The transaction ID is not unique and cannot be used. We are tracking this request in Enhancement 175924 - Setup > Import/Export…

Maybe a formula field would work if you are searching for the same value. It depends on the field type, but here's an example comparing a text field: Formula : Case When {fieldID} Like 'searchTerm' then 1 End Formula (Text) > Select is > 1

Thanks @"k_dunc" - your case is being reviewed.

${item.item.baseprice} - this gives us the baseprice, but strangely enough, only of the first Item, so all subsequent Items show the first Item's Base Price.${item.custcol_1} - this is a Custom Line field where we've set its sourcing as the Item's Base Price (not Stored Value). What this shows, however, is the Item's Base…

User Notes are not exposed to Workflows yet but we do have an Enhancement Request for this -186715 : Workflow > Workflow State > New Action > Create Record > Make User Notes available. Another option might be to call a script like you suggest. Client script functions can be invoked by any Workflow Action that supports…

Hi @"JGriffin", the link under the Support tab of your NetSuite Account will be updated in the 6/6 e-fix.

Hi @"gabe17", this is being tracked in Enhancement Request 288864 : Custom Record Type > Allow users to attach a file on a Custom Record Online Form. I saw a similar case that suggested this is possible using SuiteScript: This is possible but it will require native javascript functions like window.open (which is outside of…

It's just effectively been replaced by SuiteCommerce? That is my understanding @"k_dunc" .

This field is exposed in SuiteScript, however not in Web Services. We are tracking this request in Enhancement Request 505712 : Web Services > Inventory Adjustment > Inventory Details > Expose Inventory Status field. * Record Browser for SuiteScript…

Hi @"k_dunc", Site Builder is the legacy ecommerce solution. This SuiteAnswer provides an overview and here are a few related topics: * Site Builder versus SuiteCommerce Features * Site Features * SuiteCommerce Site Builder * Setting Up Your Site Builder Site * Site Builder Overview

It's difficult to say how quickly an import should take to complete. The number of records, sublist fields and job queue all play a role. For example: SCENARIOUser is running a CSV import to update the Phone Number on specific addresses of ten (10) customer records. The customer records involved have multiple addresses…

I think you only need to set it once in production and subsequent refreshes will respect that setting.

We are tracking this request in Enhancement 64715 : Ability to customize layout of Bank Reconciliation screen. You can vote for this and other enhancements in SuiteIdeas. From the Support tab, use the SuiteIdeas portlet to visit SuiteIdeas and search through all existing NetSuite enhancement requests. You can vote for the…

There is a setting to disable email alerts in sandbox: 1. Log in to your NetSuite Production account. 2. Navigate to Setup > Company > Email Preferences. 3. Click the Email tab > Sandbox and Release Preview Ensure Do Not Send Emails is selected.

This may involve scripting. I found a similar error in Answer Id: 63287: Scenario: Some users are getting an error email upon processing some Sales Order records: "The field reorder contained more than the maximum number (15) of characters allowed." The reason for this is that the value for the Reorder Point Field is a…

Thanks for clarifying, @"RickG_1136". I should have mentioned the "Store Value" option when you said you were sourcing the value from a custom record.

JCirocco wrote:I am struggling with a csv import for Customer Payments. I have a remittance of hundreds of lines and within the customer payment there are credit memos. Unfortunately, it appears that I can only include Invoices in my mapping. Is there a way to also specify credit memos? Once the payment is created I cannot…

The main differences are searches allow advanced data filtering and sorting options. Saved searches support more complex data manipulations than reports and the ability to send email alerts, but do not provide the same level of presentation formatting.

Thanks for the update, Tom. I see your case is being worked on.

I meant MLI enabled in the account and Bins = T on the item record. I haven't seen any issues reported for inventory count mismatch, but there are a few related SuiteAnswers: * Inventory Mismatch where quantity on hand is different from bin on hand due to transactions with unassigned bin numbers that happen prior to the…

The 'h' parameter appears to be part of a hexadecimal md5 hash. The signature is automatically generated and verifies that the request came from the NetSuite application.

Does the item have Multi-Location Inventory feature = F and Use Bins = T ?