Joining Transaction Line and Transaction Accounting Line in a Dataset

In the Saved Search application, by default a Transaction saved search could include both accounting and operational data. In SuiteAnalytics Workbook, to include accounting and operational data in a transaction workbook, you might need to join three record types in a single dataset: transaction, transaction line, and transaction accounting line. These record types exist in one-to-many and many-to-many relationships, which can cause data duplication. For more information, see Data Duplication Based on Record Joins. There additional implications you should be aware of when joining these record types in a dataset:

The following video demonstrates how data can be impacted by joining the transaction line and transaction accounting line record types in a dataset.

Related Topics

Guidelines for Joining Record Types in SuiteAnalytics Workbook
Data Duplication Based on Record Joins
Join Order in SuiteAnalytics Workbook

General Notices