Hi Guys, I am creating a saved search to pull fixe...
# general
v
Hi Guys, I am creating a saved search to pull fixed assets along with their depreciation journal entries number. Initially, I created a saved search on Fixed Assets but didn't get the journal number. Then, I tried various methods using a saved search on the FAM Depreciation History, where I can obtain the asset number and depreciation record number, but I am still unable to get the journal number (posting reference). Any help would be really appreciated.
r
It sucks, but when they made the processing "improvements" in FAM a couple years ago, they seem to have killed off all the places that linked JEs back to specific Assets. I think that place that shows it in Depreciation History is just some script running on demand in the background that generates the link and shows it there when you bring up the window. Anyway, enough complaining. If you run the out of the box report (not search), Asset Monthly Depreciation Monthly report, it will show a direct link between the asset and JE. I can't remember at the moment how I got that info out of that report into some sort of usable format though. Maybe you can figure that part out. I thought it used to be available in CSV format, but it doesn't appear to be now. That's the only exportable way I was able to find where the link still exists.
f
Instead of creating a saved search based on the "FAM Asset" record, try creating it based on the "FAM Depreciation History" record (DHR). As DHR has a foreign key related to FAM Asset record