Hi @Jack Daryl Espiel-Oracle I followed all your steps and I add the new field on the saved search on the custom record. Guess what happend, all the lines are multiplied with 6... The same thing happens when i add an other 'Text Area' custom field from the Item fulfillment. In the Saved Search there are no extra rows with…

Hi @Jack Daryl Espiel-Oracle Wow this is a very good description. I think this will work out, I will try it later and lat you know if it works. Thank you for working this out. Regards Toanne

Hi @Jack Daryl Espiel-Oracle The field Assembly Item Description is a custom field because I can't find the Description field on my custom record On the Item Fulfillment the field Description is available and it's not a custom fields. I should expect the field in the option on my custom record by the Item Fulfillments: But…

Hi @Jack Daryl Espiel-Oracle Thanks for the help, again. I adjusted my saved search field by field and then I saw that 1 field took care of all those extra lines (Assembly Item Description). After I have removed this field grouping is no longer necessary. I did change the filter to Internal ID (instead of Internal ID…

Hi, Normally I should use the Summary function. But if i use a Group of the document number I receive the following error: Don't understand why I receive this message, i've never had this one before. What should I do?

Hi @Jack Daryl Espiel-Oracle Thank you for your answer. When I remove the 'Main Line' the results on the Saved Search are correct, but only on my custom record (as Sublist) the information is still shown multiple times. Result Saved Search: Same Search but then as sublist on a custom record with 1 fulfillment with 2 lines:…

Hi @Kristoffer Viray-Oracle Thank you for your answer. I think it will work, but we have to look into it first. And we need a scripter for the solution. At the moment we must leave it this way. Thanks and have a good day. Regards Toanne

Hi @Jack Daryl Espiel-Oracle Off course I can, here the results.

Hi @Kristoffer Viray-Oracle Yes thats correct. We are printing a document of the new Custom Record we created and need the information that is shown on the subtab by a custom saved Search. This is our custom record: And the results with the information (example) that we need on our HTML/PDF Hope you can help me and tell me…

Hi @Jack Daryl Espiel-Oracle Search Type: Custom Record - CMR Completed Criteria: Results: Filter: Results on Record: It's all in our development account because we are testing a new own scripted solution. I find an article about the LineSequence and tried the formula but thats not helping, still see row for 1 item 3…

Thnx @Mikko De La Fuente-Oracle Then we have to wait until NetSuite picks up the Enhancement, what could take a while with the 10 votes at the moment :( Unfortunately it is wat it is at the moment. Have a good day.

Hi @Mikko De La Fuente-Oracle and @Ivy Lopez-Oracle Thank you for your quick response! We will vote for the enhanchement and I will let our scripter know. Is there maybe a workaround for this? Regards Toanne

Hi @Ivy Lopez-Oracle , Thank make sense, but what string do i have to use in the a script? When I look into the record browser information there is no field 'BUILT' that we can use. Is it for the script then also Quantity Fulfilled/Received? Or should I look somewhere else? Thanks again. Regards Toanne (And of course best…

Hi @Jack Daryl Espiel-Oracle Thanks for your tips, these are helpfull. For some reason the custom segment field was not visible on the Custom Vendor Bill. I changed this and that was the solution and i'ts now available in the CSV Import. Have a nice day. Regards, Toanne

I think I found the answer if it is also possible to import with a , instead of a . There is a default setting for import CSV Decimal Delimiter and this solves a lot of issues for me! I never noticed this setting before ?

Hi @Ivy Lopez-Oracle Thanks for your reply and i think you are right, there is no difference, just the time for the import. I tested yesterday after doing a bulk revaluation, I exported the transactions I need to change manually and re-imported it. This works and the valuation of the stock is also calculated correctly. I…

Hi @Ivy Lopez-Oracle Thank your for looking into it. I will look in to the Answer ID's of importing the Inventory Cost revaulation. I really thougt that the External ID of the Inventory Cost Revaluation is the same as the internal ID of the Planned Standard Cost, But unfortunately that's not the case. Do you may have a way…

Hi @PaulFleetwood Thank you for your answer. It is a workaround but it looks like a lot of extra manually steps for the customer. I don't think our customer would like this solution but I will let them now the solution you provide. Indeed it's another poor / incomplete implementation of NetSuite, again. Let's just hope…

I'm interested in the workaround you provide Paul. Our customer has the exact same issue with theire customers. I wonder if it works at your end. Regards, Toanne

Hi @Shamaine Chan-Oracle Thanks for the answer. I voted for the enhancement. So it means for now we can not select multiple transaction in the filter. That's too bad but it is what it is now. I hope they pick up the enhancement soon. Have a nice day. Regards Toanne

Hi @Jack Daryl Espiel-Oracle Wow thank your for your answers and looking into it! Too bad we're dealing with system limitations again... The Saved Search should be helpfull. I also created a saved search with the Saved Search Type Documents there you have acces to some more info like the system notes so I hope this will be…

Hi @Jack Daryl Espiel-Oracle I tested the sublist for the transaction and that one is working. I do miss some information so I have some additional questions: - is there a way to check if someone deleted a file from a transaction? - Whats the easiest way to search for deleted files in the File Cabinet? - Can we add some…

Hi @Jack Daryl Espiel-Oracle I Checked the transaction Body field but there was no formula. I've also checked the workflow again and I saw that there is a state 'Before Record Submit'. After I enabled this state the Sales Order Approve button is working as normal. We don't need this 'Trigger On', because on the WorkFlow…

Hi @Shamaine Chan-Oracle What I do is the following: If I choose a 'Document Number' SO709 this is my result: If I select the the SO709 in the Sales Order List (and also the posibility to select multiple Sales orders) this is my result: If I use the Sales order Filter I don't get results and I don´t know why. When I add…

Hi @Jack Daryl Espiel-Oracle I think this solution will work! Didn't have time yet to test it but your explanation is very logical! Thanks! Regards Toanne

Hi @Jack Daryl Espiel-Oracle Thanks for your answers, i will vote for the enhancement. Do you may now if it's possible to create a saved search and add this search as a sublist on the item/entity/transactions to see what files are added for the specific transaction/item/entity and who had add the file or modified it? I do…

Hi @Jack Daryl Espiel-Oracle Thank you for your answer. We will do it by creating a bundle, even though you often have to 'overwrite' fields that already exist in the production environment. I also will create a support case for the error. Toanne

Hi @Joy Noreen Magoling-Oracle Thank you for looking in to it. I will vote for the enhancement, hope that more people will vote for this one! have a nice day. Toanne

Hi @Ivy Lopez-Oracle We will do a refresh in the next 2 weeks so I will test it again after the refresh in the Sandbox. I think we have some corrupt data that is getting in the way with testing. If I do create a support case after that I will let you know what the results are. Have a good day. Toanne

Hi @Ivy Lopez-Oracle That's to bad that this isn't working at the moment. I voted for the enhancements. Thanks for looking in to it. Toanne