Dext3r Bronze Trophy

I'm leaning on the idea that I've had this wrong from the start and the quantity has never been an integer. Fixed the pricing otherwise, remember to have your backups!

Thank you Patrick! My user want to webquery the report, I don't have any experience with this but according to him it can't be done on a Saved Search. Unless that's wrong, I'm afraid a Saved Search isn't a suitable replacement. But we'll make do without.

Hi all, thank you for the insights, it did lead me to reviewing everything again and finding the solution. I unfortunately gave you a red herring, I did find the defaulting being overwritten in a script written by the same people who said there shouldn't be any automation overwriting this field! 🤣 Hence why I thought my…

https://community.oracle.com/netsuite/english/discussion/comment/16888979#Comment_16888979 Thank you. I did reach out to them and they said I would need to pay the $1,499 a year to keep the library hosted locally. I've chosen to work on recreating the script myself using a Suitelet and the serverWidgets module.

Oh, I think the library is free? I have absolutely no idea what file I'm looking for in here though.

Thank you very much for that incredibly detailed response Jam. I think the Single Matrix with Custom Logic approach will suit my use case the best. We'll have multiple sizes of heat transfer clothes but won't want the various logos and company customizations to be available to other customers or have the option to appear…

https://community.oracle.com/netsuite/english/discussion/comment/16886855#Comment_16886855 Thanks for that detailed approach. I think what I'm leaning towards doing instead however is to create a field on the customer record that'll be a custom Spend Group field. Unless there's some reason to be using the native Grouping…

https://community.oracle.com/netsuite/english/discussion/comment/16886479#Comment_16886479 Thank you! This does appear to be working. I'll just need tweak my script to format the date in this way.

https://community.oracle.com/netsuite/english/discussion/comment/16886126#Comment_16886126 Yea, NetSuite support said the same thing. Rather infuriating that Cybersource has it all written up in the documentation on how to set up the other payment methods for NetSuite if it doesn't even work.

https://community.oracle.com/netsuite/english/discussion/comment/16885852#Comment_16885852 Thank you for the suggestion but I'm not sure how to implement it, sorry. It's either not showing results when used as a result or throwing an error if used as a criteria (unrecognized field). I'm not interested in seeing the results…

Ah, that wasn't at all what I meant. But I'm glad it helped lead you to a solution, haha. 😁

Could I just check, did you fill the vendor name for the item into the Code column of the vendor record on the item? As in your first screenshot of the original post it is empty, and I believe that's where it's expecting to get the Vendor Name from.

Thank you as always for your valuable input @Bry Cabria-Oracle

I was able to identify the differences and everything appears to be working correctly again after making the necessary changes.

The above answer shows correctly where to edit the timing and parameters of the Billing Operation. This creates the Invoices and emails them out. At the moment, I don't know if the following SA is entirely correct. https://suiteanswers.custhelp.com/app/answers/detail/a_id/75111/loc/en_US What mine does is use the To Be…

This points me in the right direction, thank you. But I need to do some testing to confirm it it seems.

I dunno if this is custom, native or from a bundle, but I found the list is under Setup > Company > Product Segments

Thanks Shiela, that does appear to be the correct location for changing the timings. Is there some way to define which email these goes to? Or will it always take the default email (id: email) address?

What is interesting is that it seems to be able to get these images on System Email Templates without even referencing the image? As far as I can tell

Sorry Patrick, I really appreciate the effort you've put into your response but I have lots to work on and we're happy with the data we're getting from this report without the tax. I'll come back if I run into a similar issue but at the moment I don't have the time to be changing the report or testing things that are no…

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.