SuiteSean

@"Pauline Joy Cac-Oracle" This is a great feature~ I noticed this in a prior version of the documentation. I was under the impression that using nsformat_currency would work in the way you described without enabling the feature... What exactly does the checkbox in 'Enable Features' change?

in New Field Formatting Options (FreeMarker Enhancements) Comment by SuiteSean Dec 16, 2019 2:39PM

Sean, Where in Arizona? I am in Phoenix (AJ) and amazed we do not have a local users group here. Hi @"JCirocco", I'm in Scottsdale. There are several of us in the area, and we have a Partner with an office in AZ as well.. 360 Cloud Solutions. Send me your info and we'll connect!

in Introduce Yourself! Comment by SuiteSean Sep 17, 2019 3:29PM

My name is Sean. * Located in Arizona * I have been working in NetSuite for 5 years as a User, and for 3 years as a full-time developer * ERP, OneWorld, focusing on SuiteScript customizations, Suitelets for advanced reporting * I love mountain biking, rock-climbing, and NetSuite!

in Introduce Yourself! Comment by SuiteSean Sep 13, 2019 12:56PM

- I am guessing this question slipped by? @"Robert Nedelkow-Oracle" can you help get this question/issue routed to someone for consideration? Thanks!

in SuiteAnalytics Workbook > Dataset > Filters > Show Hierarchy Comment by SuiteSean Mar 3, 2020 3:19PM

@"4025018" When creating custom fields, ALWAYS be sure to set the ID field to something sensible.. The one referenced in the screenshots is custcol24 <--- This is not meaningful, so it makes Managing the template very difficult.. -- Instead, name it something like : "_tmpl_lotnumber" <--- This makes it much easier to…

in Serial and Lot Number on Packing Slip Comment by SuiteSean Feb 6, 2020 5:22PM

Thanks for the additional clarification Robert, it's greatly appreciated!

in Create Budget Search with Period or Period Amount as column or filter Comment by SuiteSean Jan 28, 2020 1:39PM

Hi @"Mikko De La Fuente-Oracle", How does an enhancement that is ~ 9 years old hold up as a 'Correct Answer'. I understand that NetSuite is not investing in the basic budget functionality, but it's not even usable without this 'enhancement'. @"Robert Nedelkow-Oracle" - What can we do to help? What is it going to take to…

in Create Budget Search with Period or Period Amount as column or filter Comment by SuiteSean Jan 24, 2020 2:33PM

Hi @"H Medina-Oracle" My primary issue here is that When I go to the OPT IN page, the message refers to 2019.2, and NOT 2020.1 From my original Post: I tried going to Setup > Company > Release Preview to request the 2020.1 account, but I received this message: 2019.2.0 Release Preview accounts are no longer available.

in 2020.1 Release Preview Not Available Comment by SuiteSean Jan 24, 2020 2:22PM

Having the same problem here... @"Mikko De La Fuente-Oracle" How is this an 'enhancement' is there any prescribed solution for managing these budgets at the period level? Not having the period columns means that if we change any of the budget values for periods in the NetSuite UI, any import will overwrite all values. This…

in Create Budget Search with Period or Period Amount as column or filter Comment by SuiteSean Dec 13, 2019 2:20PM

I see the formatting didn't come over very well... I have an excel sheet I can send you directly if you want to message me with your email...

in Transaction Type List/Record doesn't include Advanced Intercompany Journal Entry Comment by SuiteSean Dec 10, 2019 1:06PM

Hi @"H Medina-Oracle", Sorry for the delayed response, I was out of the office.. Response to Question 3: I am creating transactions on behalf of users, based on various rules they require. When I create a record, the TYPE which is required is the 'Record Type', so if a user selects CASH SALE, I can't use the Transaction…

in Transaction Type List/Record doesn't include Advanced Intercompany Journal Entry Comment by SuiteSean Dec 10, 2019 1:05PM

Excluding Elimination Subsidiaries does not exclude the transaction when searching at the line level because the Elim subsidiary is typically interacting with the other subsidiaries.

in What is the best way to exclude Elimination Journal Entries from Transaction Search Results? Comment by SuiteSean Dec 10, 2019 11:09AM

