Do your employees enter time in NetSuite? If they are sick, do they not select Sick Time as a service item on their time sheet? Or you are saying the system is properly setup, but you have the problem where people will outright lie and enter sick days as working days? If the latter, NetSuite does not have capabilities to…

Yes, but not all at one place. If an employee simply view records, you can't do much, there are no real logs for that. But if they exported a search (or even ran a search, I think), you can look on the search's audit log and see it. Problem of course if you have to check every search one by one. Also, if they created their…

Hi Izak, Standard Column fields cannot be made mandatory via configuration. You can use scripting to achieve this.

You should be able to do this under Transactions->Management->Print Check and Forms->Direct Deposit Voucher

No you can't see that, you'd have to ask them. Note that some preferences can be overriden by going to Setup->Company->General Preferences. You can mark some settings as NOT user-derfinable (they will use the Company Preference setting)

Er... wouldn't each user need to execute the script themselves, since the context is subjective to the user triggering the script... So, kinda comes back down to asking people what their settings are. Either ask them to send in screenshots, or "go click on this suitelet to we can capture your settings".

You can create a Custom Form that hides the fields you don't want the user to see, and on his roles place a restriction so that he can only use that form. However, that won't stop him from running a Search and outputting all that information. You would thus have to restrict his ability to run searches, which is basically…

Hi Hayley, If it's just the check number, try the following: Go to you paycheck register, and tick in the "print" checkbox for the paycheck Then go to the Print Paycheck screen Select the account and tick in the Paycheck Where it says "First Check Number", enter the number you actually want to use Click Print. That should…

This is not possible.

The only method is to export the data and reimport it, the same as if you were doing a migration for a new implementation. There are no shortcuts.

Just to check... you are aware NetSuite has a built-in CSV import tool, right? What is your use case for recreating it?

Yes, you can create a Configuration Bundle. You can find about this in the Help, under SuiteCloud (Customization, Scripting, and Web Services)-> SuiteBundler-> SuiteApp Creation and Distribution-> Types of Bundles-> Configuration Bundles

It is. You will find them under the New Search page.

A custom search should do the trick pretty well in this case. You can set it to email someone the CSV, or you can go fetch it every day,

If he can generate XML, can he not generate something else? He could generate a CSV file for manual import, a SOAP request for Web Services integration or he could generate a JSON for RESTlet-based integration. That beign said, you CAN feed a RESTlet XML, it'll just require a bit more deserializing work. There used to be…

The best practice is probably to first challenge the client with the need for the million of records. Everyone's initial reaction is always to "have it all" in NS, but the truth is there is a cost to every single you bring it. So the discussion regarding ROI of data needs to happen, and many times it doesn't. The answer…

1. Yes, just create External IDs to tie lines belonging to the same Bill together 2. Vendor Bills don't have auto-numbering...?

Mmm... are you, in your import, specifying a date AND a period for your record? All you need to do is specify a date. NS will automatically select the correct period based on the date. My assumption here is that that Period matching the date of the transaction a) exists b) is open and unlocked. Is that correct?

Did you define this prior fiscal year under Setup->Accounting->Manage Accounting Period?

Request a Sandbox refresh. You can do this from your Production account. Not that it may take a day or two, but probably very fast if your Prod account is empty. Otherwise, you can do a Mass Update Script for deletion.

Under Setup->Import/Export->CSV Import Preferences, make sure "Run Server SuiteScript and Trigger Workflows" is ticked in. That way your custom script will run and assign numbers to imported records (assuming your script is a User Event and not client script, of course).

JavaScript cannot make FTP calls. You need to develop a Web Services app, which will be able to make FTP calls. If this is Chinese to you, you probably want to look into hiring a developer/consultant to build that for you. There may alternatively be existing SuiteApps, I haven't looked recently, though last time I checked…

Make sure the fields are fully enabled on the Form through which you are doing the import. In other words, you can't import into Disabled or Inline fields.

Did you add new scripts, workflows or custom fields on items?

Should be possible using Web Services

You can contact Celigo to see what options they can offer to upgrade the app.

Yeah, hopefully Lorne's post is clear to everyone, but NetSuite is not discontinuing *XML*. It's discontinuing *smbXML* which was a data import method used at the dawn of NetSuite to import data before CSV import even existed (yes, there was such a time). smbXML hasn't been *supported* in years. It is now being completely…

Yeah, ran across this annoying problem. My solution was to create a script that opened each Account record and programatically read the value of non-searchable fields, and the script created a csv file with all that info and dumped it in the file cabinet for me to pick up. After looking things over, it was the only way I…

This looks very interesting and promising. WOuld you mind elaborate more on this? What/How should I do this? Where/How do I use the "&XML=T" ? Thanks in advance. Sorry, I meant append it to the url of the page you're on. So if I'm on a Case and the URL is…

I'm assuming by Product you don't mean Items, so I don't recognize this record type. Does it comes from a module like the Software Edition? Is it a custom record?