Hello Gurus,
I'm uploading Employee Time Tracking against Project tasks via csv. This is working well, but I am wondering if it is possible to link the tracked time to the relevant project using just the ID, not the Name/ID which I seem to have to be using at the moment.
Using this example the Project ID is "AD2023" and the Project Name is "Admin Time Tracking 2023". Netsuite groups these together in to a field which is called "Name/ID" (incidentally I don't seem to be able to add this "Name/ID" field on any custom searches, I wonder it it has other names?)
In my .csv file, if I put the full "AD2023 Admin Time Tracking 2023" under Project ID and map it to "Customer", it works - yes!
But I don't always have access to that information accurately, I normally only have the Project ID, and I'm trying to do 140 entries against 55 projects at one time, so having to go through and find the exact NAME/ID from each project record and copy/paste in to excel takes over an hour normally only have the ID (I realise there are faster ways of doing this with an export of all projects from netsuite and a vlookup in excel, but I'm trying to make this monthly CSV import task as simple as possible, would also be good if I could establish what Name/ID on Custom Search results is called to achieve this).
If I map just the available Project ID, "AD2023" in the example above, to "Customer" from the right on the screen shot below, it returns the following error: "Invalid customer reference key AD2023 for employee 508."
Field Mapping can be seen here:
Thanks in advance for any help on this, it will make these monthly time uploads take 10 minutes rather than an hour.