Specialized Drill Downs and Bring Backs

Data Access Studio provides the following JDE-specific Drill Downs and Bring backs:

Drill Down / Bring back	Description
Account balance -> Account ledger	Gets Account ledger (F0911) transactions for a period balance. Right-click amount cell on Quick Report (Relative Period) reports or Account Balances table (F0902).
Asset account balances -> Account ledger	Gets Account ledger (F0911) transactions for a period balance. Right-click amount cell on Quick Report (Relative Period) reports or Account Balances table (F1202).
Purchase order -> Account ledger	Gets Account ledger (F0911) transactions for a purchase order. Right-click Purchase Order Detail file (F4311) document number cell.
GL Document -> Transactions for document	Gets all transactions for a given GL Document. Right-click Account ledger (F0911) document number cell.
Batch Number -> Transactions for batch	Gets all transactions for a given GL Batch number. Right-click Account ledger (F0911) batch number cell.
Account ledger -> Accounts Payable	Gets the de-duplicated AP records for the corresponding GL records. Right-click Account ledger (F0911) document number or amount cell.
Account ledger -> Accounts Receivable	Gets the de-duplicated AR records for the corresponding GL records.Right-click Account ledger (F0911) document number or amount cell.
Account ledger -> Account balances	Gets the period posting values for a set of Account ledger transactions. Right-click Account ledger (F0911) amount cell.
Account ledger -> Work Order	Gets the work order data for the Account ledger sub-ledger. Right-click Account ledger (F0911) sub-ledger cell (where row is sub ledger type W).
Account ledger -> Address Book	Gets address book master data for the Account ledger sub-ledger. Right-click Account ledger (F0911) sub-ledger cell (where row is sub ledger type A).
Work Order -> Parent Work Order	Gets the parent work order for given Work Order. Right-click Work Order Master file (F4801) parent work order number cell.