Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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