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.

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 ☺️

Nevermind. It seems the Mobile Screen isn't tied to which role I'm logged in as once I have it open. By opening the Mobile Screen, I can in another tab log back into my Admin account without getting logged out of the Mobile Screen. Also, as an admin I can still navigate to the Mobile Screen, it's just named completely…

Thank you @Bry Cabria-Oracle . I did want to make this promotion specific to certain customers like with using the Default Discount field on my original post. I have achieved this with your solution by simply adding the customer as one of the audience members of the promotion.

Ok, so bit of a stretch in my assumption here. So, sorry if it's wrong. Is the record.assemblydetail the section in red? If so, to get your {custitem_sw_parts_remarks_line5} to be read properly, those values also need to be listed here, are they? These columns of information are Column Fields, so based on that your field…

Just to double check, this is the bank import screen you're looking at, right? Your import that I downloaded has leading zeros and 4 digit years, I'm not sure what you mean. As with the quoted text I provided, your CSV columns need to be the following to hopefully fix it. If you don't have any data for those columns then…

'Blending' like physically blending paint or food together to make a new product? That to me sounds like you need a Work Order process. You take two components and produce a new one. Work Orders can also be scheduled or created automatically based on demand for the finished product and you should be able to create…

What's the failure reason? If you click the little + icon it'll give you more detail on what went wrong. You can find more information on how to prepare your CSV for upload here. Based on the info you provided, your CSV does look quite wrong. You don't need the account name or ID for example as you already selected that…

I don't think it's possible to look at the related records of a file, often only the Created From. Like if searching on a Quote/Estimate I can't join to the Sales Order and when searching on a Sales Order I can't join to the Item Fulfillment. Usually the most I can get out of it is the name of the transaction and none of…

Unfortunate 😅

Could you share your code for the upper section as well please? Sorry, it's a little hard to grasp exactly what you're working on due to the language barrier, but it looks like you have the same field that was repeated in the second section outputting correctly in the first section. Or am I wrong?

From SuiteAnswer 47808: To remove the lock in Custom Item Field, make sure to delete all the association of this field in the Web Site Setup page under Commerce > Websites > Website List then edit the website. In the Search Index tab, make sure that the custom item field is not used inside the Search Fields, Facet…

I believe if they want to be brutally accurate they would assume that the component has been consumed by the asset and adjust the value of the asset by subtracting the value of the depreciated component and adding the value of the new component. It's really up to them though, if the assets are theirs. Not sure why you're…

I needed to update my item fields as being usable on assembly item records.

You can delete them, does that help? You might otherwise need a script to update the Used value, but I don't have any experience or know if it's even possible to target a coupon code record with a script.

Is it because on your field id you specified line5? Would it not just be custitem_sw_parts_remarks?

Pretty sure a lot of the AI things are paid features. It's probably best to contact your account manager on this as they'll also be able to give you the pricing for it along with the answer.

No, I'm afraid not. According to this post last year it's still not possible to merge assets, sorry. There also doesn't appear to be anything in the help center about it. When I was working with FAM I did merge my assets but I created an entire CS and SS system to handle the creation, merging and splitting of assets as…

You can change the quantity built during the build. On the work order you can even just put 1 (you can't put 0 because this makes the work order think it's complete and then the quantity is locked). Would this help you or would you still prefer to build a Suitelet? If you don't need to plan your builds ahead of time or…

If you take the link to make a bill from your working account, copy the url and use that url on the account that isn't working, does it tell you what permissions you are missing? If any?

I think you read my comment before I got to correct it, haha. It should be usereventscript yes. A userevent script is one that happens before or after the submission of the record. A client script is something that is actively running as the user is interacting with the record.