Toanne Termeer Bronze Medal

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

Hi @Ivy Lopez-Oracle I think this will work for our customer. I want to customize the Items Pending Fulfillment report. After Savin I expect this report when I click on 'Comitted' in the (customized) Inventory Snapshot but then I go to the standard 'Items Pending Fulfillment' and not the one that I customized. How do I…

Hi @Ivy Lopez-Oracle Thank you for your answer. What I don't get is that the items I tested with both have the replenishment Method - Reorder point. WO991 - Forward | Item: Replenishment Method - Reorder point (Manual) WO993 - Backward | Item: Replenishment Method - Reorder point (Manual) I don't understand why it does…

Hi @Jack Daryl Espiel-Oracle Thank you! This one is working! One more question, how can I round this currency to 2 decimal places? I know how it works with a 'normal' formula but with a script formula I have now idea. I now have a result with 12 decimals on the Sales Order: On the customer it looks like: Thanks in…

Hi @Jack Daryl Espiel-Oracle Off course I can. Entity Field: No extra information on the tab Display/Validation&Defaulting/Sourcing&Filtering) Workflow: (this one is working) Field is: Credit Limit Space on the entity Field on Transaction: Applies to: Sale I was hoping the sourcing& filtering was working but because the…

Hi @Micah Timbol-Oracle I made a combination of Answer ID 90831 and the Internal ID filter for a sublist. I create a new sublist for transactions and add this saved search to all transactions. Now I can add the fields I would like and still have the same results as the GL impact that Netsuite provides. Thanks again and…

Hi @Micah Timbol-Oracle Thanks for your answer. I will look in to it if I can use a saved search as provided in one of the answer ID's. I also voted for both enchancements so let's hope NetSuite will pick it up soon! Regards Toanne

Hi @Mikko De La Fuente-Oracle Yes is does but it's not the answer I was hoping for ;) I will vote for the enhancement. Thank for your help. Toanne

Hi @Katerina Winklerova-Oracle This is what I was looking for. Thank you! Have a nice day! Toanne

Hi @Ivy Lopez-Oracle Thank you for looking in to it The Formula is working, thanks for that. And also thanks voor the answer what is possible and not. Our customer has to work with it as provided for now. Have a good day. Regards, Toanne