User_DRRY1 Red Ribbon

I'd be happy to jump on a call and go through it with you. My guess is that the item configuration isn't correct and that when you added the new location and subsidiary, the import no longer successfully assigns the subsidiary correctly. The easiest way to start to troubleshooting is to go down to a single line CSV and…

There's not a great built in way to handle this. You would need to create a historical table of employee/billing class/effective date. In the timebill after submit event, you would update the billing class (if it's different). Happy to show you how and provide some sample scripts if you want.

…adding one more option of custom SuiteScript + SuiteQL.

Yeah….I got hosed by that too. I had to buy full licenses for staff because they needed project information. After 5 years, I built an external portal for my consultants to use to avoid the need for any NetSuite licenses. Now only core accounting team works in NetSuite. Happy to explain further and share insights if you…

Depending on your end goal, you can get these via SuiteQL. For example, below is a query that gets all project task resources for project tasks in a particular project (substitute project internal id for ###). If you want hours summaries (actuals, planned, percent complete, etc), you can join in timebills. We do tons of…

I agree with what Jebin noted as I've run into this myself in the past. I wrote a script to migrate information to the new project. It gets tricky because you have to ensure that you either duplicate items (like project tasks) or copy/deactivate items (like timebills). If you share the data that you have hanging off the…

Yeah, I've run into that in the past as well as we're opportunity to project based as well. I wrote a suitescript that attaches to the opportunity and updates child records either during the before submit or after (depending on your criteria). I'd be happy to help you implement something similar if you would like. Feel…