Hi Jack Yes, I have certainly utilised elements of your guidance in order to make the most of the filing cabinet. I am looking into the scripting element of things but that will probably involve a follow up post at a later date. Thank you once again for pointing me in the right direction. Have a great day. stay safe. Oliver

Thanks Ivan Unless I am mistaken the Vendor price list import only contains limited fields that can be imported, name, vendor name, price, schedule, currency. Our vendor pricelists are always packed with lots of pieces of information, product specific dimensional data, suggested margins etc so I wondered if there was a way…

Hi Jack I apologise for the delay in getting back to you. I have been on annual leave this week and moving house so it has been a very busy and stressful time. Thank you so much for your in depth, it makes perfect sense and I look forward to utilising this new knowledge this week in a real life setting. Thank you so much…

Hi Jack Thank you for your help. This has completely revolutionised how I am putting this together. I had all my formulas in custom fields, and was then duplicating everything onto stored value fields to get the info, the above has made me realised that I am much better off keeping all the fields as store value and setting…

Hi @Jack Daryl Espiel-Oracle Sorry to trouble you, this is in relation to another query you are helping me with in regards to linking multiple fields via multiple workflow actions. Can you go into a little more detail here, do I literally just break the 1 big formula into smaller pieces? What is the exact syntax, do I need…

Hi Joahnna Thank you for the suite answers. I tried both but they were unsuccessful, however they did give me the inspiration for an idea that did work. I created a custom numerical field on Quotes which looks up the specific Tax Code for the Customer and inputs a number based on this tax code which has resolved the…

Hi Jack Thank you for letting me know. I will vote for that enhancement. Have a good day. Oliver

Hi Joahnna Sorry for not getting back to you sooner. Thank you for the code. It was useful in displaying the tax data for the line items. But my issue is that the total tax rate for the transaction is blank - it should be 20% the same as the line items, this happens on Quotes and also Purchase Orders. Is there anything…

Hi Jack Sorry for the delay. I logged in under incognito mode and you were correct, I was able to see the new field in Criteria, Results and Available filters. So it is a caching issues. Thank you for that. I will proceed on this basis. Have a great day. Oliver

Hi Joahanna Thank you for you reply. Yes, it the actual percentage number that is not showing up. These are all standard fields. I have checked some other records. On invoices the percentage number is shown, but on purchase orders it is not, it only shows the symbol not the number:

Thank you Mikko. works perfectly with the N/file module loaded. Thank you for your time. kind regards Oliver

Okay the good news is that this updated version validates and deploys, but now fails with the below error: ReferenceError: file is not defined [at Object.execute (/SuiteScripts/purchasing.js:11:9)] The csv file is definitely in that location and is defined in the script. The latest code is below: /** * @NApiVersion 2.1 *…

Just as an update I made some changes to the script so it now looks like this: But I now get the error: SuiteScript 2.0 entry point scripts must implement one script type function /** * @NApiVersion 2.0 * @NScriptType ScheduledScript */ require(['N/task'], function (task) { function execute(scriptContext){ var scriptTask =…

Hi Niks This answer is perfect, I changed it to Name(internal) and now it shows the single line. I have learned something new today. Thank you for your help, it is greatly appreciated. Have an amazing day. kind regards Oliver

Hi Niks Sorry for the delay, it is so busy here at the moment. Yes, I am still trying to get to the bottom of this issue. Criteria and Results tabs below, though they are quite basic. Criteria Results Thanks again for looking into this kind regards Oliver

Hi Niks Thank you for getting in touch. I am not trying to pull any data through, just create a random number on the same line as the SKU. Thank you for your help Kind Regards Oliver

Hi Kristoffer Thank you for letting me know. I have voted for the enhancement. Fingers crossed it appears at some stage. If you figure out a workaround in the meantime let me know. I will continue to experiment. Thank you for your time. have a great weekend. Oliver

Thanks Michelle, I had a nice relaxing day by the sea so it was great. Have a good day. :-)

Hi Michelle Sorry for the delay in getting back to you, I have been on annual leave. Thank you very much for your clear solution. It worked perfectly. Thank you. kind regards Oliver

Hi Joahnna Apologies, I have been on annual leave. I do still need help with this. I will come back to you shortly with details. Thank you for your patience. Kind regards Oliver

Hi Kristoffer This is amazing news. The solution worked perfectly. Thank you very much. A note to anyone with the same problem who reads this thread: The only part of the script you need to change is value: 'Enter Internal ID of required value' Within the apostrophes you need to enter the number that refers to the internal…

Hi Leonard Thank you very much for letting me know. That is a shame but hopefully the enhancement will appear in the future. Thank you for your guidance. Have a great day. kind regards Oliver

Hi Ivy :-) Sorry for my slow response, so much happening at the moment! Yes, as ever your answer was flawless, this worked great. The project continues. Thank you so much for your help. Have an amazing week Kind regards Oliver

Hello Elychelle Thank you very much for taking the time to perform this analysis. It is a shame that this is not possible in Netsuite yet, but hopefully the enhancement you mentioned will come to fruition soon. I will take a look at the enhancements page. In the interim I have done as you suggested and created this as 2…

Hello Elychelle Sorry for the delay in replying. The email notification never arrived. Thank you very much for your answer. Yes, you are correct, this was the problem. So I have done as you said an created a customer search, now the date of the last note is showing. but this has caused another problem. The search is…

Hi Jack Thank you for your patience. There is so much going on here at the moment. I can confirm this solution works perfectly. Thank you very much. And thank you for the guidance on the account number. Have a great weekend. Oliver.

Hi Ivy Thank you so much for all your time and efforts on this one. I am incredibly grateful and immensely impressed by your knowledge. I can confirm that your solution works and that this project is now up and running. Thank you kind regards Oliver

Hi Jack Of course, sorry for the misunderstanding, the formula is below: '<a href=https://<accountID>.app.netsuite.com/app/crm/common/note.nl?l=T&refresh=usernotes&perm=TRAN_ESTIMATE&transaction=' || {internalid} || '&_ts=' || {activity.time} || ' target="_blank">Link</a>' Thank you Oliver EDIT: Removed account ID and…

Hi Ivy Yes of course. For example let us say the first sales person is Bob Smith. His Target is 30 accounts, he has achieved 15 accounts, I would therefore on that line only want to see Bob's figure which would be 30%. KR Oliver

Hi Ivy I hope you had a nice weekend. sorry for my slow response, I was on annual leave yesterday. Thank you very much for the formula, this is very impressive. I think we are nearly there with this one, just 2 slight issues, the column is showing a column for each sales rep in every cell rather than just 1 for 1, also,…