Sure thing, it's case #6145656 and defect #806890

So I can name the files with " / \ < >, I would just need to edit the file name once it's inside of NetSuite, either manually or via a script you say? Hmm… Thank you very much for that detailed response, I also didn't know about the Filename Format for the website customization as this was done by the implementation team.…

Can't say for certain, sorry. My guess would be that it changes the values and currencies that are displayed, also the formatting as some countries will write 1,000.55 and others 1.000,55. Documentation here: NetSuite Applications Suite - Accounting Contexts Translation is probably for custom fields on the record that have…

Thanks to the extension I have installed: Saved Search Export to SuiteScript 2.X it turns out it's just 'modified' Does this mean the schema browser is wrong? Or am I misunderstanding it?

What is it that's showing in Japanese, just the Subaccount Of? NetSuite can't natively translate anything that isn't built into NetSuite unless you give it a translation. Like whenever you make a custom field, you have to give it a translation for each language you use. I would assume that if the account name is in…

Superb work, thank you! This helped me create a report to show the average cost of items per month by using the formula: CASE WHEN TO_CHAR({trandate},'MM') = '09' THEN NVL({rate}, NULL ) ELSE NULL END

Ah, you're right! Thank you so much for pointing that out~ I ended up recreated the saved search myself which is working as intended. It appears this search left by my predecessor is in fact used to show only the Quotes/Estimates that then did not result in the sale of the items they quoted. The summary in the criteria…

Is it just the pricing you're updating? I found using 1 file works just fine. Customer 1 - Item 1 - Price - Currency Customer 1 - Item 2 - Price - Currency Customer 1 - Item 3 - Price - Currency Customer 2 - Item 2 - Price - Currency Customer 3 - Item 1 - Price - Currency That should be all you need for your csv.

No worries Red! I appreciate your thorough look into my issue. Where you mention 'there is an issue with the implementation that’s preventing it from functioning as expected' that's the implementation of the >/< logic in workflows? Specifically against the phone number field? Or something additional/other? As for your…

Sure thing. I've updated the original post with that image and additional findings on the problem.

Thanks for the steer @Clarisa De Torres-Oracle . In this instance it turns out the customer was simply created with the wrong country in their address, so it was trying to tax them based on their country. Not something we usually deal with since all of our customers are actually in the UK. Changing the customers country in…

Unfortunately, even without the formatting causing issues it still seems to not be working. I can't seem to get around this no matter what number I enter (88888888888, 012345678910, 1, 999999999999…). Is there something wrong with my logic? It should be simple enough, if the value is greater than 99,999,999,999 (the…

Thank you for the clarification, that does help me understand the possibilities. Hopefully, by turning off the formatting I can get my solution to work, I'll report back. Thank you~

Thanks Chris, yea I think I came to the solution and forgot to update my post here. The template does indeed take priority from the print template list field on the form the user is using. By customizing the form you're trying to print from and making sure to select the correct template should indeed solve the issue.

Oh, the scripts are not theirs, they were just implemented by them. The scripts are from bundles and I've found the documentation.

What/where is the resource center? Or is that referring to this community?

Is it not possible to use the names of the items? I'm getting the error "Invalid item reference key 51GR09 (C) for subsidiary 3." when using the name, but internal IDs do indeed work fine. —— Edit Oh, it's probably a rubbish error message and can't actually find the item because it's a matrix item. I probably need to use…

Thank you Red. I'm quite busy at the moment and as I have a workaround for this at the moment it's low on my priority list to test your answer. But I'll be sure to test it once I have the opportunity.

Not the open transactions, I'm going to replace only available inventory using IAs so hopefully I'll avoid needing to interact with any open transactions. What I mean with this post, is if I were building a new Sales Order or Purchase Order and am searching for items to add, I want the search to return the new item if I by…

I am at least able to get around the error for now by ignoring the {remaining} logic with an if statement if there's no value inside of quantitypickpackship.

Working example

The Quantity Pricing Level on the Price Update is meant to be the internal ID/number of the pricing level column, not the typed quantity. So if you have three pricing quantities at quantities of 0, 10 and 60, you would map those on your price update to 0, 1 and 2. Further SuiteAnswers reading: Creating Price Detail Updates

Support have gotten back to me, I will update this thread once I have time to test their solution.

Thank you for the incredibly detailed response Jack. Nearly 2 years later and your answers are still helping me.

All of the other answers may lead others to a solution, but for mine it appears the part I was missing was that the Source List and Source From needed to be selected on the Item Option record under the Sourcing & Filtering subtab.

Internal ID appears to work. However, I'm not sure this is the intended solution as it means I am having to run an additional search to first grab the internal ID. It's certainly not very good for the universal credits. Ran a search first as shown below, used the internal id in place of the name when creating the IA.…

It turns out there is a limit of 10 Client Side scripts that are allowed to run at a time on a single record type. Currently there are 18, time to get the trimmers. 10 of these scripts however are locked, I would otherwise combine them but since I can't even look at the code I'm not sure what to do about this. I suppose I…

No, it is not checked Yes the correct colour list is selected. I know I'm seeing the correct list as it contains all of the colour options on that list, but not just colours specific to the item which is what I'm trying to achieve. All very useful information to learn, thank you. There's are some custom templates for the…

Blank, not initiating at all. All I'm doing is swapping the deployment between SO to PO or IR or IF and it's only the SO that it won't trigger on. I have un-deployed 5 scripts that were deployed to SOs and unfortunately has not made a change.

Hey Bry, sure thing~ 1. Here's the search for the 1 matrix item I have on the webstore currently. There is only the 1 matrix item and its 7 children each with 1 color option. These color options come from the matrix list for all of our other products with color options, but as shown above I've limited this on the item…