This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Question for you all. If I go into a depreciation history record, for each month of depreciation I can see the related journal (and click on the link).

If I run a saved search on depreciation history, the field "Posting Reference" is completely blank. How is netsuite displaying this field in the UI, but not returning it in a search?

It is returning something in analytics for the disposal entries, just not for depreciation. Which is infuriating? Is there any way I can get to this info using ODBC, saved searches, analytics or suiteQL?

An answer!
You need to look at the BG summary table, and join the BG_summary_name to the depreciation_history_name. This can get you to the journal_internal_id, so you can work out posting period from that. I've only tested it on recent data but it seemed to work for what I needed

Note this join isn't available in Analytics so you have to roll your own via ODBC (or SuiteQL I guess; haven't tried it)