Linked Transactions

Modified on Sat, 29 Jun at 1:10 AM

Overview

LINKING EXAMPLES

Usage

SUBJECT AREA	DATA MODEL
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

Notes

The method currently used by QQube for Linked Transactions works,but is somewhat kludgy because of how databases work. If you have multiple links for one transaction, then the items/amounts in the original transaction are repeated as many times as there are linked transactions.

So QQube has two 'Running Counter' fields to get around this technology anomaly.

Txn Detail Count
Txn Linked Count

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

Its greatest use is in determining the cash source of a transaction e.g. what bank account the final dollar rests. More info on Cash Source

The Linked Transaction folder is linked to the main FACT folder containing the measures.

EXAMPLES OF LINKS EXPOSED IN QUICKBOOKS
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	PO to Bill Bill to Bill Payment Check Bill to Vendor Credit Vendor Credit to Bill Journal Entry to Any Transaction

LINKS NOT EXPOSED IN QUICKBOOKS
Invoices and Bills Sales Order to Purchase Order	Time Tracking to Payroll Journal Entry to a Journal Entry

Second Method for Linked Transactions

This method is much easier, but only works for posting transactions, and is found in the General Ledger Data Model. It uses a Master Linking Number and allows you to see linked transactions - one underneath another.

QQube General Ledger Linked Transactions