Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Intelligent Payment Automation, powered by BILL (aka Bill.com), lets you automate payments, manage vendor details, and bank account information within NetSuite.
The SuiteApp is available to organizations based in the U.S. with a valid U.S. address, or to global customers (except Canada, China, and Japan) with U.S. business subsidiaries. It only supports payments to vendors operating in the United States.
For more information, visit this thread.
Custom Item Formula Field and Custom Record Types
I created a custom record type called 'stock status changes' and I made it a child of item records. On every item record I now have a sublist of these stock status changes so I can see historically all of the stock status changes and I can see how long things were backordered and so on (I should also say that we dont use the Netsuite standard In Stock field). What I want to do is source the latest stock status record and display in a custom field on the item record.
So I may have 5 stock status records - some say In Stock or Backordered but I want my custom item field to source the latest one. That way I can display the most recent stock status on our website. I created a custom item field and put in the formula {custstockstatus.custitemstockstatus} and I nested that within MAX statement. It does indeed work but the behavior is not exactly what I was expecting. Is there away to tweak this formula to show the most recent stock status record?