Do you know how to link "Balancing Journal" line to the source detail transactions using the SuiteAnalytics Connect (SAC) via ODBC connection to the "NetSuite2.com" data source?
Pulling data from NS for a custom data warehouse, using SuiteAnalytics Connect (SAC) via ODBC connection to the "NetSuite2.com" data source, and trying to find the link between the Balancing Journal Line and the source detail transactions.
We've reviewed these related items below...
Via UI - Transactions - Financial - Balancing Journals - View - Balancing Journal - Lines - Details:
provides the source transaction details we need in the UI, but not finding in the SAC "NetSuite2.com" data source yet
Via UI - "Balancing Link" Search returns the items below we need through UI, but not found yet in SAC "NetSuite2.com" data source yet
Paid Transaction Internal Id
Paid Transaction Line Number
Target Internal Id
Target Line Number
Source Internal Id
Source Line Number
Via Records Catalog, searches haven't found a link between source and target yet
Transaction > sourceTransaction?
Regular join (Field ID)
Transaction - transaction(sourceTransaction)
Join pairs
transaction.sourcetransaction = transaction.id
Via SAC ODBC, in Transaction, sourceTransaction is NULL for all records
From the Connect Browser
Transaction Links
From SuiteAnswers 91127 - Viewing Balancing Journals
Balancing journal lines include a Details link that opens a Balancing Link Default View page from which you can access the source transaction.
Any assistance is appreciated.
Thanks,
Berkley