Thanks Bry, We do use the advanced signup as well but this simple one is for guest shoppers. I'll be sure to vote on the defect and enhancement. At least for now they seem to have given up and there's not much damage they can do.

Hi Richard, Thanks for the steer but unfortunately the search is returning 0 results.

In my rush, I forgot to set the context of the action to Web, which is why it wasn't triggering. However, this doesn't solve the issue as it does block leads, unlike contacts, from being able to login to the webstore. I don't really have an idea on how to prevent something like this from happening in future. It depends…

Hi there, I don't think you need a formula. Could you try grouping by action and sorting the date by maximum? In my head, I think this sounds like what you're asking for.

Hi there, This is a transaction search, yea? What record are you searching on as your primary or what are you Grouping by? The Sales Order, Invoice or Credit Memo?

Still seeking help with this please. My page has two of the same table and I still can't figure out how to find and/or delete the clone. >_<

The ones you screenshot are mainline fields, so isn't it just itemReceipt.setValue({ fieldId: 'landedcostmethod', value: 2 }); ? There is also landed cost fields on the item lines, those will be itemReceipt.getSublistValue({ sublistId: 'item', fieldId: 'landedcost', ←This is a guess line: i });

Yes, these are all accessible. If you click on the field name, do you get a popup with the field ID? You can turn this on in Home > Set Preferences and checking the Show Internal IDs box. On the Item Receipt, you can also add '&xml=t' to the end of your url to inspect the xml of the the item receipt that will show you the…

You can't returns results that don't exist. If you haven't purchased the item then there is no result to be returned. If you want to show all items, including ones that haven't been purchased then you need to also download a list of all your items that can be bought from the vendors and filter the results of both searches…

Sorry, I meant the actual results of the search when you run it, not the subtab config. But from what you've shared, if the Sales Team Member isn't one of your results, how is it emailing even that one Sales Team Member? From my understanding, you need to include the field that contains the value of the person you want to…

Can you share the results of the search as well please. The Reps need to be returned as values by the search in order to target them for emailing. Also check the email that went to Rep2, are they the only one on the To: list of addresses? If there are more addresses but those people didn't receive it, their inbox is likely…

Do you have a particular format/file type in mind you want to extract the data as?

Ok, the key word that really aught to be highlighted in the instructions is that this is for CUSTOM mobile processes. By cloning one of the standard processes to make it custom and allow configuration, I can now navigate the menu's as expected based off of the instructions and edit the actions.

Found it:

If you are receiving serialized items you can't scan in a box of 100, you need to scan in all 100 serial numbers. Otherwise, I'm fairly sure your only option is to create the item receipts via CSV so that you can upload all 100 serial numbers.

I'm still hoping to get help on this topic please, if anyone is able to offer any insights.

It's saying that when you try to click on the bin? That is odd, I wouldn't know from my end, sorry! I'd need to be on your environment to poke around to get a better understanding. Hopefully someone else here will have better direction for you~

Sorry, I don't know how possible this is. From my own attempts I wasn't able to get either the createdfrom quantity or created from amount or rate to display properly. Unless someone else has a solution, I think it would be better if you add new custom QTY and Amount columns to your IF that source and display the data from…

You'd have to be more specific, but no issue on my end, mine are working fine. Would be best if you ring support if it's an urgent case.

D, though that would be interesting. SuiteIdea? :D

Is mainline false? I assume so because you're using quantity which isn't a mainline field. If so, please try this CASE WHEN NVL({createdfromline.quantity},0) != 0 THEN {createdfromline.amount} / {createdfromline.quantity} ELSE 0 END If mainline is true then you probably don't want to be trying to use quantity, just amount…

Sorry, it appears my search was maybe correct all along and that the column I was looking at on my Sales Order template for Web orders is not in fact custcol_estgrossprofit but actually estgrossprofit. custcol_estgrossprofit is indeed not generating values correctly, likely due to whatever automation that is supposed to…

I appreciate your very detailed suggestion Red but unfortunately that hasn't resolved the issue. I did also try to bypass the need to check item type entirely by modifying your formula, returning the gross profit for any web orders without additional checks. CASE WHEN {csegcustseg3} = 'WEB' THEN {custcol_estgrossprofit}…

Oh right, I forgot to tell the map that I was using Internal ID and not Name for the Contact value. Thanks for the steer @Chelsea Jacobs

I've only tested it on my own site visually and the performance still seems to be ok. Certainly ok enough in order to have PCVs working, as there is no other way around it that I could find. https://community.oracle.com/netsuite/english/discussion/comment/16898933#Comment_16898933

Those are all very good suggestions Bry, thank you for the advice. I was also considering PCVs but that seems like so much more of a hassle to have to map all my items to display for all customers in order to just to hide this one item.

I just wanted to add, one thing often not mentioned in the guides is that you need to turn off CDN Cache for PCVs to work correctly. You can do this in Commerce > Hosting > Domains

Checking the 'Display Item In Webstore' checkbox has solved the issue. Which is REALLY dumb because now customers can just go and purchase free footballs. 🤦

Sorry, I think I was already as clear as I can be for the way this is set up on my account. There isn't anything more for me to add to my question. I'm also not sure it's worth mentioning how I navigated to that page of the WMS mobile app, as I want to know how I can identify any page on the app, not that one in…

B ☺️