Toanne Termeer - van de Ven Red Ribbon

Hi Guru's, Is there maybe an update on this request? This is still an issue for our customer. When they use the 'Mark Work Orders Released' option (Transactions - Manufacturing - Mark Work Orders Released) in some way the WO will get the status Closed and Released in 1 second. When the WO had the status Closed it seems…

Hi @Joy Noreen Magoling-Oracle Thank you for your answer, but what i see now is only the row of the transaction with the highest value. What I need in this view is the New Unit Cost of the Inventory Cost Revaulation transaction 7343 - 15/04/2022 4601 - 06/04/2022 What i see if use your setup i only see the Cost of the…

Hi @Joy Noreen Magoling-Oracle You say it's Standard Behaviour that "The total inventory detail quantity must be XXX." In some ways our customer reproduce more in the related WO en need this quantity in the head WO. So in our customers case it's not always the same quantity. I thougt this wasn't an issue or that this was a…

Hi @Joy Noreen Magoling-Oracle In this case the 154 is correct, they have built more then required thats why the quantity is 154 in stead of 144. It happens regularly in practice, how can we solve this error? Regards, Toanne

Hi Joy, The Inventory Detail gives the right value of the related WO. We did create more on WO645 than we needed for WO644. Should that be an issue? I assume we can use the extra build quantity only for the related WO? Regards Toanne

Hi @Kristoffer Viray-Oracle I also just noticed that on Location Level you can set the WMS Account. If we create Inventory by the scanner this account will be used for the inventory adjustment. So no workflow is needed. Answer ID 69368 Regards Toanne

Hi @Kristoffer Viray-Oracle I just add an new Trigger in my workflow After Record Submit, and now the Account field is changed to the correct account. So this issue is solved for now. Thanks again for your help. Regards Toanne

Hi @Kristoffer Viray-Oracle I will wait for your results of the investigation. Thanks for that. Regards, Toanne

Hi @Kristoffer Viray-Oracle I just tested it with the workflow on Released and still no account 6205 as Adjustment account. In the system notes it is set on the 0504 account but in the workflow LOG the Account should be set correctly to 6205 But i don't see it in the Inventory Adjustment: Hope you can find anything for…

Hi @Kristoffer Viray-Oracle The Adjustment account that is set by Script (RESTlet) 0504. The workflow log indicates that it has been changed, but you do not see this change in the system notes. -Toanne

Hi @Kristoffer Viray-Oracle Thanks for your answer. If I use a Role were the Subsidiary is already set and i create a new Inventory Adjustment the account is filled in correctly by the workflow. If I do this in the administrator role (what is less important) and I use your settings in the workflow the account will be…

Additional question on this subject is that not all the roles can have acces to 'choose' the Adjustment Account. Is this also possible to enable this field for some roles? I tried a workflow but that also didn't work. Any tips?

Hi @Kristoffer Viray-Oracle It is understandable that you cannot provide a clear solution for this. But it's good to know that this can be done with script. We have our own scripter in house so he can take a look at this. Thanks for your help. Regards Toanne

Hi @Kristoffer Viray-Oracle Thanks for looking in to it, but that's not such good news. Is there perhaps a work around via case statements in a workflow or something with which we can show the correct data? Or is filtering really only possibility on the field? I hope there is a solution anyway. Anyone have an idea? Or is…

Hi @Kristoffer Viray-Oracle No Problem, I will wait for your findings. Thnx for looking in to it!

Hi @Kristoffer Viray-Oracle Thanks for looking in to it. To bad that it's not availble as default. I will check if the workaround in Answer ID 14686 will work for our customer. Thanks for you help. Regards Toanne

Hi @Kristoffer Viray-Oracle I've checked both options, First option doesn't now an automated email for the Tasks. I do see emails for Cases and issues but not for a Task. Second option the record type Task isn't available. I know how to customize the emails but I can not find the default email that is now send automaticly…

No Problem @Kristoffer Viray-Oracle Good to know that the sequence is so important for this kind of workflows. Do you perhaps know where I can change the automated email that is send to the person the task is assigned to? Regards Toanne

Hi @Kristoffer Viray-Oracle I think I fixed it. I was playing around with the order and suddenly I had the answer. The sequence that works is: Thanks for the help. Regards Toanne

Hi @Kristoffer Viray-Oracle The sequence is not the exact issue. The error I receive is: It seems that the SO228 (ID24010) is not valid for Company C3 Test company (id 1023). I don't know why that is, because the SO228 is for that customer: The Workflow now is: If I use the sequence that you provide I receive the same…

Hi @Kristoffer Viray-Oracle Sorry, didn't have time yet to check this but I will this week. I will update you when I know the solution you provide is the solution to make it work. Regards Toanne

I will do @Joy Noreen Magoling-Oracle

Hi @Joy Noreen Magoling-Oracle Thanks for answering. The workarounds aren't working on the location that already exist. If I add a new location the field 'Purchase Lead Time' is available. But on the existing location the field is greyed out (both when the Auto Calculate is disabled). And that's what the field that I need.…

Hi @Ivy Lopez-Oracle Thanks for helping me out. I the mean time i know what you guys need to help me :) But the accounts make sense. 2 of my items with the min quantity have another Account type - Other Current Asset - in stead of Income. I add the formules you provide and that works perfectly. I also have to put the…

Hi @Kristoffer Viray-Oracle It turned out to be in the customer's credit limit. The error message doesn't show that very clearly so it took some searching. Further research is no longer necessary. Regards Toanne

Hi @Jack Daryl Espiel-Oracle The most strange thing is that the fields now are available on the Item Fulfillment so i don't have to use the formula anymore. I think the issue is the 'Text Area' fields that give the problem to show multiple lines. For now it's fixed but it's again strange behavior of NetSuite Have a good…

Eventually I used Formula Text with the ID of the Custom Transaction Body Field and that will work, also on the custom record in the sublist. I still think it's strange that the field is not available in the normal way.

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…