Vernita Bronze Trophy

Hi @Dominica Sevilla-Oracle I had found that Suiteanswer and attempted the solution. This did not work as there was a standard check template that was active though it did not use this. I attempted to assign a starting check number to the 1000 check account (system account) so that it will increment this. I also attempted…

Yes, the credentials are the same I'm thinking we might way for a sandbox refresh to the latest release instead. I just wanted to know whether it is possible to set up integrations with release preview accounts?

hi @Mikko De La Fuente-Oracle It fails to recognise the credentials that are entered with an error that says it is not valid. I will try to get a screenshot and post it here

Hi @Emilia Ironov-Oracle For the following option, "Enter a new Lease record as if they were new so that the Lease will be tracked inside the FAM Module and make necessary adjustments", how would I do this? What do I need to adjust?

Hi @Joy Noreen Magoling-Oracle I have selected 'update' instead of 'add or update' and mapped the quantity and price fields. The 'overwrite sublist' box was also ticked under options However, this is the result: The quantities are still being overwritten. There was price value for all of the price levels under quantity 0…

Hi @Jack Daryl Espiel-Oracle Thanks for the suggestion. I will test this to see if I can modify the remittance details and the company name in addition to the logo

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?