Vernita Bronze Trophy

Hi @Joy Noreen Magoling-Oracle Apologies for the delay in responding....I hadn't got around to testing this till now. I have tried the creation of import headers in another account and found the following: Ticking overwrite sublists creates the headers, However, despite there being data for the existing quantity breaks and…

Hi @Emilia Ironov-Oracle I had a colleague suggest an alternative solution that worked: Changing the income/revenue account for the asset sale item (under the accounting tab) so that it is set to 'gain or loss on sale of fixed assets' gives the desired result of a gain on sale of $2,361

Hi @Joy Noreen Magoling-Oracle The account I was looking at has temporarily uninstalled the warranty and registration suiteapp so I will let you know the steps to reproduce the error once it is installed again. It was interfering with another app during data migration. Thanks

Hi @Joy Noreen Magoling-Oracle I had ticked this option. However, I found that it doesn't create any new headers. These needed to be set up before doing the CSV import. At least for the account I am looking at. I will try in a demo account and let you know if it works there

Hi @Micah Timbol-Oracle I don't have a script so was hoping someone who might have developed one previously might be able to give me some steer on how to do this or the script itself.

Hi @eleran Thanks for your response. I found that the quantity breaks aren't created from a CSV upload. So for instance, if I have not already populated the headers with 'QTY 2, QTY3, etc', when I do the upload against these quantities they do not get populated. I have to first create the quantity breaks of QTY 2, Qty3,…

Can I add a further related question to this please? Is it possible to create the quantity breaks via a CSV file? In this case, I had keyed in the 0,2,3,4,5 quantity breaks via the UI. This is tedious with over 300 records,

No. The resolution was that the validate locally option was creating the issue. Once I ignored that, I was able to deploy the project to the account. In terms of the dependencies, the project: adddependencies does not in fact add all required dependencies. I had to manually add these to the manifest file based on the error…

Hi @Joy Noreen Magoling-Oracle and @John Griffin Thanks for the responses. The item in question was a drop ship item. I was able to create a return authorisation from the sales order per your suggestion Joy.. The issue now is the item is under warranty and it needs to have a replacement sent out. I need to be able to…

Thanks @Micah Timbol-Oracle I haven't marked this thread as answered as hopefully someone might have a suggestion for a script?

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…