Vernita

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

in Freemarker Email Template-if logic Comment by Vernita Sep 27, 2022 7:57AM

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

in Non calendar month accounting periods-impact on depreciation calculation Comment by Vernita Sep 26, 2022 11:23PM

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

in Freemarker Email Template-if logic Comment by Vernita Sep 22, 2022 1:54AM

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…

in Freemarker Email Template-if logic Comment by Vernita Sep 21, 2022 9:26AM

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

in Freemarker Email Template-if logic Comment by Vernita Sep 21, 2022 8:30AM

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

in Freemarker Email Template-if logic Comment by Vernita Sep 20, 2022 9:14PM

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…

in Freemarker Email Template-if logic Comment by Vernita Sep 18, 2022 11:01PM

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>0><#assign…

in Freemarker Email Template-if logic Comment by Vernita Sep 17, 2022 5:43AM

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…

in Non calendar month accounting periods-impact on depreciation calculation Comment by Vernita Sep 15, 2022 3:32AM

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…

in Pop up with 'Enter amount' on expense sublist keeps popping up Comment by Vernita Sep 7, 2022 6:15AM

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…

in Pop up with 'Enter amount' on expense sublist keeps popping up Comment by Vernita Sep 6, 2022 9:22AM

@Kristoffer Viray-Oracle Any updates?

in Saved Search, Analytics and Reporting Questions Comment by Vernita Sep 5, 2022 6:46AM

@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"

in Pop up with 'Enter amount' on expense sublist keeps popping up Comment by Vernita Sep 2, 2022 2:35AM

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

in Saved Search, Analytics and Reporting Questions Comment by Vernita Sep 2, 2022 12:17AM

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)?

in Pop up with 'Enter amount' on expense sublist keeps popping up Comment by Vernita Sep 1, 2022 11:50PM

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

in Journal Approval Workflows Comment by Vernita Aug 31, 2022 8:25AM

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

in Workflow Action Script governance limit exceeded and related records attachments Comment by Vernita Aug 3, 2022 3:37AM

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…

in Workflow Action Script governance limit exceeded and related records attachments Comment by Vernita Jul 27, 2022 2:26AM

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

in Linking intercompany transactions manually Comment by Vernita Jul 26, 2022 11:54PM

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…

in Workflow Action Script governance limit exceeded and related records attachments Comment by Vernita Jul 25, 2022 11:34PM

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…

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 22, 2022 12:12AM

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}…

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 21, 2022 10:30AM

Hi @Leonard Mallare-Oracle How is the sublist array passed across from the invoice to the vendor bill? Is this through the url parameters? In your example, you have the record being loaded to obtain the values. Is this step necessary if I am using a beforeload entry point on a invoice record in view mode? thanks

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 21, 2022 4:11AM

Hi Leonard thanks so much for your help. I’m still testing this and will update once I have

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 20, 2022 9:48PM

Hi @Katerina Winklerova-Oracle Thanks for looking into this. Regarding the first question, what I meant was the amount is $0.03 stored in a field (e.g. {amount}) However, rather than displaying as $0.03, if this value is part of a formula calculation (e.g. formula(text)= "$" & {amount}). then it displays as $.03 without…

in Zero in a saved search drops off in the results Comment by Vernita Jul 17, 2022 11:38PM

Hi Kristoffer Regarding making the sublist the preferred view, this will be true for all sublists of this record type from what I can see. i.e. the base record for this sublist is transactions. If I were to make this the preferred sublist, wouldn't that apply to all transaction sublists? (and not just the case record I am…

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 11:06PM

Thanks @Kristoffer Viray-Oracle Would that filter the transactions so that the only ones available are related to the same customer as the case?

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 9:25AM

Thanks for the suggestion Emil. I was wanting to change the default behaviour of the sublist for all users by customising the fields that are available in the filters

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 8:50AM

Thanks Ivy. Is there a way to convert this using to_number and using formula(numeric)? I have tried the following TO_NUMBER(CASE WHEN {type} IN ('Credit Memo','Payment') AND {fxamountremaining}*-1 < 0 THEN '(' || (CASE WHEN {currency} in('USD','NZD','AUD') THEN '$' WHEN {currency} = 'British pound' THEN '£' WHEN {currency}…

in Negative Number Format for Saved Search Comment by Vernita Jul 7, 2022 12:50AM

Thanks. It doesn't have the symbol though

in Negative Number Format for Saved Search Comment by Vernita Jul 6, 2022 10:50PM

Vernita Bronze Trophy

Comments