Dext3r Bronze Trophy

Alrighty, I'll give it a go. Though the documentation is very broken then, it even asks me to add permissions or roles to the users that also don't exist, I'm assuming without the SuiteApp.

For now I have added a popup to a client script. If the shippingcost field changes and the status of the order is partially fulfilled or pending billing then it raises a warning, instructing the user they instead need to amend the first item fulfillment and then sets the shippingcost back to how it was.

Looks like you are using Redwood Experience (In your personal settings) for one instance but not the other, is that right? Perhaps worth checking that to start with and making sure you are using the same on both accounts. After that, whilst you mentioned your grouping and same column as previous settings should be the same…

I don't think these are correct, but these are some very quick checks at least. Go into their personal settings and check if they are using the same language as other users. or perhaps Press F12 to bring up the dev tools on their browser, right click the refresh button and click 'empty cache and hard refresh' Odd that it's…

Thanks for the suggestion Niks but I've not really got the availability to learn to use SuiteAnalytics right now. I think I will just allow the full set of results to come through on this occasion.

Thanks Alex, I still need it to be visible for the other roles. So I'll likely end up using a workflow or script instead then so that I can change the display type of the field based on who is looking at the form. Appreciate your insight on that.

For me, the permission they were missing was Lists > Custom Record Entries

Ahhh, that's frustrating. The CSV upload is working. I'll build a query so that I can gather the information when I need to report on it. Thanks for your support.

Thanks Jervin, itemSiteCategory was working but didn't return anything because I don't have any, we're not using them. I was looking for Commerce Categories which I have now found to be CommerceCategoryItemAssociation though it is not listed as being a join from the item record in the Records Catalog, I had to find it…

Thanks Bry, I've not had a chance to test this yet as I'm trying to first download the existing related item data with a saved search. Do you also know what I would to do saved search the item records for this information? As stated previously, I can't seem to find a field for either Related Item nor Presentation Item when…

I had to wrap both in a TO_CHAR, as there still seems to be an issue with trying to return 1 value or the other when they're not the same type. But your advice worked, thank you. CASE WHEN t.custbody_bb1_mss_shipmentref IS NOT NULL THEN TO_CHAR(REGEXP_SUBSTR(t.custbody_bb1_mss_trackinglink,'href="([^"]+)"',1,1,NULL,1))…

Perfect, thank you. By using accountinglinetype and kitmemberof I am able to filter down to just the results I need.

Seems useful, not having any issues so far querying multiple transaction types for the data I need.

Yea, this is possible using the usual dependent list customization but I can replace the first custom list with an existing list, in this case the customer. NetSuite Training: Short & 'Suite: Dependent Lists

Oh, it's not because the promotion was turned off, it's because someone changed the item record of the promotional item to not display in website. Understandable, because we don't want the item to be visible on the webstore anymore, but it still breaks any carts that have the item in it until we turn it back on and have…

It's crude, but I have ended up just adding another layer of customization to source and fill the weight correctly after the record is saved. Unfortunately I have too much work to keep on top of to waste chasing this unknown defect.

It's behaving correctly in sandbox -_-;;; So I have no way to start stripping out customizations to work out what's going on. I'll have to do a sandbox refresh and setup the domain for SCA to test this urhghghhh.

Mmm.. support said it's not a defect and they won't help me. Guess I need to go back and start stripping all my customizations out until I can find out what's doing this or prove that it's not caused by a customization.

Yea, I've given it to support for now in the hopes they can identify what on my environment is rounding the weight. I would presume the only options to check would be a script or workflow, but I'm not having any luck in identifying which, if any.

No luck with that I'm afraid Bry. I was logging the typeof weight before and it was already a Number, but specifying Number in the submit has also not made a change and the value is still being rounded down.

Yea, it would be good just to clarify your structure. My assumption is, you're building a Rental Ticket saved search. On the Rental Ticket are two fields you are trying to utilize in your formula Item Name/Number which is a custom list field that references the item list Asset Type which is a custom list field that…

Best thing you can do is try to use the formula builder to look for the join manually. I would guess that what you're looking for, if it's a field from an item record and you have items as a list field on your custom record, the field should be in the builder under Item Fields… Asset Type

If the report is too large, can you not filter it down per month and then concatenate your results of each month into excel for the full report that you need?

Hiya, I believe this should work, though I wasn't sure in my instance what fields I could use to test the minuets on. I see you're converting the dates into MM/DD/YYYY HH24:MI:SS, so you may just need a little tweaking to it, but the math of my process and how I end up with a concatenated string of hours and minuets should…

I personally would build a Client script for sure, in a lineInit or validateLine function. Or a User Event script beforeSubmit. With lineInit, this would be when you start to add a new line, you could either have it fill in a default value or get that value from somewhere else on the form like a main line expected receipt…

I think you were right to log a support ticket, it sounds like something they're making changes on the backend. Especially with the behaviour changing despite you not making any changes. I remember once they made changes that completely broke Customer Segments on our SuiteCommerce Webstore until they reverted the change…

C 😁

Ahh, how frustrating. Sorry Elina! There does seem to be some kind of piece to this puzzle that we're missing.

If it's a custom checkbox, this should be all you need; Set the access permissions per role you want it to effect. Here I add the Lapwing - A/P Analyst role and make it so they only have View access to my For Courier checkbox. For your case, if it's just 1 role you want to give edit permission then perhaps set the default…

I believe this is defined by the criteria. If you set a criterion with a specific selection and you are allowed to also add that field as a filter (some fields don't allow you to place them both as a criterion and as a filter) then the search should load with the filters set to those of the criteria. I quite frequently do…