Posts

Showing posts from May, 2023

Returning to the Office

Image
Management has recently announced that employees have to return to the office. For our organization, we will be expected to come in weekly. Naturally, there were complaints. I've been listening to some feedback and there are really a few valid reasons why some employees can't return to the office. For instance, a person pre-pandemic used to rent a place to make it easier to get to the office. During the pandemic, they decided to stop renting and work remotely back in his province. Going to the office would now take him 2 more hours, and would cost twice as much as before. It's good management considered such scenarios and allowed for some people to come to the office monthly instead, or even work remotely permanently. But for those that can come once a week, it may feel like a hassle. I realized that if I was able to go to the office before, it shouldn't be a problem to go back, given I have no valid reasons that prevent me from going in the first place. If transportati...

NetSuite: Saved Search to Show Sales Orders that Have Specific Promotions

Imagine having two promotions, whose coupon codes are "ItemPromo1" and "ItemPromo2". If you want to find sales orders who have both promotions applied, do the following: Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title : Enter a title Click Criteria Click Standard Filter : Select Main Line Main Line : Select Yes Click Set Select Type Type : Select Sales Order Click Set Click Summary Summary Type : Select Maximum Field : Select Formula (Numeric) Formula : Enter instr(NS_CONCAT(Distinct({promocode}||{promoapplicabilitystatus})),'ItemPromo1Applied') Formula (Numeric) : Select greater than Value : Enter 0 Summary Type : Select Maximum Field : Select Formula (Numeric) Formula : Enter instr(NS_CONCAT(Distinct({promocode}||{promoapplicabilitystatus})),'ItemPromo2Applied') Formula (Numeric) : Select  greater than Value : Enter 0 Click Set Click Results Click Remove All Field : Select Document Number Summary Type : Sel...

An Introspection on Fear

Image
If there is no sale, look for the fear. If a marketing meeting ends in a stalemate, look for the fear. I'd like to add, "If there is no progress in the job hunt, look for the fear." It's been about 6 months and several companies, and still no luck on finding a company that's willing to take a chance on me. I've done a lot. I've posted a comment on Marty Zigman's blog . I'm getting noticed by presidents of companies that are NetSuite partners, yet why don't I still have a better offer? I have my recognitions and customer feedback out in the open. But perhaps I haven't done enough. Sure I'm lined up for doing more. I'm planning to give a saved search training no one has ever given before (distinct of the SuiteAnalytics training). I'm planning to start a book club with managers and other leaders (though I'm not in a leadership role myself). I will be taking my NetSuite Administrator Certification exam soon. So what is my fear? ...

A Dive Into Implementation: Hackathon4Good 2023

Image
A question I've often come across during interviews was "Do you have any implementation experience?" It was only recently that I have actually gained some. NetSuite has social impact efforts, and this year, the social impact team has decided to host a hackathon4good . And it was quite an interesting experience. The non-profit organization partnering for the event is a company that delivers blankets to children in hospitals. I couldn't use their company's logo, so I just used the closest picture I could find that's somewhat related to their cause. Hundreds of attendees were grouped into teams. I was teamed up with six others with expertise from various NetSuite modules. It was a good mix -- an opportunity to bring different perspectives to tackle the three main problems of the organization we were to help. The main goals were (1) to establish a more efficient process to cut down Invoicing and Shipping lead times, and at the same time accurately forecast expecte...