c amortization schedules

If you are trying to import the ACH data you have to import them by going to setup>entity bank details>import/export if you want to setup the jp feeds you will need to set up the financial institution and the format profiles. You should have a JPM technical resource to help you with the setup. Because it does require a few…

can you share how you set up your custom field?

make sure you are using update not add on your import. Map only using the internal id rather than the external id. That should help. If you are trying to add an external id. There is probably already a record with that same external id.

special work order

yes with a mass delete script. It runs on a saved search they have some you can download as a bundle. Please test in sandbox though before performing in a production environment

Not that I know of. The only way I can see that working is you would have to do an import and inactivate the users and then do another import to re-activate the users. Can accounting just do the function they need during off hours?

try the overwrite the sub list data when you imported. I would recommend try correcting one with that selected and validate it did what you expected. If the override sub list does not work. You may have to delete the duplicates and use the internal id of the record you keep to do any updates. This article shows how to…

check your headers for special characters. Also if you hit alt enter in your header of the file it could cause this. Last time I saw this happen was when someone tried to make the headers look better and it caused this issue. Hope this helps.

Do you use allocation or bins? If you use bins there is a saved search on suite answers that may help. Are you wanting to search by item? Or do you want to just see what sales orders are committed for each item? I included two different ones below. Answer ID77705 Scenario To create a Saved Search that would show you a list…

it will take some time there is a delete script bundle that you can install. It runs off of a saved search. It will not delete transactions with dependencies. You would have to remove those first. It’s not best practice to delete transactions. I do use it for removing incorrect data if doing cutovers though.

projects are available on the item line. Is it hidden on your form? You may have to look and make sure it’s showing on the item subtab. There is a limitation with assigning different projects to the bill. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_161251396811.html You must associate each item in…

forms don’t bundle well. You may have better luck just setting it up in production

If you are wanting to test email functionality yes you would need to have it turned on.

In your sandbox account after a refresh go to the below settings Setup > company > email preferences Under the email options tab you that to "do not send emails" You can also update it in production so each time you do the refresh it wont send the emails by default.

I believe the system internal id is -4, you can add a formula condition of employee.id=‘-4’ and then an action that sets the next approver to John smith.

You can also get there by going to Transactions at the bottom and then select document number.

I understand what you are asking now. When you search for document number you will want to hover over the field to see the path of the field. The one that is related to the transaction I found near the bottom of the list.

You can create automatic payment batches and setup an approval process to allow you to review and approve the payment before submitting it. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N1665332.html#subsect_0722032903

are you using the Electronic Bank Payments feature?

if you are trying to sort a saved search. You would need to create a custom search and in the results tab add document number to your sorting settings. https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N651604.html on reports you would also need to customize the report and sort by document number. hope…

A keep expense detail

B. set field value

You would have to source this field from the customer record onto the invoice. Then you can create a workflow to email the invoices to that email when they are created that day. The workflow would have to be on a schedule. You will want to keep in mind if the customer has to be emailed checked on the customer preference…

sales order

You cannot merge two items together. Do you have a duplicate item record that you are trying to consolidate?

False

Yes you can talk to your account manager about a sandbox enviroment. You would be able to refresh the sandbox environment from your production environment. I have seen the refresh process take anywhere from 6-12 hours. The sandbox data will be a copy of your production data, you get a date and time that the copy is made…

Looking at the code you have customized the statement a lot, you may have closing if statements where they do not belong. I tried to correct your section of your code. According the the available fields you should be able to use the gl line number if you want to use that.

True