Linked Transactions

Modified on Sun, 26 Jul at 3:36 AM

Overview

QQube exposes transaction links that QuickBooks makes available through the Intuit Software Development Kit. These links show how one transaction relates to another, such as an estimate linked to a sales order or an invoice linked to a payment.

The following examples illustrate linked transactions in QuickBooks and QQube.

Examples of linked transactions in QuickBooks

Linked transaction fields in QQube

Where Linked Transactions Are Available

Subject Area	Data Models
Customers	Sales Open Sales Orders Accounts Receivable
Operations	Purchasing Open Purchase Orders Accounts Payable Inventory Management Job Cost Details
Finance	General Ledger Detail Profit and Loss Detail Cash Position
Auditing	None

How the Linked Transaction Folder Works

The Linked Transaction folder is related to the main FACT folder that contains the measures.

When one transaction has multiple linked transactions, the original transaction lines and amounts are repeated once for each link. This is a normal result of the one-to-many relationship between the original transaction and its linked transactions.

Prevent Duplicate Amounts

QQube provides two running-counter fields that allow the original amount to be allocated across the linked transaction rows:

Txn Detail Count
Txn Linked Count

Original Line Amount * (Txn Detail Count / Txn Linked Count)

Common Use

One of the most useful applications is determining the cash source of a transaction, including the bank account where the final amount resides.

See Cash Source Reporting for more information.

Links Exposed by QuickBooks

Customer-Side Links	Vendor and General Links
Estimate to Sales Order Sales Order to Invoice Invoice to Payment Invoice to Deposit Sales Receipt to Deposit Payment to Deposit Invoice to Credit Memo Statement Charge to Credit Memo Credit Memo to Invoice Credit Memo to Statement Charge	Purchase Order to Bill Bill to Bill Payment Check Bill to Vendor Credit Vendor Credit to Bill Journal Entry to Any Transaction

Links Not Exposed by QuickBooks

QuickBooks does not expose the following transaction relationships:

Invoices and Bills
Sales Order to Purchase Order

Time Tracking to Payroll
Journal Entry to Journal Entry

Alternative Method in General Ledger Detail

A second method is available in the General Ledger Detail Data Model.

This method uses a Master Linking Number to display related posting transactions one beneath another. It is easier to use, but it applies only to posting transactions.

Linked transactions using the Master Linking Number in QQube General Ledger Detail