PaulFleetwood Silver Medal

Thanks Shamaine - unfortunately that Enhancement would actually prevent us using the 'change customer' process to update pricing, leaving us with no way to update pricing on an older quote. In the current economic climate, we are having to increase pricing very regularly - and having to re-type quotes to get up to date…

Thanks Michelle, I don't think 103639 really applies to my situation / issues. I think in the short term I will have to remove user access to the Employee Directory portlet until I can find a way to either hide the email address, or send campaigns to alternative email address fields....

Thanks, that field defaults to the Item Defined Cost for the item, but this field is not available on the discount items (which is why I was looking to default the field using workflow / script). I will have to look at other ways of using the discount functionality...

Thank you for confirming I assume that 'Before Record Submit' relates to the entire record being submitted? This will not help with a Line Level field that is mandatory that I need to use a Workflow or Script to complete the field before the line is committed.

That script loops through all Items, and stores the Bin Number and Quantity in an array It then loops through a subset of my Bins, and for each one searches the array to check if there are any Items in that Bin This then outputs a list of empty bins. You could adapt this to other permutations if required.....

/** * @NApiVersion 2.x * @NScriptType Suitelet * @NModuleScope SameAccount */ define(['N/record', 'N/search', 'N/log' ], function(record, search, log) { var binArray = [ ]; var qtyArray = [ ]; // Created 17/3/21 PF // Create list of Empty High Bay Bins at Andover by running 2 searches function onRequest_entry(context) { //…

Does this limitation also apply in Demand Planning (and/or the new Supply Planning Workbench)? Or can you differentiate between different locations with these new tools?

Thanks, seems I have already stumbled across this issue before (as I have already voted on this one!)

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…