Hi @Kristoffer Viray-Oracle I am currently still testing this. I will let you know the results once I have tested this properly

HI @Niks Blando-Oracle Thank you for looking into this. Is there a workaround in that case? For example, if the order is not released, for it to still be picked in the warehouse using scanners? Alternatively, is there a way to set up the item so that it has the same attributes as a multilevel kit mentioned in this use case…

Thanks @Kristoffer Viray-Oracle To clarify, is it possible to script setting the field or how the field displays? At the moment, I can't set the field value using a workflow

To add to this, I have tried to set this field (the native order type field) using a workflow It doesn't accept text values: but it also doesn't accept integer values: In the case of the integer value, the workflow action is referencing another field ( which is an integer field) which should be used to set the value for…

Hi There Are there any updates on this? Thanks

Thank you @Michelle Jabanes-Oracle and @Matrim Matrim's solution to test the check box worked perfectly

Hi @Michelle Jabanes-Oracle I tried the exact freemarker: There are two line items though only one of them has the discontinued flag checked: The output seems to treat both items as discontinued:

Hi @Kristoffer Viray-Oracle thanks for the speedy response! To confirm, is the limitation only on picking tickets? The advanced pdf I am trying to source this field on is for the invoice. Thanks

Hi @Michelle Jabanes-Oracle Apologies for the delay in responding (it was a public holiday here yesterday and I didn't see this on Saturday). I will test and post my results here. thanks

Hi @Micah Timbol-Oracle Sorry, I haven't had a chance to test this yet. I only saw the solution today (Tuesday morning) and yesterday was a public holiday so didn't see your suggested solution from Saturday I will test and feedback here. thanks

Hi Michelle I had removed this. I had assumed that was needed to indicate the discontinued checkbox was on the item record and not the transaction record (where the email is being sent from the transaction)? It doesn't produce any results even with the item removed

Hi @Kristoffer Viray-Oracle That wouldn't work for this use case since: 1 the items from the sublist which are discontinued will need to be listed and 2 the condition on the workflow will need to evaluate whether the sublist contains items which are discontinued. Looking at the workflow condition builder, I don't see any…

Hi @Michelle Jabanes-Oracle This is my exact formula: I am getting a blank result despite the checkbox(field id: custitem_item_discontinued) being checked

Hi @Michelle Jabanes-Oracle , @Matrim I have tried: <#if transaction.item.custitem_discontinued == true> and <#if transaction.item.custitem_discontinued == 'T'> and  <#if transaction.item.custitem_discontinued == T> none of these work

I can't work out how to test for whether a field is checked or not though. i.e. I want certain text to appear only if the following checkbox is ticked I have tried <#if transaction.item.custitem_discontinued=Yes> <#if transaction.item.custitem_discontinued=T> <#if transaction.item.custitem_discontinued=True> <#if…

Thanks @Michelle Jabanes-Oracle for looking into this. it looks like the following might be working The email from this: and order with no backordered items Hi Thanks for your order #${transaction.tranid} <#assign hasbackorder=0/><#list transaction.item as listitem><#if listitem.quantitybackordered&gt;0><#assign…

Hi @Micah Timbol-Oracle An example use case: Depreciation is calculated for an asset as follows (this is the depreciation history schedule) The amount of depreciation is shown per month and posts in that manner: Is there a way for the depreciation to be calculated for the period rather than the month? i.e. what the…

Thanks @Mikko De La Fuente-Oracle I was placing the record into edit mode and saving immediately without clicking anywhere in the transaction. In terms of other scripts, there are several client scripts from locked bundles on that record. To test whether it was this script causing the issue, I tested it in another account…

Hi @Mikko De La Fuente-Oracle I am getting the same error with the revised script per your suggestion: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/record"], function (record) { /** * @param {ClientScriptContext.fieldChanged} context */ function fieldChanged(context) { //the if condition ensures the field…

@Kristoffer Viray-Oracle Any updates?

@Mikko De La Fuente-Oracle Isn't this line saying for the post sourcing to occur if the account field in the expense sublist is changed? if (sublistName === "expense" && sublistFieldName === "account"

Hi @Kristoffer Viray-Oracle Any updates on this? Thanks

Hi @Mikko De La Fuente-Oracle Yes the field is mandatory for amount. However, when I put the record into edit mode and save without clicking into any fields, why would this prompt me? Shouldn't the script not trigger unless I click into the account field (in the expense sublist)?

Hi @Kristoffer Viray-Oracle That was one of the fields I had used and got the same result

Hi @Mikko De La Fuente-Oracle Apologies for the late response. I have and it is now working. I have marked your post as the correct answer. thanks

This is the amended version though /** *@NApiVersion 2.x *@NScriptType MapReduceScript */ define([ "N/search", "N/record", "N/render", "N/file", "N/xml", "N/email", "N/runtime", ], function (search, record, render, file, xml, email, runtime) { function getInputData(context) { var scriptObj = runtime.getCurrentScript(); var…

Hi @Patrick Fresnosa-Oracle The vendor bill has been approved though there is no option to link to the intercompany transaction in the customer invoice This is the customer the vendor bill The options under the vendor bill The unrelated transaction belongs to this customer: The vendor for the vendor bill

Hi @Mikko De La Fuente-Oracle Custom record: I had tried using the integer though that also didn't work. With the map reduce script, I have tried to convert the existing UE script though am not sure what goes into the map stage? i.e. from the UE script, would the email template merge and the email send function be part of…

Thanks @Leonard Mallare-Oracle EDIT: it turns out the record is being saved though I just need to navigate it back to the invoice record. Thanks for your help Leonard That got rid of the error of 'select at least one item' However, nothing is being populated in the sublist. It doesn't prompt me with an alert and doesn't…

Hi @Leonard Mallare-Oracle I have passed the values to a form level client script via the parameters. The record load is part of the client script: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/url", "N/record", "N/runtime"], function (url, record, runtime) { /** * @param {ClientScriptContext.pageInit}…