There is no solution. If we want to use other payment methods we will need to go with a provider other than CyberSource until they otherwise fix the issue between them and NetSuite.

It does look like the main issue was customers registering to the webstore as a lead which set them a password, then customer service updating them to a B2B customer and sending them the template with the setpassword link. We just need to clean up our internal process of how to handle customers and convert them into the…

Thank you both for your insights. What I'm gathering from this, whilst dependant on the integration itself, is that it's a lot more than one persons worth of work. :')

I'll have to double check and get back to you. But those all sound like things that could have happened, so thank you for the direction Chelsea, now I know where to start looking.

Hi Michelle, it's a custom record. On a simpler, similar example that uses the Sales Order, I'm having the same issue accessing any of these fields. I'm guessing that's because the fields that the box inserters offer aren't actually correct/verified? Seems dumb to offer them if so. In the example of a Sales Order, can I…

Thanks Alex, I appreciate your insights on this.

Sorry, no, I'm actually trying to merge a Lead into a Customer. For some reason, the B2C lead that is created as an individual isn't allowing the merge, even if I convert it to a company. I'm currently comparing it with the B2B lead that gets created as a company and merges with its contacts into the Customer just fine.…

Alrighty, thanks Michelle. I'll work on making it more apparent on the website for contacts that are part of a larger company to use the signup form that creates them as a contact and not a lead so they can be added to the customer record.

I appreciate the suggestion Alex, that would indeed keep the columns equal since Ship To is always a visible field, but I want Ship to Select to come before (above) Ship To.

Thanks Bry, I'm aware of the overriding Out of Stock Message field on the item records. I was just hoping there might be an easier fix perhaps in the site customization. Based on your concerns about the theme not being linked properly, I think I will first see if the item record field works and update all of my item…

Ah, it's just Email. Thanks Alex

System is actually a user, I think it has an internal id of -2(?) if that's of any help. Otherwise perhaps it looks like you'll need to make an additional field of just a 'is user' checkbox and have the workflow update that if the user is -2.

Mm, thanks for all the advice. The provider isn't offering documentation on the bundle so I think I'll do a lot of testing in Sandbox to see what processes are affected by removing it, if swapping to the other public bundle does anything to resolve the issue, or disabling the deployment of the User Event Script on the…

Hi @Richard James Uri-Oracle, thanks very much for your feedback. I haven't had time yet, just back after a long weekend. I'll be sure to give an update when I can as this is an important issue to me. Thank you so much~

I don't think it's a Net Suite bundle, but it is shared publicly. On my list of bundles it says it's the Advanced Terms, ID 355002. Though when I search for it to install it says it's ID is 504839. It was installed by RSM, who own 504839 but instead they installed 355002. 355002, whilst it otherwise appears identical, is…

So these records don't have a Payment Method field because the payment method is implied by whichever form is used? I'm just worried about any customizations that might rely on the payment method field. I wasn't with this company during implementation, so I'll need to do some research first.

Oh, it appears Invoice isn't even set up as a payment method, perhaps I need to start here? But if Invoice isn't set up as a payment method, without even any payment visuals, how does it show up on my Web Store as an option?

Hi @Bry Cabria-Oracle , I've gone ahead and started working to set this up. It appears to be recognizing the method and creating the SOs with different forms, but now the Payment Method field doesn't seem to be available on either of these custom forms. D'you have any idea why this might be? Here on my usual form it…

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…

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…

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 than creating my own? Otherwise, I'm just going to run a Map/Reduce script each month with a…

Thank you! This does appear to be working. I'll just need tweak my script to format the date in this way.

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.

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 though. The only result I was to see is the name of each customer that spent less than…

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.