Thanks Bry, yea I figured this would a pretty niche case. I'll come back once I can get some more info or a solution out of our Cybersource provider or our SuiteCommerce implementation team.

You're fine, thank you Red. I'll be able to get the workaround going just fine, just a little more effort is all.

Hi Red. Did that code work for you in your testing? I've tried it and a number of variations but no luck I'm afraid. item.itemimages, item.itemimages_detail, record.item.itemimages, record.item.itemimages_detail… I can confirm that all the images are stored within Web Site Hosting Files which is always made publicly…

I have moved passed this issue. I did not find a solution to my problem.

The Tax After Discount is coming either from the invoice the credit is created from or the related sales order and not the credit. How can I fix this? My filters specify to only look at credit memos, I don't understand how the Tax After Discount is sourced. Is this the only tax field I can get? Nothing else seems…

Thanks Bry, great stuff. I can see my templates in editing the website setup and that is exactly what I was looking for.

Yes, that'll have to do for now. I'll set the opacity on the image before uploading it to the file cabinet. Thanks for clarifying that Nicholas

I'll try support then (case 6193896) and report back what they find. I can't see any difference between the multi and list fields that I set up as Facet Fields. Thanks for helping me check Bry

Hi Judith, it's Transactions - All Posting Transactions

Have you tried testing it with a multi-select list? Because that appears to be what's causing the issue. I fist set up the test filter as a list and was able to retrieve results. But converting it to a multi-select or making a new one from scratch doesn't return anything.

Hey Red! Sure thing~ It's not inside a for loop/ I've attached the xml as txt, the line in questions is from 390 I had tried this without the if condition at first, I added in the if to check if item.itemimages was returning any content to begin with at all.

Correlated Items. I have a picture of that above of it and the fields included, but the fieldset doesn't appear to change the available filters I can select from in any way, nor what values are available to them if that's what you're expecting.

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…

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.