what modules would you go about executing this tas...
# suitescript
s
what modules would you go about executing this task? I'm guessing the N/search module and N/record module?
s
What do you mean by creating a
custom template
?
s
the company will begin to invoice consulting time and our current invoice template only contains qty | item | Amount columns
so I need to make it have Date | Hours | Project Role | Consultant Name | Project Rate | Total
so most of this info will come from Projects
but I have no idea on what modules to use for joining tables....I'm following the documentation and practicing by creating searches, playing with the objects & parameters
mostly just been using the N/serach module.....
b
General advice is to create the search in the ui first
Then recreate it in code, either by loading the saved search to recreate it in code
s
thank you @battk I'll play around some more
b
If you hit a limitation of saved searches (very likely when working with multiple joins)
You can either do multiple searches, or switch to workbooks (N/query)
s
s
nice!! thank you @Sandii my goal is to become decent at SuiteScripting in one year, I've been viewing the xml using the &xml=T trick I found online
s
Good suitescript is also good JavaScript. I'd recommend focusing as much on JavaScript (or even TypeScript if so inclined) as NS is really just a big javascript library that manipulates NetSuite in some way.
s
I have about 6 months of JS, still a noob but I'll get there eventually, I figured learning SuiteScript would force me to learn JS quicker
b
dont have high hopes there, suitescript is terrible for learning javascript
e
Their
JavaScript Algorithms and Data Structures
section is a great start