@"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?

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!

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!

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

@"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…

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

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…

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.

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…

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...

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…

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.

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,…

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…

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…

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.

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,…

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.

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

@"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?

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…

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…

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…

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...

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