Hi currently looking to do a data audit on an Ellipse system and in particular on the Assets
The info I require are Assets currently having a WDV (Written Down Value)
Assets fully depreciated excluding (Assets Under Construction)
Assets have a WDV between 0.01 and 100.00
I know that the tables are MSF685, 686, 687 but unsure of which fields I need and the calculations that I need to do on them.
By the way it needs to be at the database level not the GUI level.
The info I require are Assets currently having a WDV (Written Down Value)
Assets fully depreciated excluding (Assets Under Construction)
Assets have a WDV between 0.01 and 100.00
I know that the tables are MSF685, 686, 687 but unsure of which fields I need and the calculations that I need to do on them.
By the way it needs to be at the database level not the GUI level.