Hi Neo, There are no add-ons for Mass Updates, but it is very flexible. The Criteria of the Mass Update is where you specify (using a formula) field X <> field Y Then look at the 'Mass Update Fields' list to see what is available to be updated for the given record type. If you need the updated value to change dynamically,…

in Custom mass update - without programming Comment by SuiteSean Dec 4, 2019 11:55AM

Hi @"Yusuf - Reading", You can compare the amounts and types on the line in the criteria. I typically use a Formula(Numeric) with a case statement CASE WHEN {amountpaid} = {amount} AND {type} = 'Bill Credit' THEN 1 WHEN {amountpaid} < {amount} AND {type} = 'Bill Payment' THEN 1 ENDYou will want to set the criteria for this…

in Saved search formula help Comment by SuiteSean Dec 2, 2019 12:57PM

Hi @"Camille Cagalingan-Oracle", The TOTAL value nets to 0, which appears to be correct. However, I have a report with the prior period balance, and current period balance columns created per SA 73701 (Trial Balance with Opening balance, for the period amount and closing balance) The Opening Balance and Closing Balance…

in Trial Balance Report Total View Inaccurate Comment by SuiteSean Dec 2, 2019 12:40PM

You can add custom fields on the RMA for case and choose (Record is Parent) so it can be displayed on the case form. You can also add a custom field on the Case which links to the RMA. This could be automated via scripting, then it would be easy to see any RMA's missing Cases.

in Search Linking Returns to Cases Comment by SuiteSean Oct 9, 2019 3:48PM

Can you clarify how the cases are linked to the sales orders? How do you intend to link an RMA to a specific support case? Is it 1:1 sales order to case? If the Support Case record is in a field on the SO: Try adding a custom field on the RMA which sources in the Created From field from the Invoice (Created From). Then,…

in Search Linking Returns to Cases Comment by SuiteSean Oct 9, 2019 1:22PM

The last purchase price comes from the PO for the specified item. I don't know if there's a way to set it otherwise.

in Inventory Valuation in Netsuite - Purchase Price, Last Purchase Price, Balance Sheet & P&L COGs Comment by SuiteSean Oct 4, 2019 11:41AM

Can you update the COGS on the Inventory Receipt transactions? It is usually at the line level.

in Inventory Valuation in Netsuite - Purchase Price, Last Purchase Price, Balance Sheet & P&L COGs Comment by SuiteSean Oct 3, 2019 5:25PM

@"mvara", Can you post an image of the custom record (with a dummy contact populated) where you're wanting the field to be populated with the contact name?

in Display Contact name from a list without the Company Name prefix. Comment by SuiteSean Oct 1, 2019 1:46PM

It looks like you're creating this formula in WSIWYG mode, so the symbols are being html encoded. Try recreating the formula in the script view, by clicking on the DIV icon in the top left.. Are you trying to display the number if it's greater than 0? This formula worked for me (using an integer field) <#if…

in Email template - free marker formula Comment by SuiteSean Oct 1, 2019 12:41PM

I found the Q&A link on the training video page.. Someone asked the question about creating transactions and the answer was 'No, not in this release' @"Robert Nedelkow-Oracle" -- So if it's possible, we may want to ask them to change the language on that document to specify that Bank Transaction details are Imported for…

in Bank Statement Parsers SuiteApp Comment by SuiteSean Sep 26, 2019 4:15PM

I ran into this once.. You can use the word 'external' as a parameter, or NetSuite recommended that you search the deployment record to get the external url. You can also get crazy and create a 2.0 suitelet which uses the URL module, and that module does return the correct full URL, although it would take a performance…

in nlapiResolveURL returning the depreciated URL Comment by SuiteSean Sep 25, 2019 7:14PM

SuiteIdea 309817: Setup > Accounting > Manage Accounting Periods : List always shows as expanded for prior year. Closed periods should always default to collapsed in the list...

in SuiteIdea Upvoting Comment by SuiteSean Sep 13, 2019 2:04PM

There's a pretty good article in SuiteAnswers with some basic examples: SuiteAnswer 8439 Search Formula Examples and Tips

in 100 Ways to Use Formula Fields Comment by SuiteSean Sep 13, 2019 12:47PM

SuiteSean Red Ribbon

Comments