Pierre_Plourde · IT Manager/NetSuite Administrator · Silver Medal

Hi @Alex Joves -Oracle , I have voted for the SuiteIdea.

Following, as I've had several of my users ask the same question. We also have a related question about whether it is possible to add columns to the view, specifically columns for the matrix options.

Your assumption is correct: Date of Last Order represents the Date of the last Sales Order; Date of Last Sale is the date of the last Invoice or Cash Sale. As for why one of the fields works while the other does not, your guess is as good as mine at this point; from my review of the Records Browser, I would have come to…

Interesting, I would have expected that behaviour if you had selected Date/Time as the field type for the custom field. Since you picked Date as the field type, I have no idea why it's coming across as a Date/Time.

@Curtis Beene I have noticed the same thing, all the automated emails from NetSuite come to the junk mail. If I whitelist the user, it's fine, they start going to the inbox, EXCEPT for those that NetSuite sends as me: even whitelisting myself doesn't prevent it from going to junk. And yes, DKIM, SPF, and DMARC are all ok.…

@Gavrah Rabba and @MTL_MIA : for the Date of Last Sale field, look at this page in the NetSuite Records Browser: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2024_1/script/record/customer.html Scroll down to Search Filters and Search Columns, the field ID is {lastsaledate}

Hi @Gavrah Rabba , Your custom field is set to not store the value (note the unchecked Store Value checkbox in the first screenshot). But in any event, there is a standard field Date of Last Sale that you can pull in saved searches and reports. It doesn't display by itself on the Customer Record, so you would still need a…

We are also experiencing the issue, out of the Montreal Data Center.

Not that I am aware, but Coastal has a scripted solution that does exactly that which they sell.

Button, no, but you can add a link to the bill page using the Formula (HTML) type if you can figure out the correct URL. I don't have an open PO handy to test with, but I imagine the URL will be the same, with the internal ID of the PO being the variable.

Hi @Rahul_Thakur, Are you using Advanced PDF Templates? If so, what you want is something like this: <#if line.amountremaining gt 0>${line.amountremaining}<#else>$0.00</#if> Hope this helps.

Do you have the Supply Allocation feature enabled (SuiteAnswer 87875 (https://suiteanswers.custhelp.com/app/answers/detail/a_id/87875/loc/en_US))?

Because generally workflows don't work on sublist lines? And for the exceptions, you need to first create a Sublist Action Group in the State in question.

Sounds like you are looking for the Order Reservations feature. See SuiteAnswer 98840 (https://suiteanswers.custhelp.com/app/answers/detail/a_id/98840/loc/en_US) and the Related Topics noted in that SuiteAnswer.

This error happens when two users are editing the same record at the same time. The first user to save has no issue, but then the second user to save gets this error. In this context "user" can include the system, or an integration, a script, a workflow, etc. From the error message, this is happening on after record…

So, in Sandbox, if you turn off Allow Override, does that stop the issue from happening? If so, then I would look to a User Event script or Workflow that affects the Document Number field.

Are you using Auto-Generated Numbers for Sales Orders: If so, is it set to Allow Override? If not, how are your Sales Order Document Numbers being generated?

Most common way of pre-populating the Class/Department/Location body fields on transactions is from the user by having the Role set to "default to own" on each segment: Then, when a user using such a role creates a transaction, the classification fields will pre-populate from what's on the Employee Record of the user. Note…

This may be a stretch, but I note there is no Vendor Code entered for Vendor 01100 FAIRVIEW LTD - ON on Item FIT-X107-E in your first screenshot. If you put in a Vendor Code in that line, does it make a difference in what you see on the Vendor Record?

You only need to worry about it if you have data stored in the field on any records. In the SQL back end, changing the field type is the equivalent of adding a column to the table and deleting the original column, so no data gets retained at all. My recommendation, if you have data that needs to be kept, is to create a new…

Your understanding is correct: record only journal entries associated with customers/vendors, and tag these when applying payments. The one-line transaction suggestion is the same as in the Optimal Data article, and will likely be my approach if we do decide to import retro.

Following.

@MTL_MIA that is correct. I don't see the need since payments in the new fiscal can still be applied to the opening balance (thus reducing the net open balance). The only downside is the lack of aging. On the other hand, the data structure in the existing instance is so vastly different from best practices, that the amount…

@Jeremy Guimaras -Oracle yes, we have negotiated a new instance of NetSuite and the old instance's renewal for the overlap period was fully comped by Oracle. My implementation plan is to import only balances and non-transactional data. The data in the old instance would require a tremendous amount of clean up of a large…

Something, somewhere, that is running when you are saving the Employee Record, is calling JSON.parse in the JavaScript. That is what is generating the error. If you can isolate between client-side and server-side, you can check the appropriate logs for the error and go from there to find out what about the data isn't…

@MTL_MIA , unfortunately, the Address Sublist is not a customizable sublist, so while you can store and access the data (e.g. on an Advanced PDF Template, or in a transaction record once an address is selected), there is no way to make it display in that sublist.

Go to Customization → Lists, Records, Fields → Other Record Fields → New. Then select "Address" as the Record Type.

Issue is that the BFO engine used to generate the PDF adds <p> tags to the text inside table cells, so the <p> tag ends up inside your <span> tag and so takes the text-align property from the td p { ... } CSS, which is left, overriding the right in your <span>. If you want to avoid this, put in an explicit <p> tag inside…

Hi @Andy Bruner , Do you happen to have Google/Chrome Address autocomplete on by any chance? It's a known problem that if the address autocomplete fills in the State, it doesn't save because it's setting the string rather than the select value. P.

Hi @User_1IC76 : You need to make sure to select the same character encoding used to save the CSV file: If you save the CSV file as Unicode, select Unicode; if Windows 1252, select that, etc. If the encodings don't match, the characters will get scrambled, as you've observed.