Thanks, I'll review those to see if they are relevant

I've tested this and it doesn't show empty bins? I have a scripted solution that extracts a list of all bins for a location, and then for each bin runs an item search to find out what items are in that bin. This works reasonably well, but I also want to return information about the bin itself (we have different types of…

Thanks for the clarification and the link to the details about this.

My colleague has carried out further tests this morning - the behaviour is certainly strange/inconsistent: SOSG194573 / PO68991 / IR49645 Booked 10 of NSCE in bin GOODSIN04 (There were already 14 in bin AND-NS , 12 of which were available) Picking ticket only gave AND-NS bin. Tried again where there were NOT ENOUGH in the…

I've run some more tests this morning. I added a bin to the Item Bin Numbers list before booking it in, and this item/bin appeared on the picking ticket. I then deleted the receipt, and booked the item into a different bin (not on the Bin Numbers list), and again it appeared on the picking ticket. So it may be that my…

Joy Thanks for this. It is good to know what NetSuite is meant to do (i.e. display all bins with available items) - that is not ideal for our situation, but we will have to work with that. However, I am not seeing that. I have the items received into GOODSIN09: On the item record, there are 3 bin locations with stock in:…

Thanks - on our system that Inventory Detail field is always disabled on a Sales Order - this is using the 'Standard Sales Order' form: We don't complete this field until we create an Item Fulfilment and fulfil the order. This is why I was confused that this field was being used on the Picking Ticket? Is there a setting…

Thankyou Pauline - that is really helpful. I have used this to implement a formula that produces the text I need.

The thing is we don't want to select the 'right Service Tier', we want to continue to use the service we procured under the agreed contract at the agreed rate. Our usage and number of transaction lines has not changed from our contract start in 2019. Our contract limits the price increases that can be applied to our…

Thanks Robert - we have already spoken with our Account Manager, and we have an escalation call with our Regional Sales Manager next week. I have been reading NetSuite Help and found this which is very concerning: NetSuite are saying we need to increase Tier due to the level of our usage, and not increasing could result in…

Thanks John - i am glad that you did at least see some performance improvement from this (significant) increase in cost. I am struggling to get any detailed technical information on what we 'get' for the money paid. I can see the free sandbox, increased API connectivity and CSV import threads, but what about benefits that…

I've been looking into the scripts in more detail. (I've re-enabled it this afternoon as the fix was applied to our account this morning - just in case the script is doing something useful). The Script is part of Bundle 123426 Supplementary Tax Calculation - the description and documentation talk about non-deductable tax.…

For anyone coming across this in future: Enhancement # - 479023 Summary: SuiteFlow > Set Field Value Action > Expose "Tax Code" field Alternate Solution: use Scripting to set the value of Tax Code (line). You cannot access the Tax Code field via Workflow. I would have thought that Tax Code is a required field for most…

I think I have found a workaround - the Customer : Credit Limit field appears to work on a Prospect record, and as a Prospect has no transactions they can't have any balance / unbilled orders - so this should be fine. I have created another transition locked to the Prospect Status' that compares the Order Total to the…

Also, is it possible to insert a line break/carriage return type character?

I created a new basic Sales Order approval workflow from the NetSuite template, and this allowed me to send an email as part of the 'approved' stage of the workflow, with an attachment, without any errors. On comparison between the standard workflow, and our workflow (which incidentally was created by NetSuite Professional…

I've spent (lost!) another 4 hours today fighting with this to try and get it working. I'm no closer to a solution, but I know understand why this works fine for my PO approvals, but not SO approvals. Due to the volume of Sales Orders, we 'auto-approve' certain criteria, so the workflow transitions straight from initiation…

I have managed to generate the search I need with a hugely complex set of field groupings, but I'm still worried my data might be an issue. I've imported some Bin Number records to help get the data I need onto the Search, but I still have an issue that if an item has never been in stock then it won't show (because it…

I currently have access to a release Preview account so I've been testing workflows in there. Using my original process of sending the email as part of the Approval workflow it still errors with 'Record has changed' even with all other Workflows attached to the Sales order record disabled. So I can only assume it is…

Pauline I'm still struggling to get this to trigger in my environment. The Saved Search is working fine - I have the newly created sales order showing in the search results. The workflow is configured as follows: I can see that the workflow is triggered on the Sales Order Transaction each time I view the transaction: But…

Thank you for this Pauline. I tried using a separate workflow to send the email, but was trying to trigger it from the Record Change, not from a Saved Search. I will certainly try this and see if I can get this working. I have only previously used saved searches with workflows that are scheduled. Please can you clarify how…

Thanks Pauline I have tried putting the send email as the last transaction on the state, and as a new state after the last state - this does not improve the issue. I have checked the template set on the form - this is the same as being used in the workflow. I did try a separate workflow, but I wasn't sure how to get this…

Thanks Erick - yes I found that error and resolved it. I'm just a unsure why we have 12 working client scripts, but now know that it fails if I try to deploy 13?

OK, I moved my script to the top of the list, and it worked. I have been able to retire one of my previous scripts in introducing this new one, so I have been able to get this script working (even when it is moved back to the bottom of the list). I appreciate all your help with the scripting above - if there is any further…

I've found this help article: NetSuite Help Center That states: A maximum of 10 localized and 10 non-localized client scripts are supported. I have 13 scripts (and the 13th is not working): I have nothing shown in the 'Localized Client Scripts' list, so I assume all of mine are 'non-localized'? So in theory, only the first…

Thanks Erick My script now looks like this: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(['N/currentRecord'], function (currentRecord) { // /** // * @param {ClientScriptContext.validateLine} context // */ function validateLine(context) { var thisRecord = context.currentRecord; var itemPORate =…

No, it's just incredibly slow (15-30 seconds) to access, and often times out. (And it logs me out of the main NetSuite interface which is frustrating. To be honest, this forum used to be just as frustrating to access before the recent overhaul and re-launch. Perhaps we can hope that Suite Ideas will get a similar refresh…

Thanks - I'll upvote that (assuming I can get access to Suite Ideas - it seems quite intermittent as to when I can and can't connect to it). I don't suppose the preferences are exposed to SuiteQL for searching that way?

I think I've resolved Subtotal: var subtotal = nlapiGetField('subtotal'); subtotal.setDisplayType('hidden'); However I have one really strange one - the sublist/subtab(?) heading for Items includes the total value: Based on the Field Explorer plugin I think this is called 'item_total' but I can't hide that in script using…

Thanks - I'm using this workflow action script (adapted from SuiteAnswers) to hide some line level fields: function workflowAction() { var amount = nlapiGetLineItemField('item', 'amount', '1'); amount.setDisplayType('hidden'); var rate = nlapiGetLineItemField('item', 'rate', '1'); rate.setDisplayType('hidden'); var…