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.
FAM Saved Search SQL help...
Hi all,
I'm sure one of you has got this.
I am trying to create a dynamic FAM Register that works better than the standard FAM Asset Register (Saved Search).
Because this search is based on Depreciation history and not Asset records one problem I am facing is that for assets fully depreciated on import (ie. i never depreciated them through the FAM module) the NBV is showing as the full asset cost - because there are no depreciation records. The NBV on the asset record however is correct. I cant simply say for any Full Depreciated assets give me the NBV from the asset record becuase there are some assets that were fully depreciated by the module and this will take away the dynamic aspect (using the filtered date