Is it possible to get the posting reference for th...
# suiteql
c
Is it possible to get the posting reference for the FAM Depreciation Journals? I tried to pull "custrecord_deprhistjournal" values are blank if I look at the underlying depreciation record, but when looking at the history a posting reference is present. The only time I see it located under the record itself is for disposals.
j
Sorry this is coming from the netsuite.com data source, but BG summary records join to deprecation history records on fam_depreciation_history_name = bg_summary_records_name and then you can get back to the transaction table using journal_internal_id on the BG summary table
c
oh I believe we are using the Netsuite2 and I guess thats the problem. I am using a SuiteQL query to get the data.
j
yeah we haven't made the jump to Netsuite2 yet. Dreading it. My rudimentary knowledge of how it all hangs together is worth nothing