https://community.oracle.com/netsuite/english/discussion/comment/16883647#Comment_16883647 Hey Bry, hope you're well. Yea I have over a hundred item records with single and multiple values assigned.

After comparing successful items to unsucessful ones, I have managed to correctly upload a number of the affected items and will continue to make changes to the rest. The error stems from a custitem field not being filled in. If any of the items per category do not have a value in Netstock Stocking Indicator then the…

Mm, my thought would have been to put an image field but then again when you're in edit mode that only shows the name/link to the file and not the image. Tricky

Opportunity/Estimate Status

Having passed a list of the affected items, the colour IDs they should have and with a 2 week turnaround the defect has been resolved by the QA Engineers using a script. Honestly a lot sooner than I was expecting, so that's nice. But whilst I can edit the records it does seem that many of these matrix options are not…

I can't find any info regarding this or the error codes that I'm getting and the order needs to go out so I've assumed this is going to be a one off occurrence and have done the following. I have zero’d the affected line item on this SO as that item was not yet fulfilled and then create a new order to complete the…

var newDate= new Date(); newDate = newDate.setDate(newDate.getDate() + 7); var formattedDate = formatDate(newDate); function formatDate(date) { var day = date.getDate(); var month = date.getMonth() + 1; // Months are zero-based var year = date.getFullYear(); if (day < 10) { day = '0' + day; } if (month < 10) { month = '0'…

I ended up going through the 100 or so customers that had custom pricing on these items and manually checked for the errors. I managed to find 8 in total and believe they have all been fixed now. I couldn't find any correlation between the records affected or come up with any easier way to identify the broken items. At the…

It appears that "Windows has a MAX_PATH limit of approximately 256 characters" was indeed the issue here. I tried your suggestions in my original path and ended up with the same errors but moving my Dev Environment Folder to C:/ has allowed me to get past this issue. Thank you very much~

Thanks Bry, I had used NVM to change my Node.js to the correct version. I'll give your approach a go and let you know how I get on. I've been having a lot of trouble recently with IT security measures blocking me from installing a lot of dev stuff like Java Dev Kit, Python, even just unblocking certain websites, so I'm…

https://community.oracle.com/netsuite/english/discussion/comment/16882021#Comment_16882021 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…

https://community.oracle.com/netsuite/english/discussion/comment/16880965#Comment_16880965 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…

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…

https://community.oracle.com/netsuite/english/discussion/comment/16880840#Comment_16880840 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…

https://community.oracle.com/netsuite/english/discussion/comment/16880228#Comment_16880228 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~

https://community.oracle.com/netsuite/english/discussion/comment/16879682#Comment_16879682 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…

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.

https://community.oracle.com/netsuite/english/discussion/comment/16879318#Comment_16879318 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…

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.