You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to add Asset Category and Project Number to What-if Report?



We are trying to add  Asset Category and Project Number to the code of the delivered What-if Report. Please see attached SQL.

We added a few joins, but the results are way off just running the What-if by itself.

Has anyone attempted this (in order to send future depreciation to your planning system)?

Any advice on better tables to join, or join a different way?

Thanks, Brad

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

see attachment

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!