Vernita Bronze Trophy

Hi @Micah Timbol-Oracle Thanks for your suggestion. The csv imports is what we are currently using as a workaround. It's somewhat time consuming so I was hoping there was a script that could handle auto numbering for entities. Is this something that is scriptable? Thanks

I have got that part of the deployment working now. It turns out the 'add dependencies' doesn't add all dependencies. I had to key in a number of custom objects into the manifest xml file. Eventually, I was able to deploy this. I am now trying to deploy a custom vendor form though have another issue: Does this error…

Hi @Mikko De La Fuente-Oracle Yes, SDF has been enabled. The custom objects are available in the target account and it had projects deployed to it previously

Hi @Dominica Sevilla-Oracle Thanks for following up. I haven't tested the solution in your last message yet sorry. I will do this and let you know

Hi Shamaine Thanks for your help... I will need to test this and get back to you.

I found the problem: Originally. the address internal ID column in my first screenshot was showing the second row When I replaced it with the first row, it aligns:

Hi @Shamaine Chan-Oracle Thanks for the suggestion. Customer balances would be made up of migrated opening balances; invoices; credit memos; and payments. I am trying to replicate what is seen on a customer statement suitelet screen: Here, entering a statement date and tabbing out of that field results in the balance…

Hi @Dominica Sevilla-Oracle I have followed the listed steps above as follows: I have also tried this while leaving the payment method field blank: This is a refund on the following: This is the EFT customer refund screen I would expect the customer payment refund to show in the screen per the screenshot above thanks

Hi Micah That search doesn't give me the result I am after. Namely, the last depreciation record for each asset

Hi Emilia I found the issue. There was no asset life entered under the alternative depreciation method which was causing the schedule to not populate. Thanks

Hi @Jack Daryl Espiel-Oracle Thanks for detailed instructions. One thing I wanted to check was around the field 'next approver'. At the moment, it is being set to the user(PO creator's) purchase approver.. In this case, I want it to go to the next level up if the user's purchase approver does not have sufficient purchase…

Hi @Jack Daryl Espiel-Oracle I have this on my list to test this week. I had been working on a few other things in Netsuite so need to revisit this. Thank you for your detailed response

Hi @Emilia Ironov-Oracle and @Shamaine Chan-Oracle Is this query still being looked at? I would really appreciate some advice on how to do this thanks

Hi @Shamaine Chan-Oracle The Suiteanswer doesn't really apply in this case unfortunately' The transaction in question here is a vendor bill credit (Australian Dollars) and vendor bill (New Zealand dollars) How do I apply the vendor bill credit (AUD) to the NZD vendor bill?

Hi @Shamaine Chan-Oracle : Someone offline suggested using a suspense account to deal with the currency difference of the vendor bill and the bill credit being in different currencies. Do you know what this would involve (I didn't get a chance to ask them further)

I have found some code that works (trial and error) I can't understand what some of the code is doing though. I have tried looking up the Freemarker website to find what "|" is supposed to do though couldn't find anything. I have bolded this in the template code: <#assign itemCount = 0 /> <#assign taskGroup = ""/> <#assign…

Hi @Shamaine Chan-Oracle It doesn't appear to be possible to do that. If an amount, other than a negative amount, is applied for the bill credit to the bill, it results in the 'apply' button becoming unchecked and the $0 in the amount column disappearing per the screencap below: The bill credit needs to be applied in full…

Hi @Emilia Ironov-Oracle Are there any updates on this? thanks

I adjusted the code and it now works: <#assign latestDate = "12/31/3000"?date("MM/dd/yyyy")> <!-- Assumes that no date in the list will be earlier than Jan 1 1980 --> <#list statement.lines as line> <#if (line.datecol < latestDate)> <!-- The parentheses are essential here to use the ">"; without parenteses, you need to use…

Thank you so much for your help @Pierre_Plourde . You are awesome! I have one last question (sorry to keep bugging you): I have tried to modify the code to see if it is possible to get the earliest date from the date column This is the code I am using: <#assign latestDate = "01/01/1980"?date("dd/mm/yyyy")> <#list…

Hi @Pierre_Plourde Thanks again for your detailed response. I appreciate it. I am actually trying to find a max date value in a list of values in a multi currency statement. I had mistakenly thought the code would be the same to access a sublist and find the max value so I used the screenshot from a demo account invoice.(I…

Hi @Pierre_Plourde Thank you for your detailed response. I should have been a bit clearer in my requirements: I am looking for the highest value in a set of values. So in this case, the quantity column isn't summed together. Instead, it is finding the largest value which in the example above happens to be 6,500. With…

Thanks @Jack Daryl Espiel-Oracle ! That resolved the issue

Hi @Jack Daryl Espiel-Oracle Please see below: Transition from initiation to Pending Approval:

Hi The record is a purchase order. I am trying to edit the lines of the purchase order so that the total results in a different approval routing and state. I have found that issue if the purchase order is already approved, and I alter the $ value so that it is still approved. If I alter the $ value so that it needs to be…

Thanks for the suggestion @HertsChris @Emilia Ironov-Oracle are there any updates from your colleagues on how to reapprove a purchase order on edit?

Thanks Emilia. That worked perfectly!

Hi @Shamaine Chan-Oracle I am trying to create a saved search showing all items and their stock levels. Thanks

Hi @Patrick Fresnosa-Oracle Thank you for the detailed answer. I was asking on behalf of a colleague and they have a follow up question: They wanted some clarification on whether a elimination subsidiary is needed if the subsidiaries transact in different currencies? In this case, the transactions are not arm's length. The…

Hi @Michelle Jabanes-Oracle That works perfectly! Thank you