Posts

Showing posts from March, 2023

Income Reveal

Image
I could not wait another week for this post. So this is the second post this week. Do you want to know how much we make? A quick Google Search could show you a rough estimate. Impressive right? But how I wish that could be true in the Philippines as well. In reality, we likely get paid for up to only 20% of those amounts, and that's if you really, really outperform the rest. I've known about this for quite some time and I know a lot who have noticed the same thing. And it's not only our company -- it's the entire industry. I have some IT professional friends who are complaining about the exact same thing. We are getting paid for much less than our international counterparts. Sure, the standard of living is cheaper here. But nowadays, what we make is barely enough to catch up with rising inflation. Did you know that Manila is the second most expensive city to live in across Asia (second to Singapore)? Now who is to blame? It's easy to pin the blame on the company tha...

NetSuite: SuitePromotions Are Not in the Promotions Tab

The behavior could be a result of a number of things. Below are the general steps to resolve the concern. Navigate to Lists > Accounting > Items Filter : Type : Select Discount Sales Discount : Click Edit Include Children : Enter Checkmark Click Accounting Account : Note the Value (Example: 4004 Income : Sales Discounts) Click Preferences Available to Adv. Partners : Enter Checkmark Click Save Note : Do this for other Discount Items you would use in your promotions. Navigate to Lists > Accounting > Accounts Account : Click Edit Note : Edit the account that was noted earlier (Example 4004 Income : Sales Discounts). Subsidiaries : Include Children : Enter Checkmark Click Save

On Handling a Transaction Mindset

Image
It's really hard to rid yourself of the mindset of work being a transaction. Linchpin talks about giving your gifts without getting paid for the extra you put in. And when you are paid for doing something, then it's not really a gift; it's not something extra. Reality is the culprit. I'm currently in a work environment that is really great. I've been motivated enough to work harder than the rest. I do my best to do things that are not required of me. I'm given new challenges, and opportunities to improve my skills. However, reality hits me whenever I think I'm not gonna earn enough from my current job to improve my family's standard of living. Expense creep is a thing, especially when your kid/s is/are growing up, and the economy worsens every year. These concerns are valid. We are human, after all. Naturally, I'd ask my company for more. And I have been, for two years now. But the response has been really slow. I know my value is so much greater tha...

NetSuite: Custom Case Duration Search

This is a search that I've spent some time creating. Heads up, this is going to be a complicated search. The purpose of this search is to be able to track how many business hours have passed since a case has been created. Business hours are Mondays at 4AM through Fridays at 5PM. floor(((abs(round(to_char(trunc({createddate},'DD'), 'J') - to_char(trunc({today},'DD'), 'J') - (trunc({createddate},'d')-trunc({today},'d'))/7*2 - (case when to_char({today}, 'DY') = 'SUN' then 1 else 0 end) - (case when to_char({createddate}, 'DY') = 'SAT' then 1 else 0 end), 2))-1)*(17-4) + (decode(sign(trunc({createddate},'DD')+17/24 - {createddate}), -1 , 0, trunc({createddate},'DD')+17/24 - {createddate}-(case when trunc({createddate},'DD')+4/24 - {createddate} > 0 then trunc({createddate},'DD')+4/24 - {createddate} else 0 end)))*24 + (case when {today} > trunc({today},'DD')+17...

NetSuite Values: A Quick Interview

Image
Yesterday, I received an email from someone from our company's Social Impact team. The team is working on a landing page for our company's website and are looking for some quotes from the 4 global Values in Action awardees in 2023. Here were my responses: How do you feel that NetSuite's Values add to your work experience? If there's one thing in common about each of NetSuite's values, it's being of service to others. I've noticed that as I've helped customers, my own product knowledge, my exposure to different scenarios, my adaptability or change agility all improved. On top of that, helping colleagues with their tasks multiplied that improvement tenfold. I concur with Walt Whitman, a poet who said "The gift is to the giver, and comes back to him..." How do you bring the values to life?  Changing how we view work is key to bringing the values to life. I like to treat my work as a form of art, and myself an artist. Artists create and care enough...

NetSuite: Saved Search Showing Opportunity, Estimate, Sales Order, and Invoice

Image
If you want to see transaction life cycles using a saved search (meaning a search that would display opportunities, along with their related estimates, sales orders, and invoices), you could try doing the following. Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title : Enter a title Click Criteria Filter : Select Main Line Select Yes Click Set Select Type Select any of Multiple Select Field : Select Opportunity Click Set Click Results Field : Select Document Number Summary Type: Select Group Select Formula (Text) Summary Type : Select Maximum Formula : Enter  case when {applyingtransaction.type} = 'Estimate' then {applyingtransaction} end Select Formula (Text) Summary Type : Select Maximum Formula : Enter  case when {applyingtransaction.type} = 'Sales Order' then {applyingtransaction} end Select Formula (Text) Summary Type : Select Maximum Formula : Enter  case when {applyingtransaction.type} = 'Invoice' then {applyingtr...